RE: How to Install and Configure the QuickBooks Enterprise ODBC Driver?

how to use the ODBC Driver in QuickBooks configure and what is the way of use it?

Add Comment
2 Answers
  1. In QuickBooks, select the File menu, then choose Utilities > Set Up ODBC.
  2. Click the General tab.
    1. Select Use the Company file that’s now open in QuickBooks option.
    2. In the Data Source Name, enter QuickBooks Data.
    3. Click the Test Connection to QuickBooks button.
    4. Note: You must be signed in to your company file as “Admin” to be able to successfully run the test connection.
  3. When the message “Test Connection to QuickBooks Successful” appears, click OK, then choose Apply.
  4. Choose the Messages tab.
    1. Clear the Detail Tracing (Slow) checkbox (if enabled).
    2. Select the Display Optimizer Status Panel checkboxes (if disabled).
    3. Optional: To view details of what QODBC is working on, select the Display Driver Status Panel.
    4. Note: When selected, QODBC detailed information will appear on a window above the system tray. This will show information such as the number of records processed and the current running activity in QODBC. It will also provide assessment of speed using optimized and non-optimized data, which will serve as an indicator if troubleshooting steps for the software’s performance need to be done.
    5. Click Apply.


  1. Click the Optimizer tab.
    1. Select the Use Optimizer box (if disabled).
    2. Default Optimizer file path is (%AppData%\QODBC Driver for QuickBooks\Optimizer). This is the recommended path to use.
    3. Select The start of every query (if not selected), then click Apply.
    4. Note: Initial optimization time may vary depending on the file size. It usually takes 24 hours. The more transactions are made, the longer optimization will take. Once completed, data connections with QuickBooks will run faster.
  2. Click OK to exit the ODBC Driver setup.


For more detail about QuickBooks Enterprise ODBC driver then visit our online support link QuickBooks online support or Dial +1-844-551-9757. Our support team will happy to help you.


Answered on July 26, 2017.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.