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 ONE Support launchpad (Login required).

Search for additional results

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