SAP Knowledge Base Article - Preview

2917411 - Unable to connect to MS SQL Server from Linux - SAP SQL Anywhere

Symptom

Unable to connect to Microsoft SQL Server from Linux:

  • Mobilink
    Error message: Unable to load 'ODBC Driver 17 for SQL Server' errno=2
    E. <date>. <Main> [-10002] Consolidated database server or ODBC error: ODBC: [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1' : file not found (ODBC State = 01000, Native error code = 0) shows Microsoft SQL Server 17 ODBC 64bit Linux driver load fails. Mobilink cannot connect to a database. Mobilink cannot process synchronization messages.

  • CIS/Remote Server:
    Error: Connection failed.
    Unable to connect to server '<server>': [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 '<server>': [Sybase][ODBC Driver Manager] Unable to load driver /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1
    SQLCODE: -656
    SQLSTATE: HY000


Read more...

Environment

  • SAP SQL Anywhere 
  • Linux
  • Microsoft SQL Server
  • Mobilink
  • CIS/OMNI (Remote Servers/proxy tables)

Product

SAP SQL Anywhere 17.0

Keywords

OMNI, CIS, Mobilink, mlsrv17, mlsrv16, SUSE, Red Hat, RedHat, Ubuntu, Debian, CentOS, ODBC, connection failed , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.