Database Administrator's Guide

ODBC Support for SSL

You can use SSL with an ODBC data source. To configure SSL, open the ODBC Data Source Administrator.

Once you invoke the ODBC Data Source Administrator:

1. In the dialog box for the type of data source you choose, choose the Add button. The Add Data Source dialog box appears.
2. Select FairCom DB SQL from the list of installed drivers and choose Finish. The FairCom DB ODBC Setup dialog box appears.
3. Fill in the dialog box fields as shown in the following figure and choose OK. The ODBC Data Source Administrator writes the values you supply to ODBC.INI or to the DSN file you indicated.

   

   Data Source Name - A local name for the FairCom DB SQL data source for use in connect calls and by the ODBC Administrator.

   Description - Optional descriptive text.

   Host - Specify the machine name on which the FairCom DB SQL Server is running.

   Database - The name of the database where the FairCom DB SQL data source resides.

   User ID / Password - User name and password for connecting to the database. The driver uses those values if the application does not supply them in the call. You can leave these fields blank if you want the driver to use the defaults on the server. If no defaults are defined and you leave these fields blank, the user will be prompted when the application connects.

   Service - The name of the Service FairCom DB SQL listens to. If empty, sqlnw is used.

   Default Fetch Size - This value is the size (in bytes) used by the driver to fetch multiple rows from the server. It reduces network requests resulting in performance gains. If not set, the internal buffer size is 5000 bytes.

   • In your connection string, set the attribute "FETCH_SIZE=[number of bytes]"
   • In your ODBC.INI file, set the attribute "Default Fetch Size=[number of bytes]"

   Connection string settings take precedence over DSN and ODBC.INI settings.

   Default Query Timeout - It is possible to set the Default Query Timeout (in seconds) in the DSN and in the connection string.

   • In the connection string, the attribute is: QUERY_TIMEOUT=[number of seconds]
   • In the ODBC.INI file, the attribute is: Default Query Timeout=[number of seconds]

   Settings in the connection string take precedence over the setting in the DSN or ODBC.INI.)

   Preserve Cursor - This behavior is configurable from within the ODBC administrator.

   Scrollable Cursor - This allows you to enable support for ODBC applications that require a scrollable cursor.

   Client Character Set - Use the drop-down list to select the character set used by the client.

   SSL - Enter optional parameters to configure the SSL. The following entries can be used to configure the SSL connection:
   1) empty - Do not use SSL.
   2) BASIC - Use SSL without certificate checking.
   3) <certificate file name> - Use SSL with certificate checking using the certificate file specified. If no path is entered, the file must be in the current working directory.

   Options - Enter any optional parameters to be included in the connect string.

4. The Data Source Dialog box reappears, and now includes the newly-added data source.

Configuring SSL in Your Connection String

In the ODBC connection string, it is possible to add "SSL=xyz" where "xyz" is one of the options 2 or 3 from the SSL parameters listed above in the FairCom DB ODBC Setup dialog box.

You can add one of the following to your existing ODBC connection strings to enable TLS/SSL:
"SSL=BASIC" - Encryption with default server certificate.
"SSL=ctsrvr.pem" - Use Peer authentication with explicitly named cert located in the local directory.
"SSL=C*\certs\ctsrvr.pem" - Use Peer authentication with an explicitly named cert with a full path.