Enabling SSL Connections on UNIX

Use the odbcinst utility to enable SSL connections.

  1. Start the unixODBC Driver Manager odbcinst utility.
  2. Open an existing datasource template or create a new one.
  3. To the datasource template, add:
    Encryption=sslTrustedFile=<filename>line
  4. Reinstall the datasource using:
    #  odbcinst -i -s -f dsn template file

    where dsn template file is the complete path to the Adaptive Server ODBC datasource template file.

If you are linking directly to the Adaptive Server ODBC Driver or the Sybase iAnywhere ODBC Driver Manager, modify the odbc.ini file.

This is an example of the odbc.ini datasource template file:

[sampledsn]
Description=Sybase ODBC Data Source
UserID=sa
Password= 
Driver=Adaptive Server Enterprise
Server=sampleserver 
Port=4100
Database=pubs2
UseCursor=1
Encryption=ssl
TrustedFile=<SYBASE>/config/trusted.txt