Easysoft ODBC-QOnline User's Guide - Configuration

Configuring the Easysoft ODBC-QOnline Driver

The Easysoft ODBC-QOnline Driver is installed on the computer where your applications are running. ODBC applications access ODBC drivers through the ODBC Driver Manager and a data source. The data source tells the Driver Manager which ODBC driver to load, how the driver should connect to QuickBooks. This chapter describes how to create data sources, use DSN-less connections and configure the Easysoft ODBC-QOnline Driver.

Before setting up a data source, you must have successfully installed the Easysoft ODBC-QOnline Driver.

For Easysoft ODBC-QOnline Driver installation instructions, see Installation.

Chapter Guide

Configuring the Easysoft ODBC-QOnline Driver

This section describes how to configure the Easysoft ODBC-QOnline Driver to connect to QuickBooks Online by using a data source or a DSN-less connection string. The section assumes you are, or are able to consult with, a database administrator.

Refer to the section relevant to your platform to continue:

Setting Up Data Sources on Windows

1.  Open ODBC Data Source Administrator:

 The ODBC Data Source Administrator dialog box is displayed:

2.  Select the User DSN tab to set up a data source that only you can access.

¯ OR ¯

 Select the System DSN tab to create a data source which is available to anyone who logs on to this Windows machine.

3.  Click Add... to add a new data source.

 The Create New Data Source dialog box displays a list of drivers:

4.   Select Easysoft ODBC-QOnline Driver and click Finish.

 The DSN Setup dialog box is displayed:

For details of the attributes that can be set on this dialog box, see Attribute Fields.


64-bit Windows

The Easysoft installer program installs both a 32-bit and a 64-bit version of the Easysoft ODBC-QOnline Driver. If you want to use a 64-bit ODBC application, you need to use the 64-bit Easysoft ODBC-QOnline Driver. If you want to use a 32-bit ODBC application, you need to use the 32-bit Easysoft ODBC-QOnline Driver.

There is both a 32-bit and a 64-bit version of ODBC Administrator. The 64-bit ODBC Administrator is located in Control Panel under Administrative tools. To access the 32-bit ODBC Administrator in Windows 7 and earlier, in the Windows Run dialog box, type:

%windir%\syswow64\odbcad32.exe

On Windows 8 and later, both the 32-bit and 64-bit ODBC Administrator are located in Control Panel under Administrative tools: ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit).

Easysoft ODBC-QOnline Driver data sources created in the 64-bit ODBC Administrator will specify the 64-bit version of the Easysoft ODBC-QOnline Driver. Easysoft ODBC-QOnline Driver data sources created in the 32-bit ODBC Administrator will specify the 32-bit version of the Easysoft ODBC-QOnline Driver.

If you want to create an Easysoft ODBC-QOnline Driver System data source for use with a 64-bit application, use the 64-bit ODBC Administrator. If you want to create an Easysoft ODBC-QOnline Driver System data source for use with a 32-bit application, use the 32-bit ODBC Administrator.

For Easysoft ODBC-QOnline Driver User data sources, it does not matter which version of the ODBC Administrator that you use.


5.  Click the Connect to QuickBooks Online button.

 The Intuit login page is displayed in your default browser.

6.  Log into QuickBooks Online, and then close the browser when prompted.

 You are returned to the Easysoft ODBC-QOnline Driver DSN Setup dialog box. Data source set up is complete.

Attribute Fields

This section lists the attributes which can be set for the Easysoft ODBC-QOnline Driver in a table showing:

Attributes which are text fields are displayed as value.

Attributes which are logical fields can contain either 0 (to set to off) or 1 (to set to on) and are displayed as "0|1".

If an attribute can contain one of several specific values then each possible entry is displayed and separated by a pipe symbol.

For example, in the statement:

DIALECT=1|2|3

the value entered may be "1", "2" or "3".

DSN

The name of the User or System data source to be created, as used by the application when calling the SQLConnect or SQLDriverConnect functions.

Interface Value

DSN Dialog Box (Windows)

DSN

Connect String

DSN=value

Description

Descriptive text that may be retrieved by certain applications to describe the data source.

Interface Value

DSN Dialog Box (Windows)

Description

Connect String

Not Used

Sandbox Company

If your QuickBooks Online company is a private sandbox one, enable this attribute.



Interface Value

DSN Dialog Box (Windows)

Sandbox Company

Connect String

SANDBOX= Yes | No

Driver Logging

If you experience a problem when using the Easysoft ODBC-QOnline Driver, Easysoft Technical Support may ask you to enable driver logging to help provide you with a solution.



Interface Value

DSN Dialog Box (Windows)

Driver Logging

Connect String

Logging = Yes | No

Driver Tracing

If you experience a problem when using the Easysoft ODBC-QOnline Driver, Easysoft Technical Support may ask you to enable driver tracing to help provide you with a solution.



Interface Value

DSN Dialog Box (Windows)

Driver Tracing

Connect String

Tracing = Yes | No

Log File

The file where debug and trace information from the Easysoft ODBC-QOnline Driver gets written. For example, C:\Windows\Temp\QBOnline.log.



Interface Value

DSN Dialog Box (Windows)

Log File

Connect String

LOGFILE = value