Configuring the SSL Windows Client

Learn the steps to configure the SSL Windows client.

Note: You must restart the server after you update the system environment variables.
  1. Set the client Sybase Window environment variable:
    set SYBASE= C:\<install_dir>\DC-15_0\connectivity
  2. Enter:
    C:\<install_dir>\DC-15_0\bin> 
    cd C:\<install_dir>\DC-15_0\connectivity\ini
  3. Copy the trusted.txt file to the C:\<install_dir>\DC-15_0\connectivity\.ini directory:
    C:\<install_dir>\DC-15_0\connectivity\ini>copy 
    C:\<install_dir>\DC-15_0\bin\trusted.txt 
    C:\<install_dir>\DC-15_0\connectivity\ini
  4. Edit the sql.ini file to append the SSL entry to the Master and Query entries for the services:
    C:\<install_dir>\DC-15_0\connectivity\ini>notepad sql.ini
    [server name]
    Master = NLWNSCK, machine name, port ssl
    Query = NLWNSCK, machine name, port ssl
  5. Change to the Sybase Open Client and Open Server bin directory:
    cd C:\<install_dir>\DC-15_0\connectivity\\OCS-15_0\bin
  6. Connect to the service:
    isql -Sservice name -Uuid -Ppwd
  7. When you are finished, stop the server and restart it. If you receive no connection errors, SSL is installed correctly.

To test by examining SSL handshakes, Sybase recommends that you use the ssldump utility at http://www.rtfm.com/ssldump/.