Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Cannot connect when QB file is open |
Author |
Message |
|
Posted : 2006-09-25 00:00:32 |
After successfully testing a simple program to check for and then insert items to QB on a development computer, I transferred the QODBC license to the deployment machine and have problems.
The connection to the QB file is successful only when QB is not running. This is not the case when using the VB Demo (nor was it the case on the development computer with the same QB file and same version of QuickBooks -- QB Pro 2005.)
I have tried with QuickBooks open in single-user mode (which worked in development, and works with VB Demo), open in multi-user mode, and then in multi-user mode logging in through QODBC with a different user name. They all fail.
I have also run the QuickBooks reboot.bat (still fails), then uninstalled and reinstalled QuickBooks (still fails).
The development environment is Java JRE 1.5.0_08, using sun.odbc.jdbc.com drivers. The exception output at the QODBC code level is:
[QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
The output in the qbsdklog.txt file in "\Program Files\Common Files\Intuit\QuickBooks" contains:
20060924.091542 I 2148 CertVerifier The file does not contain an Authenticode signature.
20060924.091542 I 2148 RequestProcessor ========= Started Connection ========= 20060924.091542 I 2148 RequestProcessor Request Processor, QBXMLRP2 v4.0 20060924.091542 I 2148 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20060924.091627 E 2148 RequestProcessor An internal error occured while looking for a running instance of QuickBooks. Cannot continue. hr = 80080005 20060924.091627 I 2148 RequestProcessor Connection closed by app named 'FLEXquarters QODBC' 20060924.091627 I 2148 RequestProcessor ========== Ended Connection ==========
The successful output in the qbsdklog.txt file when QuickBooks is closed starts with: 20060924.092400 I 2148 CertVerifier The file does not contain an Authenticode signature.
20060924.092400 I 2148 RequestProcessor ========= Started Connection ========= 20060924.092400 I 2148 RequestProcessor Request Processor, QBXMLRP2 v4.0 20060924.092400 I 2148 RequestProcessor Connection opened by app named 'FLEXquarters QODBC' 20060924.092407 I 2148 RequestProcessor Opening the file in the DoNotCare mode. 20060924.092421 I 3632 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 2148). 20060924.092423 I 3632 SpecVersion Current version of qbXML in use: 4.0 20060924.092423 I 3632 QBSDKMsgSetHandler QUERY: Host 20060924.092423 I 3632 QBSDKMsgSetHandler Request 1 completed successfully. ... etc ... |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-25 00:16:56 |
Your sun.odbc.jdbc bridge is running as a service, which means you need to use auto-login mode with a company path setup in your DSN. If you want the QuickBooks user interface to be active, check the "Launch QuickBooks UI" option in the QODBC Advanced Setup.
|
|
|
|
|
Posted : 2006-10-01 05:01:42 |
The auto-login was properly set, but I had unintentionally just accepted the default of "Use the file open in QuickBooks" rather than supplying the path. However, it's still not working consistently.
It seems to work once or twice, then stop. Then it takes repeatedly opening/closing the QuickBooks file with no recognizable pattern or settings to get it to work again. Then it's only once or twice anyway.
It continues failing with the 8004041c error originally described.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-02 11:29:07 |
Decide whether you want to use the QuickBooks User Interface or not and let the system work. You also can only use the one Company file as you can't open more than one company file in QuickBooks and your company file must be in multi-user mode.
It may take about 10 minutes before the company file is released by the Windows O/S when using your sun.odbc.jdbc bridge. |
|
|
|
|