[QODBC-Desktop] Troubleshooting - Wrong Data in Excel from QODBC
Posted by Jack - QODBC Support on 10 November 2014 02:25 PM

Problem Description:

We modified an invoice in QuickBooks and we are trying to get the data out in Excel, but QODBC gives us the old data still.



QODBC failed to return full records is usually caused by either corruption of QODBC optimizer file. I would like to inform you that Optimizer file may be corrupted if you are killing process or query while optimizer file is building. It is not advisable to kill query while it is in execution.

Please reset the optimizer to solve the problem.

1) Close all other applications that use QODBC.

2) Turn off QODBC optimizer (QODBC Setup Screen->”Optimizer” tab->Uncheck “Use optimizer” option)

3) Find the file with .opt extension at the path you had assigned to QODBC optimizer and delete the optimizer file.

(The default path is %AppData%\QODBC Driver for QuickBooks\Optimizer)

You can find optimizer folder path from QODBC Setup Screen->”Optimizer” tab. Please copy this path & navigate to this path & delete .opt file.


You can directly delete .opt file from:

Start>>All Programs>> QODBC Driver for use with QuickBooks>>QODBC Setup Screen>>”Optimizer” tab>>Click "Reset Optimizer File(s)".


4) Turn on QODBC optimizer (QODBC Setup Screen->”Optimizer” tab->Check “Use optimizer” option)

5) After turning on the optimizer, please run below command in VB Demo:

sp_optimizefullsync All

This command will bring some data to a local cache to increase retrieval performance for queries. I would like to suggest you 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.

6) Please test again to see if the problem is still there.

7) After completing above steps, please test data from VB Demo application. If you are able to get updated data, then please refresh Excel sheet so you can get updated data.

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).