[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.
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?
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.
Suppose you have a large QuickBooks company file with several years of data.
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:
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.
Keywords: QB odbc slow, multiple web queries into excel slow running, excel running background query slow, qodbc and excel connection speed