Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mac OS X 10.6 ODBC Drivers

I'm going crazy trying to find a FOSS free (doesn't have to be open source) ODBC driver to connect to an MS SQL Server. While it doesn't strictly have to be free (which is a huge plus, for obvious reasons), the drivers I have found haven't had an easy to find price tag.

Does anyone know of any preferably free, and if not free, then relatively (sub $30, since it's just for the random times I might need it) cheap drivers for ODBC - MS SQL on OS X?

Thanks!

like image 310
tjsimmons Avatar asked Oct 28 '10 04:10

tjsimmons


3 Answers

unixODBC + FreeTDS is one way: http://www.freetds.org/ & http://www.unixodbc.org/

like image 59
Adam Vandenberg Avatar answered Oct 19 '22 23:10

Adam Vandenberg


Here's a random extract from Microsoft Office support:

If you want to import data into Excel for Mac from a database, you must first install compatible Open Database Connectivity (ODBC) drivers — software that Excel can use to access your database server. ODBC drivers that are compatible with Excel for Mac are available from the following third-party vendors:

  • OpenLink Software
  • Actual Technologies
  • Simba Technologies
like image 39
user1089766 Avatar answered Oct 19 '22 23:10

user1089766


Have you looked at the OpenLink Express Driver for SQL Server on Mac OS X? (Registration required.)

like image 45
hwilliams Avatar answered Oct 20 '22 01:10

hwilliams