FreeTDS Development Group

["Oliver Bienert" <oliver.bienert AT gmx.de>]

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