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 the case of your Optimizer file being corrupted or the QuickBooks Company file needing Rebuild/Repair.

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

Then use our QODBC Test Tool to test again to see if the problem is still there.

If about does not resolve the issue, You may have to Re-build your company file. Please refer: To how to Re-build a QuickBooks Company File.

 

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

For QODBC 13.0.0.292 or above, Resetting the Optimizer file is on single click. You can click "Reset Optimizer File" and then Run sp_optimizefullsync ALL command in QODBC Test Tool:

Refer:  How to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for Selected Tables


Otherwise, follow the below steps.

You need to reset your opt file store path. You can 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 QODBC Test Tool:

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

If you are using a connection string or linked table in MS Access to connect to QuickBooks, please remove the former connection string or linked table 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).