SQL Server

Instruction for SQL Server

For SQL Server, you need to install the unixodbc package and the Perl DBD::ODBC driver:

sudo apt install unixodbc
sudo apt install libdbd-odbc-perl

sudo yum install unixodbc
sudo yum install perl-DBD-ODBC
sudo yum install perl-DBD-Pg

Then install the Microsoft ODBC Driver for SQL Server. Follow the instructions for to your operating system from here:

https://docs.microsoft.com/fr-fr/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver16

Once done, set the following in the /etc/odbcinst.ini file by adjusting the SQL Server ODBC driver version:

[msodbcsql18]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.0.so.1.1
UsageCount=1

See ORACLE_DSN to learn how to use the driver to connect to your MSSQL database.