Troubleshooting - QB Begin Session Failed. Error = 80040417
Problem Description:
When using your QODBC Driver with my custom application, coded in Java, the application can connect and retrieve data if QuickBooks is running with the company file already open.
However, when the QuickBooks program is NOT running on the local machine, the QODBC is supposed to be able to connect to the database on its own, in the background.
I am consistently getting the "80040417" error.
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040417, If the QuickBooks company data file is not open, a call to the "BeginSession" method must include the name of the data file.
Please let me know what I am doing wrong.
Solutions:
The 80040417 error occurs when the file path specified on the QODBC Setup Screen differs from the Company file opened in QuickBooks.
Please verify your auto-login setup. After you set auto-login, you can access QuickBooks without opening it. Please refer to the below article for more information:
How to setup QODBC for Auto-login into QuickBooks
How to set up QODBC Driver to auto-connect to QuickBooks. (Video)
When you set up Auto-login, Please verify the company file path on QODBC and QuickBooks. These two paths should be the same. The QODBC company file path can be found via the QODBC setup screen -> General tab. You can find the QuickBooks company file via QuickBooks UI. Press the F2 key you will see the file information.
Please note you can connect to only one company file at a time. I. If you want to connect to another file, you need to disconnect the connection from your application and connect to another.
|