Knowledgebase: Connection
[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, everything looks locked up, or the 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 query retrieval performance.

Once the optimizer is built, accessing the same table will be much faster compared to accessing it the first time or without using 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 QuickBooks company file with several years of data.
The QuickBooks SDK has to scan and process many records to extract data, resulting in performance issues and slowness.
Historical data may not be required in day-to-day transactions/reports.
It is advisable to reduce the size of large QuickBooks company files for better performance.
To reduce the size of the QuickBooks company file, you can consider archiving old data.
To archive old data, you can create a copy of the company file and save the company file under a new name.
Condense the new QuickBooks Desktop company file.
You should notice performance gains when using a condensed QuickBooks company file.
You can always refer to the archived data at any time using the QuickBooks application or QODBC.


Refer to
https://quickbooks.intuit.com/learn-support/en-us/help-article/data-utilities/use-condense-data-utility/L7zprPIcj_US_en_US
https://quickbooks.intuit.com/learn-support/en-uk/other-questions/quickbooks-desktop-2020-condense-data-utility/00/532124
https://quickbooks.intuit.com/learn-support/forums/searchpage/tab/message?advanced=false&allow_punctuation=true&q=condense%20data
https://quickbooks.intuit.com/learn-support/en-us/other-questions/condensing-a-large-file/00/573043
https://quickbooks.intuit.com/learn-support/en-us/other-questions/best-way-to-split-one-company-file-into-two-originally-used-for/00/810101

 

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

Also, refer to the following:
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 fewer 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).