How you can Install and Configure the QuickBooks Enterprise ODBC Driver

by Steve M. QuickBooks Certified ProAdvisor

Do you wish to get QuickBooks Enterprise ODBC Driver? In this post we will review to Install and also set up the QuickBooks Enterprise ODBC Driver. This permit you to export your information or various other information to Enterprise application or to programs like Microsoft Excel, Access, Crystal Report, File manufacturer, and so on. It is Enterprise as if it could function flawlessly with ODBC perfectly.

QODBC driver for QuickBooks Enterprise Solutions enables you to export data from your company file to programs like Microsoft Excel, Microsoft Access, Crystal Reports, Filemaker, Alpha, QlikView, Python, or .Net. to create the personalized reports. In this post we have described the possible ways to install and configure the QuickBooks Enterprise OBD driver. Read carefully to this post and understand the methods for installations of OBDC driver.

Tips to Configure the ODBC driver

You need to perform these steps to setup and configure ODBC driver in your QuickBooks Enterprise Solutions

First of all you need to open your QuickBooks and select the File menu
Now you need to select Utilities and click on Set Up ODBC.
After that Just Click on the General tab.
Next, You need to Select the Use the Company file that's currently open in QuickBooks option.
After that enter QuickBooks Data, In the Data Source Name
Now, Click on the Test Connection to QuickBooks button.

Keep in mind: You should be checked in to your company file as "Admin" to be able to successfully run the test connection.

Press on Ok key when the message "Test Connection to QuickBooks Successful" appears in your QuickBooks desktop.
After that select the Apply option.
Now Choose the Messages tab and Clear the Detail Tracing (Slow) checkbox (if allowed).
Next, here you need to Select the Display Optimizer Status Panel checkboxes (if disabled).

Optional: To view details of exactly what QODBC is working with, select the Display Driver Status Panel.

Keep in mind: When selected, QODBC detailed details will appear on a window above the system tray. This will certainly show info such as the number of documents files refined and also the existing running task in QODBC. It will additionally provide evaluation of speed utilizing maximized as well as non-optimized data, which will serve as an indicator if fixing actions for the software's performance have to be done.

Now Click on Apply and Click on the Optimizer tab.
Now Select the Use Optimizer box (if disabled).
Default Optimizer file path is (%AppData%\ QODBC Driver for QuickBooks \ Optimizer). This is the suggested path to utilize.
Select The start of every question (otherwise selected)
After that click on Apply.

Keep in mind: Initial optimization time could differ depending on the file dimension. It generally takes 24 hours. The even more transactions are made, the longer optimization will take. Once completed, data connections with QuickBooks will certainly run quicker.

Finally Click OK to exit the ODBC Driver arrangement.

We hope that this method will work for you and assist you in installing and configuring OBBC Driver. If you have difficulties while performing these actions or facing other issues related to your QuickBooks desktop contact QuickBooks Enterprise Support to get the help from U.S based accounting experts.