Installation guide

mxODBC - Python ODBC Database Interface

4. Accessing Popular Databases

This section provides information on available ODBC drivers for various popular

database as well as notes regarding setup, functionality or available workarounds

for compatibility problems eGenix.com found with the drivers.

We have also included the resp. version information of the drivers we have tested

successfully with mxODBC.

4.1 MS SQL Server

4.1.1 Available ODBC Drivers

MS SQL Server Native Client for SQL Server 2005, 2008 and later

Homepage: http://msdn.microsoft.com/en-us/sqlserver/connectivity.aspx

Tested with MS SQL Server Native Client for 2005, 2008, 2008R2 and 2012

SQL Server Native Client is the native database client and ODBC driver for SQL

Server 2005, 2008 and later on Windows. Versions for 32-bit and 64-bit Windows

are available.

Finding the latest version of the SQL Server Native Client for Windows

Microsoft always ships the SQL Server Native Client ODBC driver together with

the SQL Server database packages, but also makes it available as separate

download in the feature packs for each new SQL Server version.

Since the client can typically also be used with older SQL Server installations, it's

worth trying the latest available version in case of problems or to benefit from

new features. As of this writing, the latest version is SQL Server Native Client 11.

Here's a list of feature packs that include the SQL Server Native Client. You have

to look for an installation file called sqlncli.msi or msodbcsql.msi on the pages:

• Microsoft ODBC Driver 11 for SQL Server

Supports SQL Server 2005, 2008, 2008 R2 and 2012, 2014 and Windows

Azure SQL Database.

• Microsoft SQL Server 2012 SP2 Feature Pack