The CData ODBC Driver for SQL Server is a standards-based ODBC driver with editions for Windows and Unix-based operating systems, like macOS and Linux. The following sections show how to create an ODBC data source and query data.
Creating a DSN on Your Platform
The following guides show how to use the standard tools to configure data source names (DSN).
Windows DSN Configuration shows how to configure a DSN with the Microsoft ODBC Administrator tool.
macOS DSN Configuration shows how to configure a DSN with the iODBC driver manager.
Linux DSN Configuration shows how to configure DSNs with several major driver managers on Linux.
SQL Server Version Support
The driver enables connectivity to SQL Server through the TDS protocol. SQL Server versions 2008, 2012, 2014, 2016, and 2019 are suppported.
Connections to Azure SQL Server and Azure Data Warehouse instances are supported as well.
See the following sections to connect to the DSN from tools and from code: