This tutorial walks you through on how you can connect to SQL Server database from Linux machine using an ODBC driver. We drafted a step-by-step guide to:
1. install SQL Server ODBC Driver on a Linux machine
2. Configure the ODBC driver
3. Test the ODBC connection
Tip: If you get an exception saying that it cannot find <sql.h> library, you might have to install unixODBC packages. You can install them by running the following command.
We hope this tutorial helped you to connect to your SQL Server database. Note that we have used the SQL Server Authentication mode for this tutorial, but DataDirect SQL Server ODBC and JDBC drivers also support Windows authentication and Kerberos too.
Also please note that we recommend and require use of the Progress ODBC driver manager, which is shipped with the Progress ODBC drivers. Progress DataDirect ODBC drivers are not certified with the unixODBC Driver Manager and reported issues must be reproducible with a supported version of the DataDirect ODBC Driver Manager for Unix/Linux.
Feel free to try the SQL Server ODBC driver for 30 days and contact us if you need an extension for the trial.