Ispirer Website
Ispirer Capabilities: Microsoft SQL Server Migration
Free Trial
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