Setup QuickBooks ODBC Driver

The QuickBooks dedicated ODBC (Open Data Base Connectivity) driver is also known as. In order for QuickBooks ODBC Driver compliant front end applications to read and change the QuickBooks data files, the QuickBooks application stores its data in its own unique DBMS file format. There is no delay in receiving QuickBooks data on the desktop thanks to QuickBooks Open Data Base Connectivity Driver. Also, all of the developers’ applications have data access. 

ODBC for Enterprise or POS functions by obtaining the SQL commands from apps via the ODBC display. Once the commands are attained the calls are converted to navigational XML commands. ODBC for Enterprise or POS acts as a cover around the Intuit SDK. This helps customers to finally acquire their QB data by standard database tools. This further helps in hasting up the development time.

What is QuickBooks Open Data Base Connectivity (QODBC)

ODBC Driver for Point of Sale indicates a ODBC driver for QuickBooks format files. QuickBooks application stores its data in its own recovery DBMS file format. This driver authorizes the use of any ODBC-compliant application to read and write data comprised in QuickBooks POS format files. This is exactly done to any other database with ODBC enabled.

It allows Windows to have access to multiple database systems using various file formats. SQL (Structured Query Language) is used as the medium to access data through ODBC. The vendors of QuickBooks ODBC drivers strictly follow the specifications provided by ODBC so that any compliant app can access data via driver.

Install and Set up the QuickBooks Desktop Enterprise ODBC Driver

Data from your company file can be exported using the QuickBooks Open Database Connectivity (ODBC) driver from FLEXQuarters so that you can design unique reports. A report can be seen once it has been exported using applications like Microsoft Excel, Crystal Reports, QlikView, Python, or .Net. Here is what to do.

• Install the ODBC driver by downloading it.
  • Download ODBC Driver for QuickBooks Desktop Enterprise.
• Run the file you have downloaded and follow the instructions displayed on the screen.
• Then you have to go to File > Utilities > Configure ODBC in QuickBooks.
• Select the General tab.
  • Choose to use the QuickBooks company file that is currently open.
  • Enter QuickBooks Data in the Data Source Name field.
  • Choose Test QuickBooks Connection.
  • To execute the test connection, you must sign in as the administrator to your company file.
  • Select OK, then select Apply when you see Test Connection to QuickBooks Successful.
• Then you have to go to the Messages tab.
  • Delete the checkbox next to Detail Tracing (Slow).
  • The Display Optimizer Status Panel checkbox should be selected.
  • Choose Apply.
• Activate the Optimizer tab.
  • Check the box next to Use Optimizer.
  • Default Optimizer file path is (%AppData%\ODBC Driver for QuickBooks\Optimizer). 
  • Select Apply after choosing the commencement of every inquiry.
• To close the Configure ODBC Driver window, click OK.

Install QuickBooks QODBC Driver and Connect Both of Them

• Firstly install QODBC Installer from the web link https://qodbc.com/qodbc-downloads.
• Run it as administrator– (Right-click on the Installer and select Run As Administrator.
• If the license key is purchased then we would suggest directly inputting the same.
• This will help you get QODBC POS fully functional.
• But in case you install QODBC POS, you can exempt this option blank to get a 30-days evaluation.
• Configure QODBC POS default DSN via Windows: Start -> All Programs -> QODBC Driver for use with QuickBooks POS -> QODBC POS Setup Screen.
• And if you see a message appearing as
  • Evaluation expired.
  • Unable to validate the license supplied.
  • License failed to open the file, then you would be required to run QODBC POS Setup Screen as administrator.
• If this is the first time you have run QODBC POS then simply skip the CDKEY step in the installation.

Connect QuickBooks POS via QODBC Driver POS

• Open QuickBooks POS software.
• Ensure that you are in a single-user mode, in the File menu.
• There is an option “Switch Company File to Multi-User Mode” which shows that you are in single mode.
• Open the setup screen.
• You will now be shown with an option as “Current Company Setting”, simply leave this blank.
• This will help QODBC POS directly access the company file that is running in QuickBooks POS.
• Click the “Test Connection” button.
• QuickBooks POS will ask for your permission if you would want to allow QODBC POS.
• Click “Yes Always” to continue, and QODBC POS will report the connection successful in case it goes ok.
• You can use VB Demo to test the connection. Locate our test tools VB Demo by going to Windows Start -> All Programs -> QODBC Driver for use with QuickBooks POS -> VB Demo.
• Click the connection in the VB Demo window -> Add new connection -> select Data Source window -select QuickBooks POS Data as to your DSN.
• Easily access QuickBooks POS company file via VB Demo.

You can also run QuickBooks QODBC driver with QuickBooks POS under the multi-user mode that allows the user to access and modify the company files and documents. Also, it allows the user to develop a connection string to assign a company file to the DSN in order to avoid opening QuickBooks POS when you use the DSN.

Also, you can connect with other QuickBooks Consultant agencies like AskForAccounting.com which hires experienced QuickBooks professionals with in-depth knowledge. Call to QuickBooks support and garner instant consultant. You can choose a phone, email, or live chat option to connect with the consultant team.

Frequently Asked Questions