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