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.

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.