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