Updated
8 min read

The QuickBooks Enterprise Open Database Connectivity (ODBC) driver is an effective tool that allows you to integrate your QuickBooks data with various third-party applications, enhancing your ability to generate detailed reports, custom queries, and complex data analyses. Whether you’re looking to create advanced spreadsheets in Microsoft Excel, build comprehensive tables in Microsoft Access, or design intricate reports in Crystal Reports, the ODBC driver provides the connectivity and flexibility you need.
This article will guide you on how to download, install, and set up the QuickBooks Enterprise ODBC Driver.
To use the QuickBooks Enterprise ODBC Driver, you’ll need to meet the following requirements:
In third-party applications such as Microsoft Excel, Microsoft Access, and Crystal Reports, the Open Database Connectivity (ODBC) driver grants admin access to company files.
Microsoft Excel spreadsheets, Microsoft Access databases, and Crystal Reports reports can be created with ODBC. It is a mirror image of the file in your company. Besides creating custom reports, you can customize invoices, create mail merges, and more by combining data from multiple company files. You can also use Structured Query Language (SQL).
Exporting data from your QuickBooks company file with FLEXQuarters’ ODBC driver allows you to create custom reports. Once a report has been exported, it can be viewed in programs like Microsoft Excel, Crystal Reports, QlikView, Python, or .Net.
Follow these steps:

2. Opt for the QuickBooks region that matches your purchased driver.

3. You can skip the Activation Key to assess the product before purchase. Select Next to continue.

4. Select the location for installing the QODBC files. Enter Next to continue.

5. FLEXquarters QuickBooks QODBC Driver has been successfully installed. You can start using it right away for a 30-day trial period.

6. To install or evaluate the QODBC registration code, check the Start Menu under QODBC Driver for QuickBooks.
7. Click the ODBC Setup Screen icon to begin configuration.
Get Instant Resolution
Talk to the ProAdvisors at QAsolved for fast help with your QuickBooks® question.

QODBC uses the currently open QuickBooks company file, allowing you to switch between files without creating separate DSNs.
Find the path to your QuickBooks data file (e.g., “C:\Program Files\Intuit\QuickBooks Pro\Myapp.qbw”). To select your file, click the browse button (…)
Enter a display name for your QuickBooks data (e.g., QuickBooks Data, QBPRO, My QB Data).
Choose how QODBC should open the file:
This will confirm proper installation and settings. A confirmation popup should appear.


2. Uncheck the Detail Tracing (Slow) checkbox.
3. Check the Display Optimizer Status Panel checkbox.
4. (Optional) To see detailed ODBC activities, check the Display Driver Status Panel checkbox. You can use this to troubleshoot your software performance if needed by viewing the number of records processed, the current activities, and speed assessments using optimized and non-optimized data.
5. Click Apply.


Use this tab to buy a CD Key, activate a license with a CD Key, or deactivate an active license and move it to a new computer.

To fully activate QODBC from the evaluation version, enter your CD Key using the online option. This will switch to the full Read Only, Read/Write, or Web Edition you purchased. In case of internet inaccessibility, you can use the phone option to provide your reseller or distributor with the necessary information to activate the product.

Deactivating QODBC online allows you to transfer your currently registered version to another machine. It typically takes 24 to 48 hours for your CD Key account to be credited with the deactivated license, enabling you to reactivate it on a different machine. The phone option is also available if the registered machine does not have internet access. This entails providing your reseller or distributor with the necessary information to deactivate the product CD Key on your behalf.

The About screen displays the installed QODBC version and indicates if it’s an evaluation or fully registered copy. A serial number’s first letter indicates the type of license, the 2nd and 3rd digits show the QODBC version and the fourth letter indicates the compatible QuickBooks version (US, CA, UK, AU).
For businesses looking to manage and analyze their financial data, installing and configuring the QuickBooks Enterprise ODBC Driver is a crucial step. Connecting QuickBooks to other software makes it easier to pull data for reports and analysis.
The process involves three main steps:
These steps allow you to access and analyze financial data, resulting in better decisions and improved efficiency. With this setup, you can get real-time insights and ensure your financial data is always accurate and up-to-date.
The Open Database Connectivity (ODBC) driver lets you access your company file with third-party apps like Microsoft Excel, Microsoft Access, or Crystal Reports. It allows you to create spreadsheets, tables, and reports based on your company file.
The QuickBooks Database Manager is installed on a central server with the company file. Enterprise is installed on each workstation, and these workstations access the company file over the network.
1. Visit the Website: Go to the QuickBooks website or the website of the provider of the QuickBooks ODBC driver.
2. Locate the Driver: Search for the QuickBooks ODBC driver download page.
3. Select the Version: Choose the version that matches your QuickBooks edition (e.g., US, CA, UK, AU) and your operating system (32-bit or 64-bit).
4. Download the Installer: Click on the download link to get the installer file.
5. Save the File: Save the installer file to a convenient location on your computer, such as your Downloads folder.
6. Run the Installer: Once the download is complete, run the installer and follow the on-screen instructions to install the driver.
1. Create Directory: Create the directory %OMNIHOME%\platform\win32\DataDirect.
2. Copy Files: Copy the ODBC32v53 directory to %OMNIHOME%\platform\win32\DataDirect\ODBC32v53.
3. Register Drivers: Run the nco_install_drivers.exe utility to register the drivers in HKLM\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\.
4. Open ODBC Manager: Run the 32-bit ODBC manager program located at C:\Windows\SysWOW64\odbcad32.exe.
5. Configure DSN: Follow the ODBC Gateway guide to configure the Data Source Name (DSN).
On this page
Have a QuickBooks® question? Our ProAdvisors can help. QAsolved is not affiliated with Intuit.