Use Sybase OpenClient to access the database

Declaration: SYBASE is in the version 12.5.0.3 for linux.

Operating System: Linux localhost. localdomain 2.6.18-1.2798.fc6 #1 SMP Mon Oct 16 14:37:32 EDT 2006 i686 i686 i386 GNU/Linux

Download Sybase 12.5.0.3 for linux.

Because it is only used as a client, you do not need to install ASE. You only need to install two packages of sybase-common-12.5-3.i386.rpm and sybase-openclient-12.5-3.i386.rpm.

Installation Steps

Rpm-ihvf./sybase-common-12.5 *. rpm -- prefix =/usr/sybase

Rpm-ihvf./sybase-openclient-12.5 *. rpm -- prefix =/usr/sybase

If no error occurs, the installation is successful.

$ SYBASE is an environment variable. That is, the installation directory of Sybase

First go to the $ SYBASE/OCT-12_5/bin directory.

Use isql to connect to the database and test whether the database passes the test.

[Root @ localhost bin] #./isql-SNSMSSERVER-Usa-P Password

If the connection is correct, the ISQL command line mode is enabled. Otherwise, an error is prompted. The most common error is

CT-LIBRARY errors:

Ct_connect (): directory service layer: internal directory control layer error: Requested server name not found.

This indicates that your interface is configured incorrectly or the environment variable is incorrect. Isql searches for the interface file in the $ SYBASE directory. My interface configuration file is as follows:

INSMSSERVER

Master tcp ether 192.168.1.895000

Query tcp ether 192.168.1.895000

Enter the ISQL command mode, enter the SQL command press enter, and then enter GO to execute the command.

In the Sybase installation directory. There is a OCS-12_5 directory, This Is The Openclient directory. Go to the example directory to issue two existing directories, this is CT and DB-library, two different access methods, the development is up to you