Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - Freezing QuickBooks, slow query running
Posted by Jack - QODBC Support on 16 December 2014 09:46 AM

Troubleshooting - Freezing QuickBooks, slow query running.

Problem Description:

When I run a report query, the query works very slowly & takes about 1-5 mins per simple report like:

"sp_report ARAgingSummary show Current parameters DateFrom={d'2014-11-12'}, DateTo={d'2014-11-12'} where Blank = 'Total'"

Sometimes it freezes QuickBooks, so the user should restart it.

Solutions:

Please enable the QODBC status panel via Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source.

Go To the "System DSN" Tab, Select "QuickBooks Data" DSN & click "Configure."

Navigate to the "Message" tab ->Select "Display Driver Status" and "Display optimizer Status" options.

 

http://support.flexquarters.com/esupport/newimages/FreezingQuickBooks/step1.png

 

Then the next time you run a query, if you see "Waiting for QuickBooks," it means QuickBooks is taking time to process the request. 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. Please note the step on which QODBC spends the most time or gets stuck and share it with us.

If you are getting "Waiting for QuickBooks," it means QuickBooks is taking time to process requests. So we may not provide much help on this issue.

QuickBooks SDK provides data in XML format & QODBC displays it in tabular form. QODBC acts as a 'wrapper' around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools, speeding development time. QODBC accepts SQL commands from applications through the ODBC interface, then converts those calls to navigational XML commands to the QuickBooks Accounting DBMS and returns record sets that qualify for the query results.

QODBC requests the Report information from QuickBooks SDK, and QuickBooks is the one processing it and sending the output. QODBC formats that output to data table format.   

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