To configure the ODBC connection for the Microsoft ODBC driver 17 for SQL Server, you need to update the following files:

odbcinst.ini:

  [ODBC Driver 17 for SQL Server]
  Description=Microsoft ODBC Driver 17 for SQL Server
  Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.5.1
  UsageCount=1

odbc.ini:

  [MSSQL12.0_HOST_NAME_DATABASE_NAME]
  Driver = ODBC Driver 17 for SQL Server
  Server = host_name
  Database = database_name

Check the connection to SQL Server 12 by host_name using ODBC connect MSSQL12.0_HOST_NAME_DATABASE_NAME:

  isql -v MSSQL12.0_HOST_NAME_DATABASE_NAME user_name pwd

If you have any questions or encounter any difficulties, please contact us at support@ispirer.com