10

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!

tjsimmons
  • 733
  • 4
  • 10
  • 21

4 Answers4

11

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

Adam Vandenberg
  • 19,991
  • 9
  • 54
  • 56
  • So, using FreeTDS in conjunction with unixODBC through the iODBC Administrator will let me use pyodbc in Python? It's a bit late; haven't read through how FreeTDS matches up with unixODBC. – tjsimmons Oct 28 '10 at 05:25
  • FreeTDS should be usable as a provider w/ pyodbc. This project for instance uses FreeTDS + pyodbc to connect to SQL Server for Django: http://code.google.com/p/django-pyodbc/ – Adam Vandenberg Oct 28 '10 at 14:07
  • I didn't use the unixODBC, since OS X has iODBC pre-installed, but after fiddling with odbc.ini (and using the right port. dumb me), I got it working. Thanks! – tjsimmons Oct 28 '10 at 15:49
  • You can use pymssql directly with freetds and skip the ODBC layer if you want – Neil McGuigan Aug 16 '16 at 23:16
3

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:

Community
  • 1
  • 1
user1089766
  • 597
  • 6
  • 14
1

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

trashgod
  • 203,806
  • 29
  • 246
  • 1,045
hwilliams
  • 389
  • 2
  • 2
0

Have you looked at Mdblite on AppStore?

https://itunes.apple.com/us/app/mdblite/id487704620?ls=1&mt=12

Acacio
  • 118
  • 1
  • 1
  • 8