Troubleshooting - Freezing QuickBooks, slow query running.

Problem Description:

When I run report query, query works very slow & take 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 QODBC status panel via: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source

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

Navigate to "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, will be shown a window with information on what QODBC is working at. Please note the step on which QODBC spends the most time or get stuck and share it with us.

If you are getting “Waiting for QuickBooks” which means QuickBooks is taking time for processing request. So we may not provide much help on this issue.

QuickBooks SDK is providing data in XML format & QODBC is displaying it in the tabular format. QODBC works by accepting SQL commands from applications through the ODBC interface, then converting those calls to navigational XML commands to the QuickBooks Accounting DBMS and returning record sets that qualify for the query results. 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.

All QODBC do is the request for 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.