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