FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

> 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
                    ^^^^^^
This should be MyServer70. Servername refer to Server in freetds.conf, not
direct server. If you use snapshot/CVS you can also use freetds.conf-less
and even DSN-less connections.

> Database      = Northwind
> UID           = sa
> PWD           = 
> [Default]
> Driver                = /usr/local/lib/libtdsodbc.so
> 
> 
> Regards Oliver
> 

bye
  freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================