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
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.
SAP Knowledge Base Article - Preview