Unable to connect: Adaptive Server is unavailable or does not exist Unable to connect: Adaptive Server is unavailable or does not exist sql-server sql-server

Unable to connect: Adaptive Server is unavailable or does not exist


I kinda get it worked by modifying freetds.conf

from

[global]    # TDS protocol version;   tds version = 4.2

to

[global]    # TDS protocol versiontds version = 7.0


This worked for me with ASE 16.0 installed and running on Ubuntu 14.04 LTS, both client and server.

  • SERVER: Make sure there is an entry in /etc/hosts of your server (sybaseServer). In a standard Ubuntu 14.04 installation you will not find this, but "127.0.1.1 sybaseServer". But sybase seems depends on it.

/etc/hosts
...
192.168.1.100 sybaseServer
...

  • CLIENT: The entry in freetds.conf is

[SYBASE]
host = 192.168.1.100
port = 5000
tds version = 5.0

Now you can connect to your server:

$tsql -S SYBASE -U sa

  • obviously you have to replace IP-address, servername etc. with your own data