Knowledgebase: Others
[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 trying to access 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 QB database with the help of ADODB Connection object using connecting.

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

But with above connection string, connection unable to establish 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 VB DEMO.

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).