After SQL Server 2012, the primary ODBC driver for SQL Server has been developed and released as the Microsoft ODBC Driver for SQL Server. The Microsoft ODBC Driver for SQL Server is the driver that is updated with the most recent server features going forward.
How do I know what version/build I have? Look in the C:\Windows\System32 or C:\Windows\SysWOW64 folder for the file:
msodbcsql18.dll, or
msodbcsql17.dll, or
msodbcsql13.dll, or
msodbcsql11.dll
In the file properties, the Details tab and the Product version field.
You can comment here. If you know of a Microsoft ODBC Driver for SQL Server version that we don’t have listed here, please use the comments.
I work on this site continuously and keep the information up to date. If it helps you, you can support me:
Provide feedback
Saved searches
Use saved searches to filter your results more quickly
Sign up
This ODBC Driver is provided by Microsoft.
The main functionality of the driver is contained in the file msodbcsql17.dll.
Include «Driver={ODBC Driver 17 for SQL Server}» in the connection string to use this driver.
Description
The Microsoft ODBC Driver 17 for SQL Server provides native connectivity from Windows, Linux, & macOS to SQL Server and Azure SQL Databases. Note that this driver supports SQL Server 2019 only from version 17.3.
More info about this driver can be found at the Microsoft product page.
Download
This ODBC Driver, Microsoft ODBC Driver 17 for SQL Server, can be downloaded here.
Connection Strings
The Microsoft ODBC Driver 17 for SQL Server driver can be used to connect to the following data sources by using the following connection string references:
SQL ServerSQL Server 2019SQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012SQL Server 2008
- Introduction
- Connect to Microsoft SQL Server
- Setup ODBC
- Troubleshooting
- More Information
Introduction
This article explains how to connect to Microsoft SQL Server with ODBC from Windows 10.
It covers the following topics:
- How to connect to Microsoft SQL Server (with code samples).
- How to setup ODBC:
- Configure ODBC using the ODBC Data Source Administrator:
We recommend using system DSNs (available to all users).
- Configure ODBC using the ODBC Data Source Administrator:
Connect to Microsoft SQL Server [top]
We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples.
Follow these steps to connect:
- Create a new channel to try out the code:
- Create a channel like this:
- Name: DB SQL Server Connection (or similar)
- Source: From Translator
- Destination: To Channel
- Alternatively use an existing channel:
Your channel will need a From/To Translator or a Filter component.
- Create a channel like this:
- Connect to a database using ODBC:
- Paste this code into the Translator:
If your script uses connection object methods
conn:query{}orconn:execute{}to connect to a remote Microsoft SQL Server database, the location of the remote host is specified as part of the name parameter in thedb.connect{ }command. If you useconn:merge{}to connect the remote host is specified as part of the name parameter in theconn:merge{}command itself.function main() local conn = db.connect{ api=db.SQL_SERVER, name='your_odbc_server_name', user='', -- use empty string for integrated security password='', -- use empty string for integrated security use_unicode = true, live = true } conn:execute{sql='SELECT * FROM <your table>', live=true} end - The name is the name of an ODBC source that you create using the ODBC Administrator.
- Paste this code into the Translator:
- Adapt the code to your requirements.
Setup ODBC [top]
Note: Iguana may not always support the very latest version of the Microsoft SQL Server ODBC drivers, so you can simply download an earlier version if necessary. This is particularly true if you are not able to use the the latest version of Iguana.
If you need to know which versions of Microsoft SQL Server are supported by the version of Iguana you are using please contact us at support@interfaceware.com.
To set up a new ODBC data source for Microsoft SQL Server:
- Install the latest Microsoft SQL Server ODBC drivers:
- Download the latest drivers from the Microsoft ODBC download site.
- Run the installer and accept the defaults.
- Open the 64 bit ODBC Administrator:
Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources — always use the 64 bit ODBC Administrator.
- Open the System DSN tab and click Add:
- Choose the latest SQL Server ODBC driver and click Finish:
- Enter the ODBC credentials:
- Use any Name and Description you prefer.
- Enter the Network Name of the SQL Server in the Server field:
Note: If you are unsure of the name ask your DBA (database administrator). - Click Finish to create the ODBC data source:
- This will open the the ODBC Microsoft SQL Server Setup dialog box that lists the chosen settings:
The ODBC source will use all the standard defaults which will work in most cases. There are two settings that you may need to change: Use Integrated Security and Database. Speak to your DBA (database administrator) about changing these if necessary.
- Use Integrated Security: Sometimes you might want to use a SQL Server user and password
- Database: You can specify the database that you want to use by default.
- Test the data source connection:
If you need to modify the ODBC source follow these steps:
- These are the two most common things to change:
- Default Database: Change to Test
- User Login: Change to user billsmith with password something-secret
- Modify the ODBC source to change Database and User:
- Change the default database:
- Select the Change the default database option:
- Choose your default database from the drop list and click Next:
- Finally test the connection to see that the changes worked.
Troubleshooting [top]
- Problems with connection settings:
Speak to your DBA (database administrator) for general connection issues like: User name and password, Database Server network name etc.
- Iguana may not always support the very latest version of the ODBC drivers:
Please contact us at support@interfaceware.com if you need to know the latest supported version of the ODBC drivers.
- Incorrect port number:
SQL Server defaults to port 1433, but a different port can be used. Speak to your database administrator (DBA) or network administrator.
- Using integrated security:
Using integrated security is the usual way to connect to a Microsoft SQL Server database. If this does not work speak to your DBA (database administrator) about the user credentials you should use to connect to the database.
If you need more help please contact us at support@interfaceware.com.
More Information [top]
- Using Database Connection Objects
- Forum thread on Windows ODBC
- Using Integrated Authentication, Microsoft SQL Server documentation (kerberos etc)
- Connect to Microsoft SQL Server from Linux or Mac with ODBC
Overview
Progress DataDirect’s ODBC Driver for SQL Server offers a high-performing, secure and reliable connectivity solution for ODBC applications to access SQL Server data. Our ODBC driver can be easily used with all versions of SQL and across all platforms — Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.
- Use of bulk capabilities when uploading large volume of data
- Use industry standard Kerberos and NTLM as a secure way of authentication.
- Secure sensitive data using column encryption
What’s Included
- Microsoft SQL Server
- Microsoft Analytics Platform System
- Microsoft Azure Synapse Analytics
- Big Data Clusters
Features
Support for Windows Truststore for SSL Certificate Validation
Support for Bulk Upload
Load large amounts of data to the database faster. When the Enable Bulk Load option is on, the driver uses the database bulk protocol when an application executes an Insert with multiple rows of parameter data.
Support for Always Encrypted
Store sensitive data on the server in an encrypted state. The driver transparently decrypts data from encrypted columns and returns them to the application. This reduces exposure of potential vulnerabilities, including server-side security breaches.
Support for High Availability
With the Multi Subnet Failover option is enabled, the driver attempts parallel connections to all failover IP addresses in an Availability Group when the connection is broken, or the listener IP address is unavailable. The first IP address to successfully respond to the request is used for the connection.
Support for Secure Authentication Mechanism
Supports secure Azure Active Directory authentication using Azure AD credentials or a generated Access Token
Security and Compliance
Protect customer-sensitive data elements (including remote credential or database pairings stored) with encryption, both at rest (AES-256) and in transit (SSL/TLS).
Cross-platform Support
Use one ODBC driver for all versions of SQL across all platforms — Unix / Linux, AIX, Solaris, Windows and HP-UX — to maximize development resources.
Technical Specifications
Progress DataDirect Connect and Connect64 for ODBC SQL Server Wire Protocol Driver
Version 8.0.2
(32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)
ODBC Version Support
- Compatible with ODBC 3.8 applications
Database Support
- Microsoft Fabric
- Microsoft Fabric
(Support introduced with driver version 08.02.2150 (B3227, U3190))
- Microsoft Fabric
- Microsoft Azure Synapse Analytics
- Microsoft Azure Synapse Analytics, version 12 and higher
(Support introduced with driver version 07.16.0369 (B0372, U0245))
- Microsoft Azure Synapse Analytics, version 12 and higher
- Microsoft Analytics Platform System
- Microsoft Analytics Platform System, version 10 and higher
(Support introduced with driver version 07.16.0369 (B0372, U0245))
- Microsoft Analytics Platform System, version 10 and higher
- Microsoft SQL Server Big Data Clusters
- Microsoft SQL Server 2019 Big Data Clusters and higher
- Microsoft SQL Server
- Microsoft SQL Server 2022 and higher
- Microsoft SQL Server 2019 and higher
- Microsoft SQL Server 2017 and higher
- Microsoft SQL Server 2016 and higher
- Microsoft Windows Azure SQL Database
- Microsoft Windows Azure SQL Database Version 12.0 and higher
Operating System Support
AIX (32- and 64-bit)
- AIX, version 7.3 and higher
- AIX, version 7.1 and higher
HP
- HP-UX IPF, 11i version 3.0 (B.11.3x) and higher
- HP-UX PA-RISC (32-bit only), version 11i version 3.0 and higher
Note: For HP-UX PA-RISC, the 32-bit driver installers work only on 64-bit platforms. Please contact Technical Support if you want to use the driver on the 32-bit platforms.
Linux x86 (32- and 64-bit for AMD and Intel processors. 64-bit for Itanium II.)
- Debian Linux x86, version 12.0 and higher
- Oracle Linux x86, version 9.0 and higher
- Red Hat Enterprise Linux x86, version 8.0, 9.0 and higher
- SUSE Linux Enterprise Server Linux x86, version 12, 15 and higher
- Ubuntu Linux x86, version 20.04, 22.04 and higher
Linux on System Z (64-bit only)
- Oracle Linux x64, version 9.0 and higher
- Red Hat Enterprise Linux x64, version 8.0, 9.0 and higher
- SUSE Linux Enterprise Server Linux x64, version 12, 15 and higher
Solaris (32- and 64-bit)
- Solaris x86 version 10 (Solaris 5.10), 11 and higher
- Solaris on SPARC, version 10, 11 and higher
Note: For Solaris and Solaris on SPARC, the 32-bit driver installers work only on 64-bit platforms. Please contact Technical Support if you want to use the driver on the 32-bit platforms.
Windows (32- and 64-bit)
- Windows (x86), version 10, 11 and higher
- Windows Server (x86), version 2016, 2019, 2022 and higher
Driver/Client Software Requirements
- No Requirements