Knowledgebase
[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.

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.

(167 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).