I'm trying to link tables from MS SQL Server(on Windows) to SQL Anywhere(on Linux)
Have installed SQL Server driver: https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#ubuntu17
Have tested connection to SQL Server with sqlcmd.
In SQL Anywhere I have made a Remote Server with this query:
CREATE SERVER "lnkIS" CLASS 'MSSODBC' USING 'host=xxx.xxx.xxx.xxx;port=nnnn;driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1;uid=wis;pwd=xxx;eng=WisData';
But when I test the connection I get:
Connection failed.
Unable to connect to server 'lnkIS': [Sybase][ODBC Driver Manager] Unable to load driver /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1
[Sybase][ODBC Driver][SQL Anywhere]Unable to connect to server 'lnkIS': [Sybase][ODBC Driver Manager] Unable to load driver /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1
SQLCODE: -656
SQLSTATE: HY000
SQL Statement: SELECT FIRST table_name FROM dbo.sp_remote_tables( 'lnkIS', NULL, NULL, NULL, 1 ) ORDER BY 1
I have not found any examples on how to use a driver other than Sybase.
Anyone had any luck with proxytables against SQL Server?
Copyright Notice:Content Author:「Ove Halseth」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/61270559/sql-anywhere-remote-server-connection-to-sql-server