Data Source Names and 64-Bit Operating Systems

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Important

SQL Server Native Client (SNAC) isn't shipped with:

• SQL Server 2022 (16.x) and later versions
• SQL Server Management Studio 19 and later versions

The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) aren't recommended for new application development.

For new projects, use one of the following drivers:

• Microsoft ODBC Driver for SQL Server
• Microsoft OLE DB Driver for SQL Server

For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

To build and run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source with the ODBC Administrator in %windir%\SysWOW64\odbcad32.exe.

Remarks

A 64-bit Windows operating system has two odbcad32.exe files:

• %SystemRoot%\system32\odbcad32.exe is used to create and maintain data source names for 64-bit applications.

• %SystemRoot%\SysWOW64\odbcad32.exe is used to create and maintain data source names for 32-bit applications, including 32-bit applications that run on 64-bit operating systems.

See Also

SQL Server Native Client (ODBC)