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

Search for additional results

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