Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Wilson Mak <wilson.mak AT digitalview.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connection to SQL2000 - Unicode data in a Unicode-only collation
  • Date: Fri, 23 Sep 2005 10:01:21 +0800

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








Archive powered by MHonArc 2.6.24.

Top of Page