Setting Up a New Connection

Once the 1010data ODBC driver is installed it is recommended to create a different connection for every use-case you may encounter. This allows end-users to maintain separate configurations for each client-application, and generally helps keep things organized. This section walks through the process of creating a new DSN connection with the recommended settings.

Creating a New Connection

To create a new connection, click the Start button, then click All Programs > 1010data > 1010dataodbc. If you have the most current version of the 1010data ODBC driver, then both the 32-bit and 64-bit versions are installed and accessible here:

Before moving forward there's an important detail to keep in mind. Remember that it is a client application that will use the 1010data ODBC driver to connect to a 1010data data source. So you must know the "bitness" of the client application. Depending on many factors, the client application could be a 32-bit or 64-bit application. Make sure you know the bitness of the client, and then create a DSN connection with the corresponding ODBC driver (i.e., use Configure 32-bit ODBC for a 32-bit client application and Configure Native ODBC for a 64-bit application). For the rest of this section, it will be assumed the connection is being configured for a 64-bit application. However, the configuration options are identical.

After selecting the appropriate driver for the client application the ODBC Data Source Administrator will launch. Click the System DSN tab, then click the Add button, as shown below:

After clicking the Add button, the Create New Data Source dialog will open. Make sure you select the 1010dataODBC driver option available in this dialog, then click the Finish button, as shown below:

After clicking the Finish button the SQL1010 ODBC DSN Connection configuration dialog will automatically appear. There are several settings on the Connection tab that should be set unless you have a specific reason not to. The list below provides the configuration details that should be set when the configuration is complete:
  • Complete the DSN field by giving the new connection a descriptive name
  • Make sure the Compression checkbox is checked
  • Make sure the Reconnect? checkbox is checked
  • Make sure the Binary mode checkbox is checked

When the configuration is complete the Connection tab should look like the screenshot below (with your own descriptive connection name, of course):

When you've finished the configuration, click the OK button. The newly created connection will appear on the System DSN tab of the ODBC Data Source Administrator dialog, as shown below:

There are many other configuration options you may want to set depending on the specific use of the connection you're creating. For full details on every available configuration options, see the Configuration Options section of this guide.