[QODBC-Desktop] How to use the QODBC Test Tool for testing
Posted by Rajendra Dewani (QODBC Support) on 27 December 2022 12:08 PM

[QODBC-Desktop] How to use the QODBC Test Tool for testing

Problem Description:

How to use QODBC Test Tool to test my SQL statement?

How to test QODBC connection with QuickBooks Data?


Open a company file in QuickBooks.

Start QuickBooks and open a company file, your own, or a sample company file.

Log into QuickBooks Company File as QuickBooks user "Admin".


Using the QODBC Test Tool for testing

Running the QODBC Test Tool

     Leaving your QuickBooks company file open ->, click on Start -> All Programs -> locate the QODBC Driver for the QuickBooks program group on your desktop.

     Click on the QODBC 32-Bit Test Tool icon to launch it.

Establish a Connection

     From the first dropdown, select DSN. From the other dropdown, select the System DSN named QuickBooks Data -> Click Connect.

   This will connect you to the current company file opened by QuickBooks. If this is the first time QODBC has used this company file, you will receive a popup from QuickBooks asking you to allow QODBC to run. Choose the, Yes, Always option to allow the Sensitive data option.

Running test query

     Now that you have successfully established a connection to your QuickBooks data, it's time to type in your desired SQL query. Click on the Run button, and the requested query results will appear! For example, you can use the default "SELECT * FROM Customer" or type in another table like stock by entering "SELECT * FROM ItemInventory" or stored procedure like "sp_report ProfitAndLossStandard." If you're wondering, the * in the select statement means all columns in that table.

     Alternatively, Select the Show me the list of tables from the dropdown. OR type in sp_tables command to see a list of tables available in QuickBooks.

     And when a query is displayed, if you right-click on the column heading, you can get information about the column, including if it is updateable, insertable, size, and so on.


     Click the Disconnect button to disconnect.


Also, refer to 


(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).