src/tds/login.c: tds_connect: 192.168.0.1:4000: Connection refused
Oliver Bienert
oliver.bienert at gmx.de
Wed Nov 20 07:06:13 EST 2002
Hi all,
At least successfully compiled and installed freetds at my debian woody
box.
Compiled with unixODBC Support.
Running MS SQL Server 2000 at a w2k system.
I am able to connect by tsql:
debian:~# tsql -S MyServer70 -U sa -P ""
Msg 5703, Level 0, State 1, Server OLIVER, Line 0
Changed language setting to us_english.
1>
However, I get the following error-message, while trying to this via odbc:
debian:~# isql -v MyServer70 sa ""
src/tds/login.c: tds_connect: 192.168.0.1:4000: Connection refused
[unixODBC]tds_connect failed
[ISQL]ERROR: Could not SQLConnect
What is this port number 4000 com from? Note, that I am can successfully
connect to the default JDBC Database via odbc.
This is my freetds.conf:
[global]
# TDS protocol version
tds version = 4.2
initial block size = 512
swap broken dates = no
swap broken money = no
try server login = yes
try domain login = no
cross domain login = no
[MyServer70]
host = oliver.waldwerk.de
port = 1433
tds version = 7.0
This is my odbc.ini:
[ODBC Data Sources]
MyServer70 = MS SQL Server 2000 auf oliver
[MyServer70]
Driver = /usr/local/lib/libtdsodbc.so
Description = MS SQL Server 2000 auf OLIVER
Trace = no
Servername = OLIVER
Database = Northwind
UID = sa
PWD =
[Default]
Driver = /usr/local/lib/libtdsodbc.so
Regards Oliver
More information about the FreeTDS
mailing list