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
|
|
QODBC connection lifecycle |
Author |
Message |
|
Posted : 2009-01-18 07:09:56 |
I have VB6 application that query's Quickbooks 2008. 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 alot of network traffic in maintaining the connection when it is not needed? Thanks Steve |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-18 11:01:21 |
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. |
|
|
|
|
Posted : 2009-01-24 13:24:55 |
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? Thanks Steve |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-25 16:37:54 |
You don't. 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.
|
|
|
|
|