Configuration Options

Windows-Specific Instructions

The ODBC driver installation installs both a 32-bit and 64-bit version of the driver. Each version maintains DSN profile that must be configured separately. On a 64-bit Windows system, both drivers will be configurable. If you use a 32-bit Windows system, the 32-bit version of the driver is the only version available for configuration.

To open the SQL1010 ODBC DSN Configuration dialog, complete the following steps:
  1. Open the ODBC Data Source Administrator dialog by clicking the Start Menu > All Programs > 1010data > 1010odbc.
    • To configure the 32-bit version of the driver, click the ODBC 32-bit option
    • To configure the 64-bit version of the driver, click the ODBC Native option
      Note: If you use a 32-bit Windows system, the only option will be: ODBC Native. Selecting this option will allow you to configure the DSN profile for the 32-bit version of the driver.
  2. Click the System DSN tab.
  3. Click the system DSN labeled: www2.1010data.com.
  4. Click the Configure... button on the right-hand side of the dialog.
You should now see a configuration dialog with 5 tabs, as follows: Connection, SQL, Driver, Types, and Logging.

Finally, if you're not certain of the driver you're configuring, you can verify the version as shown in the screenshot below:

The number after the '.' character tells you which version you're configuring. Above is the 32-bit configuration dialog. A 64 will follow the '.' character when configuring the 64-bit version.

Linux-Specific Instructions

Linux configuration for the 1010data ODBC driver is managed by the config file located in {$HOME}/.1010data/config. If it needs to be moved, the path to the config file may be specified in the ODBCTENTEN environment variable. Most settings described below are configurable on Linux. For information on valid key values, reference the sample config file.

For the settings tables below, the left-most column contains the setting names for Windows on top and the configuration keys for Linux on the bottom.

A Note for Developers: If you are building a front-end application, the Linux configuration keys and associated values can be used for your connection string when connecting to the 1010data ODBC driver.