[QODBC-Online] How to create or configure a QODBC Online DSN
Posted by Jack - QODBC Support on 30 March 2016 09:46 AM
How to create or configure a QODBC Online DSN
I have one QuickBooks Online login, which provides access to multiple QuickBooks Online companies.
You can create new DSN company wise & authorize your company file and use it in your configuration.
Launch QODBC Online Data Source Configuration
Locate the QODBC Driver for QuickBooks Online program group on your desktop. Click on the Configure QODBC Online Data Source icon to create or configure a QODBC Online Data Source Name (DSN).
Create a New DSN
Click on the System DSN tab to create a DSN that can be called by both Windows applications and services. Click on the Add button to create a new DSN.
Select the QODBC Driver for QuickBooks Online option and click on the Finish button.
Configure the Created DSN
Enter the Data Source Name as CompanyA and click Apply.
You need to authorize your company file to work with QODBC Online.
Please refer How to Connect QODBC Online with QuickBooks Online Edition for more details
Once it is connected, You can use Excel or Access or VB Demo or any other application, and use "CompanyA" instead of "QuickBooks Online Data" and you should be able to connect and fetch data from QuickBooks Online.
You can repeat above steps for another company file (i.e. CompanyB, CompanyC etc..).