Knowledgebase: TroubleShooting
[QODBC-Desktop] How to view details on what QODBC is performing / Display Driver Status / Display optimizer Status
Posted by Rajendra Dewani (QODBC Support) on 14 April 2014 04:06 PM

How to view details on what QODBC is performing

Problem Description:

QODBC and my application are not responding. How can I know what QODBC is performing in the background?

Solution:

You can 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.

 

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

 

 

 

Tags: configurations, why QODBC is slow. QODBC not responding

(0 vote(s))
Helpful
Not helpful
Comments (3)
Mike Christensen
26 June 2017 12:49 PM
Is there any way to turn the Driver Status Panels dynamically? That is, to use something like a batch file, vbs, or similar to do this so a user does not have to. Or a way to enable the Panels as default?
Jack
26 June 2017 01:32 PM
Hi Mike,

No, There is no way to change it programmatically.

I would like to share that Messages Tab settings are stored in ODBCINST.INI file.

C:\ProgramData\QODBC Driver for QuickBooks\odbcinst.ini

To enable Driver Status Panels. You can add below line in ODBCINST.INI file.

DebugPanel = Yes
Mike Christensen
27 June 2017 03:49 PM
Thank you! By instructing my clients to use the default installation the QODBC uses I can now utilize code within my applications that checks this file and adds/change the DebugPanel to equal Yes. One less issue that I will have to contend with when creating applications I build that would otherwise require user actions and/or instructions.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).