Knowledgebase
[QODBC-Desktop] Troubleshooting: QODBC connection lifecycle with VB
Posted by brad waddell on 12 March 2009 05:21 PM

Troubleshooting: QODBC connection lifecycle with VB

Problem Description:

I have a VB6 application that query's QuickBooks. What are the performance considerations regarding leaving a QODBC connection open when not actively using it? QODBC takes about 10 seconds to make the handshake with the connection string so any query to QuickBooks is very slow if I create the connection each time then close it when the query is completed. However, since this is used over the network will there be a lot of network traffic in maintaining the connection when it is not needed?

Besides, when I open the connection to QuickBooks using QODBC and leave it open I cannot open the QuickBooks file using the QuickBooks interface. I get the message "An Integrated Application is currently sharing data with QuickBooks. Please wait until the application is finished and try again". How do I release the file with QODBC while keeping the connection open?

Solutions:

First, the performance considerations are the same as leaving QuickBooks running. QODBC connects to QuickBooks and is same as using the QuickBooks User Interface. Don't type anything on the keyboard is the same as the connection not running a query.

Second, if you want to use the QuickBooks UI (User Interface) while QODBC is connected you either open QuickBooks and the company file first and then connect QODBC or allow QODBC to auto-launch QuickBooks by checking the Launch QuickBooks UI option instead.

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