8

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

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?

Krumelur
  • 31,081
  • 7
  • 77
  • 119
  • 1
    Are you still using FreeTDS in 2019? I've been using it since 2014, mainly without issues, but I'm curious about Microsoft's drivers. Their recent docs look very useful: https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15 – Neil C. Obremski Nov 19 '19 at 15:07
  • No, not using it anymore. – Krumelur Nov 22 '19 at 13:40

3 Answers3

4

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.

Krumelur
  • 31,081
  • 7
  • 77
  • 119
  • 3
    Would you care to expand on this answer? I also want to know the differences between the two options you provided in your question. How or in what way is FreeTDS easier to work with? – nmc Feb 15 '13 at 17:09
  • I found the documentation better, the APIs easier to start with and maybe most important, installation and deployment a lot easier. A big plus is that I can also read and understand the source code for FreeTDS. – Krumelur Feb 16 '13 at 09:14
2

Another option is the MS JDBC driver for SQL Server

mavroprovato
  • 8,023
  • 5
  • 37
  • 52
2

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

graysonwright
  • 514
  • 2
  • 8