Configuring Open Client drivers for Sybase IQ 12.7 and 15.0

StepsConfiguring Open Client drivers on Windows

  1. Set these environment variables:

    SYBASE = <install_dir>\ocs
    
    SYBASE_OCS = OCS-15_0
    
    PATH = %SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\
    %SYBASE_OCS%\dll
    
  2. Use the dsedit utility to create an entry for your server in the sql.ini file. For example:

    [myiqserver]
    master=TCP,myiqhost,2638
    query=TCP,myiqhost,2638
    

StepsConfiguring Open Client drivers on UNIX and Linux

  1. Navigate to the installation directory and use a text editor to open the GridNode.sh file.

  2. Locate and uncomment these lines to set the environment variables:

    #SYBASE=<install_dir>/ocs
    #export SYBASE
    #SYBASE_OCS=OCS-15_0
    #export SYBASE_OCS
    #LD_LIBRARY_PATH=<install_dir>/ocs/OCS15_0/lib:${LD_LIBRARY_PATH}
    #export LD_LIBRARY_PATH
    #LIBPATH=<install_dir>/ocs/OCS-15_0/lib:${LIBPATH}
    #export LIBPATH
    
  3. Create an entry for your server in the <install_dir>/ocs/interfaces file. For example:   

    myiqserver
    
    master tcp ether myiqhost 2638
    query tcp ether myiqhost 2638