Knowledgebase
[QODBC-Desktop] Troubleshooting: QODBC hangs with Crystal Report
Posted by Jack - QODBC Support on 30 October 2015 09:27 AM

Problem Description:

I am are 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 is corrupted; one of the common reasons 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 the 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 retrieval performance for queries. I would like to suggest you, please let run the above command completely. The above command may take some time depends on your records in QuickBooks. It may take 2-24 hours or more depends 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.

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