Knowledgebase
[QODBC-Desktop] How to switch OFF or RESET the QODBC Optimizer
Posted by Juliet (QODBC Support) on 20 February 2010 03:04 AM

Locate Program and Select Optimizer Tab

     Locate the QODBC Driver for QuickBooks program group on your desktop. Click on the QODBC Setup Screen icon to launch the setup program supplied with QODBC.

     The following General setup screen will become available.

.

     Click on the Optimizer tab page.

Switch OFF the QODBC Optimizer

     Uncheck the Use Optimizer option. Read the location for your Optimizer Database Folder and delete the YourCompanyName.opt file using Windows Explorer:

The default location of the.opt tables is found in your login user profile (%AppData%\QODBC Driver for QuickBooks\Optimizer) & delete the .OPT file.

 

     Leave the Use Optimizer option unchecked to leave the optimizer off.

RESET the QODBC Optimizer

     Check the Use Optimizer option to reactivate and reset the Optimizer. See also: How do I setup the QODBC Optimizer? Where are the Optimizer options?

     Note: You can also schedule full optimization overnight using either: QODBCFUL.EXE or QODBCUPD.EXE. Both set the error level variable if errors are detected, and error messages are written into the log file. Passing a DSN on the command line to these programs will choose the QuickBooks company file you wish to use.

    To temporarily bypass your optimizer settings and extract the latest information you can add the unoptimized tag after the table name like this to your queries:

    select * from InvoiceLine unoptimized where TxnDate >= {d'2006-03-06'}.

    Or you can resync your optimizedInvoiceLine table by running:

   sp_optimizefullsync InvoiceLine

 

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