SQLines Data - Configure and Troubleshoot Connection to Sybase ASE

If you need to connect to a localhost Sybase ASE database you do not need to setup any additional libraries to use SQLines Data tool as they are already supplied with the Sybase ASE server software.

If you need to connect to a remote Sybase ASE database, you need to have Client Library/C (CT-Lib) installed in your system.

Check if you already have Sybase ASE libraries:

• Linux: ($SYBASE/$SYBASE_OCS/lib)
  • libsybct64.so
  • libsybcs64.so

• Windows (please make sure, the Sybase library path is added to the PATH environment variable):
  • C:\SAP\OCS-16_0\dll
  • C:\sybase\OCS-15_0\lib

Before running sqldata command, add Sybase Client Library/C location to LD_LIBRARY_PATH:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$SYBASE/$SYBASE_OCS/lib

If your Sybase server is configured to require encrypted password connection, you will not be able to login using a plain text password.

To set password encryption, edit sqldata.cfg file and set -sybase_encrypted_password=yes