How do I run ODBC on 64-bit?

Open the Command Prompt, or press the WIN + R keys to open the Run dialog box. Type odbcad32 and press Enter. If you’re running Windows 10 64-bit, this should launch ODBC Data Source (64-bit). Otherwise, it will open ODBC Data Source (32-bit) instead.

How do I create an ODBC connection in SQL Server?

1. Click Start and select Settings > Control Panel > Administrative Tools.
2. Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.
3. Select the System DSN tab.
4. Click Add.
5. Select SQL Server and click Finish.
6. Complete the DSN Configuration wizard (see example screen shots below)

Does SQL Server support ODBC?

The Microsoft ODBC Driver for SQL Server can be used to create new applications. You can also upgrade your older applications which currently use an older ODBC driver. The ODBC Driver for SQL Server supports connections to Azure SQL Database, Azure Synapse Analytics, and SQL Server.

What is the latest version of ODBC driver for SQL Server?

Version 17.7.2 is the latest general availability (GA) version. If you have a previous version of Microsoft ODBC Driver 17 for SQL Server installed, installing 17.7.2 upgrades it to 17.7.2.

Does TLS work with SQL Server 2008 R2 SNAC drivers?

This page contains updates providing TLS 1.2 support for SQL Server 2008 and SQL Server 2008 R2 SNAC (SQL Native Client) drivers. These updates were prioviously only available on the Microsoft Hotfix server which has since been decommissioned.

What is the latest version of Adal for SQL Server?

Starting with version 17.4.2, the installer also includes and installs the Microsoft Active Directory Authentication Library (ADAL.dll). Version 17.8.1 is the latest general availability (GA) version. If you have a previous version of Microsoft ODBC Driver 17 for SQL Server installed, installing 17.8.1 upgrades it to 17.8.1.