[freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation
Wilson Mak
wilson.mak at digitalview.com
Thu Sep 22 22:01:21 EDT 2005
Hi guys,
Thanks you so much for all these. I am now able to fetch all tables in
SQL2K. You are absolutely correct! I should put SQLSERVER in tsql
instead of 10.1.0.200.
Many thanks,
Wilson
>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
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
>
>
More information about the FreeTDS
mailing list