[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 that the company file is already open and is different from the one requested. I only have one company file.
The error is saying 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 could find the QuickBooks company file via QuickBooks UI, press F2 key you will see the file information.
You can select "Use the Company file that's open in QuickBooks" and test again.
Problem Description 2
Now it is able to connect to our file. Here's another problem. I used to run queries in Access. Now when I run my query, 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 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 it is 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:
However, I have QuickBooks open to the file I am trying to connect to, and I am instructing the connection to that file. There is only the one 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's now open in QuickBooks" as follows, then 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 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 and it hits the line:
The message is saying the company file currently open in QuickBooks is different to 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.