Troubleshooting: An internal QuickBooks error occurred while accessing the QuickBooks company data file.

Problem Description

When using QuickBooks Premier 2007 Canadian Edition and QODBC 7.0.0.214. We try to connect to the QB database with the help of the ADODB Connection object using connecting.

Connection String: "DSN=QB;DFQ=C:\Sample.qbw"

But with the above connection string, the connection cannot be established, and QODBC gives an error message “An internal QuickBooks error occurred while trying to access the QuickBooks company data file.”

However, the connection gets established successfully for the same database in QODBC Support Wizard.

Solution

When you use a DFQ= value in a connection string, QuickBooks must be closed, and the company file must load in unattended mode. See: How to setup QODBC for Auto-login into QuickBooks and Connection String with QODBC Parameters for more.