Re: SQL Server version and TDS Version

Vinh Nguyen wrote:
> 
> I am running FreeTDS on my Mac OS X connecting to Microsoft SQL Server
> 2005, so version 9 of MS SQL.  In order for "tsql" to work, I have to
> set the TDS version to be 4.2.  However, according to the
> documentations, shouldn't TDS version 7.0 and 8.0 work as well?  

Yes, they should.  And do!  :-)

> What can I do to get these versions to work?  

A TDSDUMP log would probably show what we need to know.  I'd keep a close
eye on iconv(3) and client encoding issues.  

--jkl