Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting: QODBC Hangs When Trying to Execute Query or View Tables
Posted by Rajendra Dewani (QODBC Support) on 11 January 2013 12:36 PM

Troubleshooting: QODBC Hangs When Trying to Execute Query or View Tables

Problem Description:

When executing a simple query like:

SELECT * FROM Invoice

Application and QuickBooks will both get hang, and it Does Not Respond.

Then After, the application is forced to close, QuickBooks becomes normal again.

Solution:

This may be case of your Optimizer file is corrupted or QuickBooks Company file needs Rebuild/Repair

Close All application using QODBC & un-select "Use Optimizer" (QODBC Setup Screen->Optimizer Window->Uncheck "Use Optimizer" option).

Then use our test tool VB Demo to test again to see if the problem is still there.

If about does not resolve the issue, You may have to Rebuild your company file.  Please refer: How to Rebuild a QuickBooks Company File

 

And if QODBC works with optimizer turning off, then there might be problem/corruption in your optimizer file.

For QODBC 13.0.0.292 or above, Resetting Optimizer file is on single click, you can click "Reset Optimizer File" and then   Run     sp_optimizefullsync ALL command in VB Demo:

Refer:  How to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for Selected Tables


Otherwise, follow below steps

You need to reset your opt file store path. You can simply find the path setting at QODBC Setup Screen->Optimizer Window.

 

The default path is "%UserProfile%\QODBC Driver for QuickBooks\Optimizer", please set it to "%appdata%\QODBC Driver for QuickBooks\Optimizer" or use another folder which you have full authority to access it.

After the path setting is completed,

Navigate to that Path,  Start -> Run -> and then type the Optimizer file path, Delete the .OPT ( corresponding to your company file )

Please run this command in VB Demo:

sp_optimizefullsync all

 

This command will re-optimize all QuickBooks data and create a new opt file in the folder you assigned.

Refer:  How to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for Selected Tables

In-case you are using connection string or linked table in MS Access to connect to QuickBooks, please remove the former connection string or linked tables and re-build a new one to make sure that it points to the new opt file store path.

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