Problem Description:
I am trying to use QODBC with Crystal Reports 11, but I'm also having similar results with the QODBC Test Tool included with the driver. Many queries, such as "select * from invoice," cause the program to hang. With Crystal Reports, I'm just trying to add the invoice table to the report, and Crystal freezes with a message of "accessing records" in the status bar. While Crystal and QODBC Test Tool are frozen, QuickBooks also freezes, but only until the app is forced to close, and then QuickBooks begins responding again.
Solution:
There might be some issue with the Optimizer file. There are many situations where your Optimizer file is out of sync or corrupted; one common reason is killing the application when accessing/updating the optimizer file.
Please close the QODBC optimizer (QODBC Setup Screen->Optimizer Window->Uncheck the "Use Optimizer" option) and test again to see if the problem is still there.
If it fixes the issue, Please reset your QODBC optimizer according to the steps below:
Close all applications other than QuickBooks/Reckon.
1) Remove the old Optimizer file. Please refer:
How to Remove Optimizer file
2) Please run the below command in QODBC Test Tool:
sp_optimizefullsync ALL
Please refer:
How to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for Selected Tables
The sp_optimizefullsync command will bring some data to a local cache to increase query retrieval performance. I want to suggest you please let run the above command completely. The above command may take some time, depending on your QuickBooks records. It may take 2-24 hours or more, depending on the number of records in the QuickBooks company file. Please let this command run completely; do not kill this command. It is not advisable to kill/close the application while it's building the Optimizer file.
4) Close QODBC Test Tool
5) Please test again to see if the problem is still there.
|