SAP Knowledge Base Article - Preview

2577205 - Error database connection DES

Symptom

  • Error connecting from Linux to SQL Server:

ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3055]
(0) [IM004] [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
1 times error (0,0) or (-1,0) in sequence
Connection 0 failed using Driver=ODBC Driver 13 for SQL Server;Server=091402WB98;AutoTranslate=no;UID=DES_SAPMonitor;PWD=xxxxxxxx***LOG BY2=> sql error -1 performing CON [dbds         971]
***LOG BY0=> Driver's SQLAllocHandle on SQL_HANDLE_HENV failed [dbds         971]


Trace for DES connection shows :

  • ...
    57671 12:33:19 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe31f484000
    57671 12:33:19 read(3, "[ODBC Driver 11 for SQL Server]\n"..., 4096) = 203
    57671 12:33:19 read(3, "", 4096)        = 0
    57671 12:33:19 close(3)                 = 0
    57671 12:33:19 munmap(0x7fe31f484000, 4096) = 0
    57671 12:33:19 open("/home/mhqadm/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory)
    57671 12:33:19 futex(0x7fe31d2ed24c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
    57671 12:33:19 futex(0x7fe31d2ed258, FUTEX_WAKE_PRIVATE, 2147483647) = 0
    57671 12:33:19 open("/usr/lib64/gconv/UTF-16.so", O_RDONLY|O_CLOEXEC) = 3
    57671 12:33:19 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\320\6\0\0\0\0\0\0"..., 832) = 832
    57671 12:33:19 fstat(3, {st_mode=S_IFREG|0755, st_size=16712, ...}
    ...


Read more...

Environment

  • SQL Server all supported versions

Product

SAP Solution Manager 7.2

Keywords

KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , 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.