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:
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.
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.
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.
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.