SAP Knowledge Base Article - Preview

2414788 - "No suitable ODBC driver was found" even though ODBC driver is installed already

Symptom

  • The connection to remote SQL Server from SAP application server on Linux platform cannot be established, although ODBC driver has already been installed in the linux following SAP note 1644499.
  • Work process developer trace shows "No suitable ODBC driver was found". For example:

===
C  ERROR: No suitable ODBC driver was found.
C  The highest known driver is: [ODBC Driver 18 for SQL Server]
B  ***LOG BY2=> sql error 0 performing CON [dbds         1007]
B  ***LOG BY0=> <message text not available> [dbds         1007]
===


Read more...

Environment

  • SAP Systems based on SAP NetWeaver
  • SUSE Linux Enterprise Server 11 (SLES11)
  • SUSE Linux Enterprise Server 12 (SLES12)
  • SUSE Linux Enterprise Server 15 (SLES15)
  • Red Hat Enterprise Linux 6 (RHEL6)
  • Red Hat Enterprise Linux 7 (RHEL7)
  • Microsoft ODBC Driver 11 for SQL Server - Red Hat Linux
  • Microsoft ODBC Driver 11 for SQL Server - SUSE Linux
  • Microsoft ODBC Driver 13 for SQL Server - Windows + Linux
  • Microsoft ODBC Driver 17 for SQL Server - Windows + Linux

Product

SAP NetWeaver all versions

Keywords

sql error 0 performing CON, SQL Server, remote connection, database connection, unixODBC, No suitable ODBC driver was found, <message text not available>, RSA1, ADBC_TEST_CONNECTION, DBACOCKPIT, Database system cannot be reached, ADBC error, Internal error 1 has occurred, Could not open connection, SQL error 0 occurred, The highest known driver is: [ODBC Driver 18 for SQL Server] , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-OP-LNX , Linux , BW-SYS-DB-MSS , BW on Microsoft SQL Server , BC-OP-LNX-SUSE , SUSE Linux , BC-OP-LNX-RH , Red Hat Linux , 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.