Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial

Microsoft ODBC Driver 17 Configuration

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