Installation guide

4. Accessing Popular Databases
[ODBC Drivers]
MSNativeClient = Installed
[MSNativeClient]
Driver = /opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Description = MS SQL Server Native Client 11
Threading = 1
• Add a data source to the /etc/odbc.ini (or ~/.odbc.ini):
[mssqlserver2008]
Driver = /opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Description = MS SQL Server 2008 running on Picasso (MS Native
Client)
Server = tcp:picasso\SQLSERVER2008,1436
Database = testdb
The syntax for the Server entry is described in the MSDN article SQL
Server Native Client ODBC Connection String Format.
EasySoft ODBC Driver for SQL Server
Homepage: http://www.easysoft.com/
OpenLink ODBC Driver for SQL Server
Homepage: http://www.openlinksw.com/
DataDirect ODBC Driver for SQL Server
Homepage: http://www.datadirect.com/
Actual Technologies Mac OS X ODBC Driver for SQL Server
Homepage: http://www.actualtech.com/
When using the driver on Mac OS X 10.6 (Snow Leopard), be sure to use version
3.0.9 or higher, since earlier versions had a problem with fetching data.
FreeTDS Unix ODBC Driver for SQL Server
Homepage: http://www.freetds.org/
Tested with FreeTDS 0.91 ODBC driver compiled against unixODBC 2.3.2.
The FreeTDS ODBC driver implements the client side of the TDS wire protocol
used by Sybase ASA and Microsoft SQL Server installations. It allows you to
directly connect to a SQL Server database from a Unix machine.
Driver Limitations
• The FreeTDS ODBC driver version 0.91 introduces Unicode support for
the first time in its version history. The previous stable version 0.82 did
not have Unicode support. We've had most success using the
NATIVE_UNICODE_STRINGFORMAT mode.
37