Where to download the ODBC Drivers and OLEDB Providers for the different versions of SQL Server Native Client?
The driver includes an installer, connection setup assistant, on-line help, and connection diagnostic tools. With this Mac ODBC solution, you'll be importing data from your SQL Server in no time. 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. Hello, I have been trying to install SSMS on a new windows 10 system for about a week now. This issue I am having is that the installer says another installation is already pending and needs the.
Microsoft ODBC Driver for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to SQL Server. Use Microsoft ODBC Driver 17 for SQL Server to create new applications or enhance existing applications that need to take advantage of newer SQL Server features. Jan 11, 2007 Microsoft SQL Server 2005 Compact Edition (SQL Server 2005 Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop, tablet PC and mobile devices.
There are different versions of the Native Client components for each SQL Server.
- SQL Server 2005 - Native Client 9.0
- SQL Server 2008 - Native Client 10.0
- SQL Server 2012 - Native Client 11.0
The components have been distributed through SQL Server 'Feature Packs' and there are new versions of those 'Feature Packs' for each Service Pack release of SQL Server.
This page lists instructions and download links for each version of the Native Client OLE DB providers and ODBC drivers and for each Feature Pack distribution package. If you find something is missing, let us know here!
Download SQL Server 2005 Native Client ODBC & OLEDB
Booth the ODBC driver and the OLEDB provider have been released within the 'Feature Pack for Microsoft SQL Server 2005'.
There are four versions of this Feature Pack. The latest is the 'December 2008' package.
The package contains:
- SQL Native Client 9.0 OLE DB Provider - 'SQLNCLI'
- SQL Native Client 9.0 ODBC Driver - '{SQL Native Client}'
Download Instructions
First navigate to one of the download links below, then:
- Hit Download button.
- Checkbox one of the installation packages (msi). Make sure you choose the right version:
- sqlncli.msi for 32-bit
- sqlncli_x64.msi for 64-bit
- sqlncli_ia64.msi for Itanium
- Click Next.
- Download starts.
Feature Pack for SQL Server 2005 - download links
Download SQL Server 2008 Native Client ODBC & OLEDB
Booth the ODBC driver and the OLEDB provider have been released within Microsoft SQL Server 2008 'Feature Packs'.
There are different 'Feature Packs' for each SQL Server 2008 service pack version.
The package contains:
- SQL Server Native Client 10.0 OLE DB Provider - 'SQLNCLI10'
- SQL Server Native Client 10.0 ODBC Driver - '{SQL Server Native Client 10.0}'
Download Instructions
First navigate to one of the download links below, then:
- Hit Download button.
- Checkbox one of the 'sqlncli.msi' installation packages. Make sure you choose the right version:
- x86 for 32-bit
- x64 for 64-bit
- IA64 for Itanium
- Click Next.
- Download starts.
Feature Pack for SQL Server 2008 - download links
- SQL Server 2008 SP1 Feature Pack - NO LONGER AVAILABLE
- SQL Server 2008 Feature Pack - NO LONGER AVAILABLE
Download SQL Server 2008 R2 Native Client ODBC & OLEDB
Booth the ODBC driver and the OLEDB provider have been released within Microsoft SQL Server 2008 R2 'Feature Packs'.
There are different 'Feature Packs' for each SQL Server 2008 R2 service pack version.
The package contains:
- SQL Server Native Client 10.0 OLE DB Provider - 'SQLNCLI10'
- SQL Server Native Client 10.0 ODBC Driver - '{SQL Server Native Client 10.0}'
Download Instructions
Microsoft Sql Server Odbc Drivers
First navigate to one of the download links below, then:
- Hit Download button.
- Checkbox one of the 'sqlncli.msi' installation packages. Make sure you choose the right version:
- sqlncli_x86.msi for 32-bit
- sqlncli_amd64.msi for 64-bit
- sqlncli_ia64.msi for Itanium
- Click Next.
- Download starts.
Feature Pack for SQL Server 2008 R2 - download links
Download SQL Server 2012 Native Client ODBC & OLEDB
Booth the ODBC driver and the OLEDB provider have been released within the 'Microsoft SQL Server 2012 Feature Pack'.
There are currently only one 'Feature Pack' for SQL Server 2012.
The package contains:
- SQL Server Native Client 11.0 OLE DB Provider - 'SQLNCLI11'
- SQL Server Native Client 11.0 ODBC Driver - '{SQL Server Native Client 11.0}'
Download Instructions
First navigate to one of the download links below, then:
- Do NOT hit the Download button
- Expand the 'Install Instructions' section
- Scroll down to the 'MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS' section (it's far down)
- Under the 'Microsoft SQL Server 2012 Native Client' heading, click one of the 'sqlncli.msi' installation package links. Make sure you choose the right version:
- X86 Package for 32-bit
- X64 Package for 64-bit
- seems there are no link for the Itanium CPU architecture
- Download starts.
Feature Pack for SQL Server 2012 - download links
Summary
This page aims to provide all information needed to obtain the correct Native Client ODBC Driver or Native Client OLEDB Provider for connections to SQL Server. If any info on this page is not up to date, not correct, unclear or could be more precise, let us know buy sending us info through this form. Thanks!
-->This topic lists the requirements to use the Microsoft ODBC Driver for SQL Server on Linux and macOS.
SQL version compatibility
The Linux and macOS drivers SQL version compatibility is the same as the Windows drivers SQL version compatibility.
Microsoft Odbc Driver 11 For Sql Server
Operating system support
Versions 17, 13.1, and 13 of the Linux and macOS drivers are supported on the x64 architecture of the following operating systems:
| Driver version → ↓ Operating System | 17.6 | 17.5 | 17.4 | 17.3 | 17.2 | 17.1 | 17.0 | 13.1 | 13 |
|---|---|---|---|---|---|---|---|---|---|
| Apple OS X 10.11 (El Capitan) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| Apple macOS 10.12 (Sierra) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| Apple macOS 10.13 (High Sierra) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Apple macOS 10.14 (Mojave) | Yes | Yes | Yes | Yes | |||||
| Apple macOS 10.15 (Catalina) | Yes | Yes | |||||||
| Alpine Linux 3.11 | Yes | Yes | |||||||
| Debian Linux 8 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Debian Linux 9 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Debian Linux 10 | Yes | Yes | Yes | ||||||
| Oracle Linux 8 | Yes | Yes | |||||||
| RedHat Enterprise Linux 6 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| RedHat Enterprise Linux 7 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| RedHat Enterprise Linux 8 | Yes | Yes | Yes | ||||||
| SUSE Linux Enterprise Server 111 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SUSE Linux Enterprise Server 12 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SUSE Linux Enterprise Server 15 | Yes | Yes | Yes | Yes | |||||
| Ubuntu Linux 14.04 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| Ubuntu Linux 16.04 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Ubuntu Linux 18.04 | Yes | Yes | Yes | Yes | Yes | ||||
| Ubuntu Linux 20.04 | Yes |
1 ODBC Driver 17 supports SUSE Linux Enterprise Server 11 SP4 only
The installation packages for the Microsoft ODBC Driver 13, 13.1, and 17 for SQL Server on Linux and macOS resolve the driver's dependencies automatically when installed using the package management system of your distribution, as described in Install the ODBC Driver (Linux) and Install the ODBC Driver (macOS).
Microsoft ODBC Driver 11 for SQL Server
Microsoft Sql Server Odbc Driver For Mac
Odbc Drivers Missing
64-bit UnixODBC 2.3.0 Driver Manager, built for 64-bit SQLLEN/SQLULEN. Later versions of the 64-bit UnixODBC Driver Manager are not supported with the ODBC driver on Linux. See Installing the Driver Manager for more information.
ODBC driver for Red Hat Enterprise Linux 5 (64-bit) requires the following packages, and can be downloaded here: Microsoft ODBC Driver 11 for SQL Server - Red Hat Linux
glibclibgcclibstdc++e2fsprogs-libskrb5-libsopenssl
ODBC driver for Red Hat Enterprise Linux 6 (64-bit) requires the following packages, and can be downloaded here: Microsoft ODBC Driver 11 for SQL Server - Red Hat Linux
glibclibgcclibstdc++libuuidkrb5-libsopenssl
ODBC driver for SUSE Linux Enterprise 11 Service Pack 2 (64-bit) requires the following packages, and can be downloaded here: Microsoft ODBC Driver 11 Preview for SQL Server - SUSE Linux
glibclibstdc++46libgcc46libuuid1krb5libopenssl0_9_8
See Also
Microsoft Sql Server Odbc Driver
Installing the Driver Manager
Known Issues in this Version of the Driver
Release Notes