Configuring the SSL Windows client

NoteYou must reboot after you update the system environment variables.

StepsTo configure the client environment to use SSL

  1. Set the client Sybase Window variable:

    set SYBASE= C:\<install_dir>\DC-15_0\connectivity
    
  2. Go to the C:\<install_dir>\DC-15_0\connectivity directory:

    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 and 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. Go to the Sybase Open Client and Open Server bin directory:

    cd C:\<install_dir>\DC-15_0\connectivity\\OCS-15_0\bin
    
  6. Issue the isql command to 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.

For testing, to examine SSL handshakes Sybase recommends that you use the ssldump utility.