Knowledgebase: QODBC
[QODBC-ALL] Troubleshooting - QODBC hung up or everything looks locked up or Application is Not Responding when fetching QuickBooks Data
Posted by Jack - QODBC Support on 09 March 2018 11:45 AM

Troubleshooting - QODBC hung up, or everything looks locked up, or Application is Not Responding when fetching QuickBooks Data

Problem Description:

I can access the database, but when I added another table & fetch table data, it generally hung up. Not sure if I need to change anything. Any thoughts?

Solution:

When accessing any table for the first time, QODBC will bring table specific data to the optimizer file to increase retrieval performance for queries.

Once the optimizer is built, accessing the same table will be much faster when compared to accessing it the first time or without the use of the optimizer.

Please refer to How Optimizer Works for more details.

If you see the QODBC icon (not hourglass) in System Tray, it means QODBC is connected to QuickBooks, and currently there is no query executing.

When QODBC hangs up or your application goes to Not Responding mode. You can check what QODBC is performing from Windows System Tray.

You will notice the QODBC icon in Windows System Tray showing hourglass.

If you want to see what QODBC is performing, then right-click on the QODBC icon & click "Driver Status Panel".

QODBC will open the UAC window, and please click on "Yes" in the UAC window to open the "Driver Status Panel."

There will be a status panel at the lower right corner of your screen, showing a window with information on what QODBC is working at.

If you see "Waiting On QuickBooks", It means QuickBooks is taking time to process the request.

If you want to permanently enable the "Driver Status Panel, " refer to How to view details on what QODBC is performing / Display Driver Status / Display optimizer Status.

 

 

Suggestion:

Suppose you have a large company file with multiple years. QuickBooks and QuickBooks SDK would require more time to process your data required.

We would suggest splitting the company file to make it smaller. You can keep the historical data in one company file and the latest one in another.

This way, your company file will be smaller and with a smaller number of records.

Refer to 

https://quickbooks.intuit.com/learn-support/en-us/other-questions/best-way-to-split-large-company-file/00/1081335

https://quickbooks.intuit.com/learn-support/en-us/account-management/create-a-new-company-file-from-the-existing-company-file/00/203213

 

If the Above Solutions don't work, please post a ticket to us, and we will investigate your issue further.

Also, Refer:
Troubleshooting - Cannot load Customer table records.

 

Suggestion:

Suppose you have a large company file with multiple years. QuickBooks and QuickBooks SDK would require more time to process your data required.

We would suggest splitting the company file to make it smaller. You can keep the historical data in one company file and the latest one in another.

This way, your company file will be smaller and with a smaller number of records.

Refer to 

https://quickbooks.intuit.com/learn-support/en-us/other-questions/best-way-to-split-large-company-file/00/1081335

https://quickbooks.intuit.com/learn-support/en-us/account-management/create-a-new-company-file-from-the-existing-company-file/00/203213

 

Keywords: QB odbc slow, multiple web queries into excel slow running, excel running background query slow, qodbc and excel connection speed

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