Knowledgebase
[QODBC-Online] How to Reconnect QODBC Online with QuickBooks Online Edition (Apps.com)
Posted by Rajendra Dewani (QODBC Support) on 27 July 2015 12:00 PM

QODBC Online is no longer connected to QuickBooks Online. Your user token is no longer valid.

How to connect/reconnect QODBC Online with QuickBooks Online Edition (Apps.com)

 

 

How to Connect QODBC Online 64-Bit Driver to a QuickBooks Online Company File

 

To establish a connection between the QODBC Online 64-Bit Driver and your QuickBooks Online company file, follow the steps outlined below:

 

Step 1: Configure the QODBC Online DSN (64-Bit)

 

  1. Click Start on your Windows taskbar and open Configure 64-Bit QODBC Online Driver.

  2. Navigate to the System DSN tab.

  3. Select the QuickBooks Online Data DSN and click Configure.

  4. In the QODBC Online 64-Bit Setup window, click the Connect to QuickBooks button.

  5. Log in using your Intuit QuickBooks Online credentials.

  6. Choose the QuickBooks Online company file you want to connect to.

  7. Authorize the connection when prompted.

  8. Once authorization is complete, return to the QODBC Online Setup screen.

  9. Click OK to close the setup window.

 

Step 2: Test the Connection Using the QODBC Test Tool

 

  1. Click Start, then open the QODBC Online 64-Bit Test Tool.

  2. Click the Connect button to establish a connection with the configured DSN.

  3. Click the Run button to execute a test query.

  4. In the query field, replace:

     
    select * from customer

    with:

    select * from company
  5. Click Run again to execute the updated query and verify the connection.

 

 

 

Configure the QODBC Online DSN (32-Bit)

 

Please follow the below-mentioned steps to configure QODBC Online (32-Bit):

1) Open QODBC Online Setup Screen & click on "Connect To QuickBooks," & refer to the below steps by step guide:

Start >> All Programs >> QODBC Driver for use with QuickBooks Online >> Configure QODBC Online Data Source.

Go To "System DSN" Tab>> select QuickBooks Online Data>> click "configure"
 

 
QODBC Online Setup Screen General tab opened. Please click the "Connect To QuickBooks" button to authorize QODBC Online at QuickBooks Online.



2) By clicking "Connect To QuickBooks," open the authorization screen. You need to authorize your company file to work with QODBC Online.

3) You need to enable a popup.

4) Enter your QuickBooks User ID & Password, then click "Sign In."

5) Select the company file you want to use with QODBC Online if you have multiple company files.

6) Click on "Authorize."

 

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

8) QODBC Online is successfully connected to your QuickBooks Online company.

 

9) We will test the connection using QODBC Online Test Tool. Please open QODBC Online Test Tool from:
Start>>All Programs>> QODBC Driver for use with QuickBooks Online >>QODBC Online Test Tool

 

10) Please select the "QuickBooks Online Data" DSN from the dropdown list & click on "Connect."

 

11) We can connect to DSN from QODBC Online Test Tool. Please write your SQL statement & click on "Run."

 

12) We can fetch data from QODBC Online Test Tool. 

 

Tags: QuickBooks Online, QBO, QODBC Online, Connect, Reconnect



(4 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).