Knowledgebase: Tutorials
[QODBC-Online] How to use QODBC with QuickBooks Online Edition
Posted by Jack - QODBC Support on 11 March 2015 01:49 PM

How to use QODBC with QuickBooks Online Edition

Setup of QODBC Online:

First, we need to install QODBC Online. QODBC Online requires .Net Framework 4.0 or later version. So you need to install .Net Framework 4.0 to work with QODBC Online.
Please refer below steps to install QODBC Online:

1). Download QODBC Online installer from below link:

QODBC Driver for QuickBooks Online Download

2). Install QODBC Online: 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step1.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step2.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step3.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step4.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step5.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step6.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step7.png

 

Now we have installed QODBC Online. 

Configure QODBC Online:

Now we need to authorize & configure QODBC Online to work with QuickBooks Online.

Please follow below steps configure QODBC Online:

1) Open QODBC Online Setup Screen & click on "Test Connection to QuickBooks Online" & refer below steps by step guide:

Start>>All Programs>> QODBC Driver for use with QuickBooks Online>> QODBC Online Setup Screen

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step8.png

 

2) By clicking on "Test Connection to QuickBooks Online" popup message appear for setup connection to QuickBooks Online. Please click ok.

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step9.png

 

3) By clicking "OK" open authorization screen. You need to authorize your company file to work with QODBC Online. 

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step10.png

 

4) You need to enable popup.

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step11.png

 

5) Enter your QuickBooks User ID & Password, then click on "Sign In"

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step12.png

 

6) Select the company file which you want to use with QODBC Online. If you have multiple company file.

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step13.png

 

7) Click on "Authorize"

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step14.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step15.png

 

8) After successful authorization, it will return back to QODBC Online page as connected status. You can close this window.

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step16.png

 

9) You may face UAC error message. Please ignore this message. Test connection may fail because it is running in different user context. 

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step17.png

 

10) Now we are testing the connection through VB Demo application. Please open VB Demo from:

Start>>All Programs>> QODBC Driver for use with QuickBooks Online>> VB Demo:

Click on Connection "Add New Connection"

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step18.png

 

11) Select "QuickBooks Online Data" & click on "OK":

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step19.png

 

You may face Error 653 " [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 653 ":

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step19-.png

 

We would like to share that QuickBooks Online database is accessible via REST API ( web interface ) and few of the times, we do not get the timely response and connection may time out.

This may also depend on your internet connection and QuickBooks Online Web Services.

So when you receive such error please try to connect again.

12) Now you can see we are connected to QuickBooks Online. Now we are querying Customer table:

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step20.png

 

Below is the list of Customers:

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step21.png

 

Import / Export connection key:

If you want to connect same company file from another machine, then you can export connection key from one machine & import it to another machine.

You can share connection key from:

Start>>All Programs>> QODBC Driver for use with QuickBooks Online >> General tab >> click on "Export Connection key" button & share key.

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step22.png

 

Enter the name of connection key & choose the location where you want to save connection key:

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step23.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step24.png

 

Now connection key exported successfully. You can copy this connection key & paste it in another machine to import key on that machine.

You can import connection key from:

Start>>All Programs>> QODBC Driver for use with QuickBooks Online >> General tab >> click on "Import Connection key" button & import key.

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step25.png

 

Open connection key from the location where you keep the connection key:

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step26.png

 

http://support.flexquarters.com/esupport/newimages/QODBCOnline/step27.png

 

Now the connection key imported successfully. You can connect to QuickBooks Online using this connection key.

(0 vote(s))
Helpful
Not helpful

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