while trying connect remote sql server:
$tsql -s localhost -u myuser
i got error like:
locale "en_us.utf-8" locale charset "utf-8" using default charset "utf-8" error 20009 (severity 9): unable connect: adaptive server unavailable or not exist os error 61, "connection refused" there problem connecting server
the output of $tsql -c
below:
compile-time settings (established "configure" script) version: freetds v0.91 freetds.conf directory: /usr/local/freetds/conf/freetds ms db-lib source compatibility: no sybase binary compatibility: no thread safety: yes iconv library: no tds version: 5.0 iodbc: no unixodbc: no sspi "trusted" logins: no kerberos: no
i have created tunnel remote server like:
$ssh -l 1433:db_server:1433 user@mid_server
this forward local port 1433 db_server. tested. ssh tunnel works because can connect database using navicat (localhost on 1433). can telnet localhost on port 1433.
i kinda worked modifying freetds.conf
from
[global] # tds protocol version ; tds version = 4.2
to
[global] # tds protocol version tds version = 7.0
Comments
Post a Comment