FreeTDS & MSDE

[Michael Williams_6]

Hi there - has anyone successfully connected to an MSDE or SQL Server 2005 Express Database? We've got FreeTDS working with the full SQL Server 2000 & 2005:

michaelw: tsql -S COFS1 -p 1433 -U sa -P sa
locale is "LC_CTYPE=en_GB;LC_NUMERIC=en_GB;LC_TIME=en_GB;LC_COLLATE=C;LC_MONETARY=en_GB;LC_MESSAGES=en_GB;LC_PAPER=en_GB;LC_NAME=en_GB;LC_ADDRESS=en_GB;LC_TELEPHONE=en_GB;LC_MEASUREMENT=en_GB;LC_IDENTIFICATION=en_GB"
locale charset is "ISO-8859-1"
1>

However, our MSDE & Express Databases all have \SOMETHINGOROTHER appended to the hostname, and this doesn't appear to be being picked up from the command line whether we use escape characters or ''s or anything.

Has anyone actually an example of a working connection? Please don't send any guesses - we've tried everything, we'd just like to compare with someone who actually is using the product and working!

[Kodjo Agbenu]

Hi Michael,

Try on a Microsoft forum : you may have more success.

Good lcuk.
Kodjo

[Michael Williams_6]

I might have needed to clarify that I'm trying this from a Linux Server with FreeTDS! I'm not sure them Windows people have ever tried such a ludicrous thing!