[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