[QODBC-Desktop] Troubleshooting: An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
Posted by brad waddell on 12 March 2009 05:21 PM
Troubleshooting: An internal QuickBooks error occurred while accessing the QuickBooks company data file.
When using QuickBooks Premier 2007 Canadian Edition and QODBC 188.8.131.52. 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.
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 set up QODBC for Auto-login into QuickBooks and Connection String with QODBC Parameters for more.