How to Configure & Setup ODBC Driver in QuickBooks Enterprise

ODBC Driver: QuickBooks Enterprise

QuickBooks in collaboration with FLEX Quarters (Intuit Developer Network member) in order to structure an ODBC driver (read-only) which was labeled as QODBC to be employed with QuickBooks Enterprise software.

This driver can be located within QuickBooks Enterprise software by navigating towards the File tab from the main menu, followed by the Utility option, and then click on the Setup QODBC option. It basically allows users to access the software data through 3rd party programs like Microsoft Access, Microsoft Excel, Crystal Reports, etc. In case data has to be written back then it is better to connect with the QuickBooks Customer Service team through


Configure and Setup ODBC Driver of QuickBooks Enterprise

QODBC driver incepted for QuickBooks Enterprise software accords user with the option to export company file and business data to 3rd party applications like Microsoft Access, Microsoft Excel, Filmmaker, Crystal Reports, Python or.NET, etc in order to generate customized reports. In order to configure this driver follow the steps below:

  1. Under QuickBooks software click on the File menu option, followed by the utility tab, and then click on Set Up ODBC.
  2. Now select the tab labeled General and follow the steps below:
    • 1. Click on the ‘Use the Company file’ option that’s now open on the new QuickBooks screen.
    • 2. Under the Data Source Name, type QuickBooks Data.
    • 3. Select the option called Test Connection to QuickBooks.
  3. A message will be prompted on-screen displaying “Test Connection to QuickBooks Successful” wherein the user should click on the Ok tab and then on the Apply button.
  4. Now select the option of Messages and perform the following steps:
    • 1. Uncheck the box against the Detail Tracing (if enabled).
    • 2. Click on the Display Optimizer Status Panel checkboxes (if disabled).
    • 3. In order to view details of what QODBC is working on, then click on the Display Driver Status Panel (it is optional).
    • 4. Lastly click on the Apply tab.
  5. Next, Click on the Optimizer tab and follow the steps:
    • 1. Click on the Use Optimizer box (if disabled).
    • 2. Default Optimizer file path is usually displayed as – (%AppData%\QODBC Driver for QuickBooks\Optimizer). This is the advised path to use.
    • 3. Click on the option The start of every query (if not selected) and then click on Apply
  6. Lastly, select the OK tab to close the setup of QODBC.


Now you should be able to use ODBC Driver in order to transfer data to third party reliable applications. In case you get stuck somewhere or require more information about the same driver, you should get in touch with the QuickBooks technical team. In the scenario that the support team is not able to connect, you can try to get in touch with our proficient team by dialing the toll-free number

Related News:

QuickBooks Enterprise Contractor 2018

Unique Advantages of QuickBooks Enterprise

Source: 99accounting

    Report your Issue

    QuickBooks Version:

    Edition Year:

    No of User: Licence

    Operating System:

    HELP Needed:

    Report an Issue


    Business Accounting Tollfree Number
    Toll-Free: +1800-974-3985 user