SQL Server version and TDS Version

Vinh Nguyen <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hi,

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?  What
can I do to get these versions to work?

My ultimate goal (for now) is to get freeTDS to work with unixODBC
(isql and osql commands -- ultimately in emacs).  However, even though
I can connect to the sql server using tsql, I can't with isql and osql
-- it won't log me in.  I have a hunch that this has to do with the
TDS version.  If I could get tsql to work at v8.0, then I can test the
isql/osql commands again to see if I can rule this out.  I know
unixODBC is recognizing my DSNs.  It just can't log in.

Please let me know of your suggestions.  I couldn't find an answer googling.

Thanks!
Vinh
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.