CODEWITHSUNDEEP
sqlsolarissybase
Solook
Solook

Reputation: 3

Connecting Sybase and running SQL from Solaris

I want to connect from a Solaris environment to a remote Sybase server (I have the IP and user credential to connect) and run some SQL queries. What existing apps/scripts can I use?

Upvotes: 0

Views: 1348

Answers (1)

Vince
Vince

Reputation: 734

if you are talking about Sybase ASE server (I am not sure for SQLAnywhere) you local isql can access to a remote ASE server. In your Sybase client home, add the following in your 'interfaces' file in replacing hostname and ASE_port_number:

ASE_SERVER
    master tcp ether <hostname> <ASE_port_number>
    query tcp ether <hostname> <ASE_port_number>

example:

ASE_TEST_A
    master tcp ether server1 5200
    query tcp ether server1 5200

then run ISQL: isql -U sa -S ASE_TEST_A -P password -w200

Upvotes: 1

Related Questions