Microsoft ODBC driver for Linux vs FreeTDS?

Question

I am investigating the possibilities to connect to a MSSQL database from a RHEL6 application server. I have found two ways:

• FreeTDS
• Microsoft SQL Server ODBC Driver for Linux + unixODBC

Does anyone have experience in using either of these setups? (I'm especially curious about the latter, since it is officially supported by MS). Performance? Stability? Any other options I might be missing?

Answer 1

For the record, I went with FreeTDS at the moment. I evaluated both unixODBC and FreeTDS and found FreeTDS easier to work with at the moment.

Answer 2

Another option is the MS JDBC driver for SQL Server

Answer 3

If you're working with older versions of SQL Server (e.g. 2000), current Microsoft ODBC drivers may not work.

FreeTDS claims to work with all versions of MS SQL Server: http://www.freetds.org/faq.html#Does.FreeTDS.support.my.server