For this article, you will use unixODBC, a free and open source ODBC driver manager that is widely supported.įor Debian-based systems like Ubuntu, you can install unixODBC with the APT package manager: For more information on the supported versions of Linux operating systems and the required libraries, please refer to the 'Getting Started' section in the help documentation (installed and found online).īefore installing the driver, check that your system has a driver manager. There are also several libraries and packages that are required, many of which may be installed by default, depending on your system. The CData ODBC Drivers are supported in various Red Hat-based and Debian-based systems, including Ubuntu, Debian, RHEL, CentOS, and Fedora. Using the CData ODBC Drivers on a UNIX/Linux Machine This article shows how to use the pyodbc built-in functions to connect to SQL Server data, execute queries, and output the results. With the CData Linux/UNIX ODBC Driver for SQL Server and the pyodbc module, you can easily build SQL Server-connected Python applications. The rich ecosystem of Python modules lets you get to work quicker and integrate your systems more effectively.

Linux odbc driver for sql server