[QODBC-Desktop] After upgrading to QuickBooks, QODBC "auto-login" unattended mode no longer works / Error = 8004040a, A QuickBooks company data file is already open and it is different from the one requested
Posted by brad waddell on 12 March 2009 05:21 PM
Troubleshooting: Get Error 8004040a after Update the Driver
Problem Description 1
I updated the driver, and now it will not connect to the company file. I'm getting error = 8004040a. It says the company file is already open and different from the one requested. I only have one company file.
The error is that you have QODBC unattended mode setup as per "Locate a company file" as below, but QuickBooks is already running with a different company file open.
You can find the QuickBooks company file via QuickBooks UI; press the F2 key to see the file information.
You can select "Use the Company file that's open in QuickBooks" and test again.
Problem Description 2
Now it can connect to our file. Here's another problem. I used to run queries in Access. Now when I run my question, no new data shows up. All it has is the data that was put in when I did the link table the first time around. It is used to update the tables.
Try unlinking and relinking the Linked QODBC tables in MS Access.
Troubleshooting: A QuickBooks company data file is already open and different from the one requested. Error Explanation 1
This message, "A QuickBooks company data file is already open, and it is different from the one requested.", has the following explanation:
There is only one file. However, I have QuickBooks open to the file I am trying to connect to, and I am instructing the connection to that file. Why am I getting this message?
Use the company file that's now open in QuickBooks
If QODBC is set up to "Use the company files that are now open in QuickBooks" as follows, it works as expected.
Locate a company file
But if you "Locate a company file,"
Then QuickBooks must not already have a company file open ........ Even if it's the same company file!!!
Troubleshooting: QB Begin Session Failed. Error = 8004040a Explanation 2
I followed the instructions at http://www.qodbc.com/QODBCweb.htm to download and install the demo for the QODBC server edition. I can run TestDCOM.asp - which shows me that DCOM is configured properly. When I go to the QODBC Setup Screen and click the Test Connection button on the General tab - I now get a successful connection. I can also get a successful connection from the ODBC admin. However, when I run my ASP code, it hits the line:
The message is saying the company files currently open in QuickBooks are different from the path of the company file setup in your QODBC Setup for the DSN:
Try closing the company file and let QODBC open the company file.