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!
unixODBC + FreeTDS is one way: http://www.freetds.org/ & http://www.unixodbc.org/
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
Have you looked at the OpenLink Express Driver for SQL Server on Mac OS X? (Registration required.)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With