FreeTDS Development Group

[Daniel Fazekas <fdsubs AT t-online.hu>]

On Sep 22, 2005, at 10:24, Wilson Mak wrote:

> Thanks for your input.  I tried to change it to TDS 8.0, but still it
> wont work.  Any clues?

While I'm sure what the others say about the technical problems which  
should prevent it from working no matter what are correct, I couldn't  
help but notice...

> > | # tsql -S 10.1.0.200:1433 -U sa -I /etc/freetds.conf
[...]
> > | Here is the freedts.conf:
> > | [SQLSERVER]
> > | host                    = 10.1.0.200
[...]

...that you seem to be instructing tsql to ignore whatever you are  
setting in freetds.conf.

The -S switch requires a "server name" as set by yourself in  
freetds.conf, that is, the string you put between the square brackets.
In your case, it should be tsql -S SQLSERVER

--
fds