Knowledgebase: Tutorials
[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 the similar results with the VB Demo 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 VB Demo 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 Optimizer file, There are many situations where your Optimizer file is out of sync or is corrupted, one of the common reasons is killing application when accessing/updating optimizer file.

Please close QODBC optimizer (QODBC Setup Screen->Optimizer Window->Uncheck "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 application other than QuickBooks/Reckon.

1) Remove old Optimizer file. Please refer:

How to Remove Optimizer file

2) Please run below command in VB Demo:

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 to please let run above command completely. 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 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 VB Demo

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