[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
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.
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 220.127.116.112 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:
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:
This command will re-optimize all QuickBooks data and create a new opt file in the folder you assigned.
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.