Step 1 – Start QuickBooks to register QODBC

Please keep QuickBooks running, Logged in as “Admin” under Single User Mode

QuickBooks is an accounting program which must produce trusted numbers that accountants can rely on. For this reason they have created an interface to the QuickBooks application which follows all of the business rules. This is what our product uses to access QuickBooks data.

To get access to that data, your application (using QODBC/QRemote) must register with QuickBooks so that security access can be granted. To do this, you first need to run QuickBooks on your computer logged in as an Administrator and open your company file (or one of the sample company files that came with QuickBooks)


Step 2 – Running VB Demo

Leaving your QuickBooks company file open, click on “Start” and “Programs” and locate QODBC Driver for QuickBooks program group.

Click on the VB Demo icon to launch the Visual Basic Demo program supplied with QODBC.

From the Menu, Click “Connection”, Select “Add Connection”

From the Data Source list, select “QuickBooks Data QRemote” or the DSN you had configured that points to QRemote Server’s IP Address.

Please Note : Here we are using “QuickBooks Data QRemote”, but on your 64-Bit Application you will get option to select “QuickBooks Data QRemote 64-Bit” or “QRemote Data 64-Bit”


Step 3 – QuickBooks Integrated Applications

When the driver starts, QuickBooks will ask permission for the driver to access your QuickBooks data. Answer “Yes, Always” to this and the QODBC driver is added to the Integrated Application list.

This will allow applications to integrate with QuickBooks data when QuickBooks is running on the desktop. There may be instances in which you want an integrated application designed to share data with QuickBooks to access QuickBooks files automatically, without user intervention. This might permit, for example, a particular application to run during the night when there is no other activity on the company file. Also QuickBooks need not be running on the desktop for ODBC compliant applications to access the data files while set in this mode.

This will allow applications to integrate with QuickBooks data when QuickBooks is running on the desktop.

Step 4 – Testing Your Connection

After the Successful connection you may notice “Tables”, “Query” & “Disconnect” buttons gets Highlighted.

Quickbooks 2002 Windows 10

Now that you have successfully established a connection to your QuickBooks data, it’s time to type in your desired SQL query, for example your can use the default “SELECT * FROM CUSTOMER” or type in another table like stock by entering “SELECT * FROM ITEMINVENTORY”. Click on the “Query” button and the requested query results will appear! In case you’re wondering, the * in the select statement means all columns in that Table. Click on the “Tables” button to see a list of all the available QuickBooks tables.

Quickbooks 2002 Windows 10 64


To disconnect, you can either select “connections” / “remove the connection” or Click the “disconnect” button. If you get an error, please search our FAQ Knowledgebase or post a support ticket to resolve the issue Click Here. If not, congratulations – you have created your first report from QuickBooks data and are ready to talk to your own company data.

Quickbooks 2002 On Windows 10

Also Refer: