[freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation

Daniel Fazekas fdsubs at t-online.hu
Thu Sep 22 09:43:53 EDT 2005


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



More information about the FreeTDS mailing list