Sybase on Linux

[nagasekhar]

Hi,
I am new to Linux. My problem is: I have Sybase installed on Linux Server (Red Hat Linux 7.2). I want to connect to Sybase server from another Linux system. I tried to connect giving $isql -S<servername> -U<username> -P<passwd>. an it was successful. But when i tried the same with <IP of the server> instead of <servername>, it failed.
I tried to insert the entry in interfaces file, but it is not accepting any entry with IP address. Why is it so?

 

[sybaseguru]

Dear Friend,

Unfortunately you cannot use IP address in isql. If you look at the interfaces file Like the one below you will see that like Oracle instance Sybase server listens to incoming connection on a PORT on the host. For example

lon_gen_sql_tst1
master tcp ether linux 5000
query tcp ether linux 5000

In this case Sybase is listening on host 'linux', on Port ID 5000. So when you specify the IP address it will not help. Now you need to find out (by looking at the interfaces file on host where ASE running under $SYBASE/interfaces) which port it is listening too. In that case on your second box you can create an interface file with entries as above (put it wherever you like). Note that server name (in this case lon_gen_sql_tst1) is totally logical. In other words you can call it whatever you like. As long as the entry in the interfaces file has the correct host and PORT No all should be OK. You can create interfaces file manually. Just copy what I gave you

Your isql should look like below. Replace ${PATH} with directory where you have put your interfaces file.

isql -U?? -P?? -Slon_gen_sql_tst1 - I ${PATH}/interfaces

Good luck