Ошибка sqlallochandle для драйвера в sql handle dbc

I have message Oracle ODBC : Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
when try to open oracle connection in excel.
I’m working in virtual machine via citrix.
Could you please give tips why it is appear and how avoid problem ?

Jonathan's user avatar

Jonathan

20k6 gold badges63 silver badges70 bronze badges

asked Nov 29, 2012 at 12:38

Hayk Mamikonyan's user avatar

1

The problem appears to be a permission issue during the installation of both Oracle 9i and 10G.

If you navigate Oracle home you will find that the directory has different permissions then the root of the tree. In the case of 10G the path is C:Oracleproduct10.1.0Client_1. Open the properties for the Client_X directory, and you will see that «Authenticated Users» should have Read and Execute, List Folder Contents, and Read. To fix the problem, do the following….
-Select Authenticated Users
-Uncheck Read and Execute
-Press Apply
-Check Read and Execute
-Press Apply

answered Jan 22, 2015 at 16:13

sarathmojo's user avatar

1

One item that can cause this error is not having the ORACLE_HOME bin directory in your Windows OS path.
Open a command prompt and type either PATH or SET to see if the directory is included. Adjust as required.

answered Jan 22, 2015 at 16:29

sarathmojo's user avatar

Do the following to resolve the issue:

  1. Select Administration Tools , Local Security Setting and Local Policy.
  2. Then select «User Rights Assignment»
  3. Double click on «Create Global Objects»
  4. Select Add User or Group.
  5. Make sure Object Types Group Box is checked.
  6. Select Locations and highlight the name of the server you are working on (Not the Domain).
  7. Enter «Remote Desktop Users» or «Everyone» (without the quotes) into the Object Names Box.
  8. Select OK.
  9. Add the same users to the group «Power User».
  10. If this does not work, after step 8 a reboot may be required.

answered Mar 17, 2017 at 8:37

Zaheer Nazir's user avatar

Источник

@v-makouz On using strace i am getting following logs —
execve("/opt/conda/bin/isql", ["isql", "-v", "-k", "DRIVER={ODBC Driver 17 for SQL S"...], 0x7ffd36742538 /* 18 vars */) = 0 brk(NULL)                               = 0x56324e7f4000 readlink("/proc/self/exe", "/opt/conda/bin/isql", 4096) = 19 access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/tls/haswell/x86_64/libodbc.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/tls/haswell/x86_64", 0x7ffeca17ee90) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/tls/haswell/libodbc.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/tls/haswell", 0x7ffeca17ee90) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/tls/x86_64/libodbc.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/tls/x86_64", 0x7ffeca17ee90) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/tls/libodbc.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/tls", 0x7ffeca17ee90) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/haswell/x86_64/libodbc.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/haswell/x86_64", 0x7ffeca17ee90) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/haswell/libodbc.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/haswell", 0x7ffeca17ee90) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/x86_64/libodbc.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/x86_64", 0x7ffeca17ee90) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/libodbc.so.2", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1300p"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0775, st_size=508888, ...}) = 0 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fbe555f0000 mmap(NULL, 2577240, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe5537a000 mprotect(0x7fbe553e4000, 2097152, PROT_NONE) = 0 mmap(0x7fbe555e4000, 32768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6a000) = 0x7fbe555e4000 mmap(0x7fbe555ec000, 13144, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe555ec000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libedit.so.0", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1P240"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0775, st_size=260144, ...}) = 0 mmap(NULL, 244832, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe5533e000 mprotect(0x7fbe55348000, 180224, PROT_NONE) = 0 mmap(0x7fbe55348000, 118784, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa000) = 0x7fbe55348000 mmap(0x7fbe55365000, 57344, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x27000) = 0x7fbe55365000 mmap(0x7fbe55374000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x35000) = 0x7fbe55374000 mmap(0x7fbe55377000, 11360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe55377000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/tls/haswell/x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient/tls/haswell/x86_64", 0x7ffeca17ee50) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/tls/haswell/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient/tls/haswell", 0x7ffeca17ee50) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/tls/x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient/tls/x86_64", 0x7ffeca17ee50) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/tls/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient/tls", 0x7ffeca17ee50) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/haswell/x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient/haswell/x86_64", 0x7ffeca17ee50) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/haswell/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient/haswell", 0x7ffeca17ee50) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/x86_64/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient/x86_64", 0x7ffeca17ee50) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/libpthread.so.0", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/src_libs/oracle/instantclient", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 openat(AT_FDCWD, "/usr/glibc-compat/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=4704, ...}) = 0 mmap(NULL, 4704, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fbe5533c000 close(3)                                = 0 openat(AT_FDCWD, "/usr/glibc-compat/lib/libpthread.so.0", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1000|"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0755, st_size=118168, ...}) = 0 mmap(NULL, 136312, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe5531a000 mmap(0x7fbe55321000, 65536, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7000) = 0x7fbe55321000 mmap(0x7fbe55331000, 20480, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17000) = 0x7fbe55331000 mmap(0x7fbe55336000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1b000) = 0x7fbe55336000 mmap(0x7fbe55338000, 13432, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe55338000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/x86_64/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/x86_64/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/x86_64/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "x86_64/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/libc.so.6", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/usr/glibc-compat/lib/libc.so.6", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF21133>1320m2"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0755, st_size=1839768, ...}) = 0 mmap(NULL, 1852632, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe55155000 mprotect(0x7fbe5517a000, 1662976, PROT_NONE) = 0 mmap(0x7fbe5517a000, 1355776, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x25000) = 0x7fbe5517a000 mmap(0x7fbe552c5000, 303104, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x170000) = 0x7fbe552c5000 mmap(0x7fbe55310000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1ba000) = 0x7fbe55310000 mmap(0x7fbe55316000, 13528, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe55316000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/./tls/haswell/x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/./tls/haswell/x86_64", 0x7ffeca17ee10) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/./tls/haswell/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/./tls/haswell", 0x7ffeca17ee10) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/./tls/x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/./tls/x86_64", 0x7ffeca17ee10) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/./tls/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/./tls", 0x7ffeca17ee10) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/./haswell/x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/./haswell/x86_64", 0x7ffeca17ee10) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/./haswell/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/./haswell", 0x7ffeca17ee10) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/./x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/./x86_64", 0x7ffeca17ee10) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/opt/conda/bin/../lib/./libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) stat("/opt/conda/bin/../lib/.", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "x86_64/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/libdl.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/usr/glibc-compat/lib/libdl.so.2", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>100021"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0755, st_size=14576, ...}) = 0 mmap(NULL, 16656, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe55150000 mmap(0x7fbe55151000, 4096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x7fbe55151000 mmap(0x7fbe55152000, 4096, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7fbe55152000 mmap(0x7fbe55153000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7fbe55153000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/./libtinfow.so.6", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1@1"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0775, st_size=275448, ...}) = 0 mmap(NULL, 256952, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe55111000 mmap(0x7fbe55121000, 102400, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x10000) = 0x7fbe55121000 mmap(0x7fbe5513a000, 69632, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x29000) = 0x7fbe5513a000 mmap(0x7fbe5514b000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x39000) = 0x7fbe5514b000 close(3)                                = 0 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fbe5510f000 mmap(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fbe5510d000 arch_prctl(ARCH_SET_FS, 0x7fbe55110640) = 0 mprotect(0x7fbe55310000, 12288, PROT_READ) = 0 mprotect(0x7fbe5514b000, 16384, PROT_READ) = 0 mprotect(0x7fbe55153000, 4096, PROT_READ) = 0 mprotect(0x7fbe55336000, 4096, PROT_READ) = 0 mprotect(0x7fbe55374000, 8192, PROT_READ) = 0 mprotect(0x7fbe555e4000, 4096, PROT_READ) = 0 mprotect(0x56324d9ed000, 4096, PROT_READ) = 0 mprotect(0x7fbe5561b000, 4096, PROT_READ) = 0 munmap(0x7fbe5533c000, 4704)            = 0 set_tid_address(0x7fbe55110910)         = 22 set_robust_list(0x7fbe55110920, 24)     = 0 rt_sigaction(SIGRTMIN, {sa_handler=0x7fbe55321680, sa_mask=[], sa_flags=SA_RESTORER|SA_SIGINFO, sa_restorer=0x7fbe5532e3d0}, NULL, 8) = 0 rt_sigaction(SIGRT_1, {sa_handler=0x7fbe55321720, sa_mask=[], sa_flags=SA_RESTORER|SA_RESTART|SA_SIGINFO, sa_restorer=0x7fbe5532e3d0}, NULL, 8) = 0 rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0 prlimit64(0, RLIMIT_STACK, NULL, {rlim_cur=8192*1024, rlim_max=RLIM64_INFINITY}) = 0 brk(NULL)                               = 0x56324e7f4000 brk(0x56324e815000)                     = 0x56324e815000 ioctl(0, TCGETS, {B38400 opost isig icanon echo ...}) = 0 rt_sigprocmask(SIG_BLOCK, [WINCH], [], 8) = 0 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0 stat("/root/.terminfo", 0x56324e7f6d00) = -1 ENOENT (No such file or directory) stat("/opt/conda/share/terminfo", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 stat("/etc/termcap", 0x56324e7f6d90)    = -1 ENOENT (No such file or directory) stat("/usr/share/misc/termcap", 0x56324e7f6d90) = -1 ENOENT (No such file or directory) stat("/opt/conda/share/terminfo", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0 access("/opt/conda/share/terminfo/x/xterm", R_OK) = 0 openat(AT_FDCWD, "/opt/conda/share/terminfo/x/xterm", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0664, st_size=3716, ...}) = 0 read(3, "32010&1723513465xterm|xterm terminal"..., 32768) = 3716 read(3, "", 28672)                      = 0 close(3)                                = 0 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0 ioctl(1, TIOCGWINSZ, {ws_row=21, ws_col=155, ws_xpixel=0, ws_ypixel=0}) = 0 ioctl(0, TIOCGWINSZ, {ws_row=21, ws_col=155, ws_xpixel=0, ws_ypixel=0}) = 0 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0 ioctl(0, TCGETS, {B38400 opost isig icanon echo ...}) = 0 rt_sigprocmask(SIG_BLOCK, [HUP INT QUIT TERM CONT TSTP WINCH], [], 8) = 0 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0 ioctl(0, SNDCTL_TMR_STOP or TCSETSW, {B38400 opost isig icanon echo ...}) = 0 openat(AT_FDCWD, "/root/.isql_history", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/usr/glibc-compat/lib/locale/locale-archive", O_RDONLY|O_CLOEXEC) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=142512, ...}) = 0 mmap(NULL, 142512, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fbe550ea000 close(3)                                = 0 openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 brk(0x56324e836000)                     = 0x56324e836000 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) brk(0x56324e834000)                     = 0x56324e834000 brk(0x56324e833000)                     = 0x56324e833000 openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/etc/odbcinst.ini", O_RDONLY) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=163, ...}) = 0 read(3, "[ODBC Driver 17 for SQL Server]n"..., 4096) = 163 read(3, "", 4096)                       = 0 close(3)                                = 0 openat(AT_FDCWD, "/root/.odbcinst.ini", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/usr/glibc-compat/lib/gconv/gconv-modules.cache", O_RDONLY) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/usr/glibc-compat/lib/gconv/gconv-modules", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) futex(0x7fbe55315634, FUTEX_WAKE_PRIVATE, 2147483647) = 0 futex(0x7fbe551540c8, FUTEX_WAKE_PRIVATE, 2147483647) = 0 openat(AT_FDCWD, "/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>10002621"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0755, st_size=2166168, ...}) = 0 mmap(NULL, 2249552, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54ec4000 mprotect(0x7fbe54ede000, 2007040, PROT_NONE) = 0 mmap(0x7fbe54ede000, 1544192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1a000) = 0x7fbe54ede000 mmap(0x7fbe55057000, 458752, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x193000) = 0x7fbe55057000 mmap(0x7fbe550c8000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x203000) = 0x7fbe550c8000 mmap(0x7fbe550d6000, 78672, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe550d6000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libodbcinst.so.2", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1240*"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0775, st_size=118176, ...}) = 0 mmap(NULL, 2204056, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54ca9000 mprotect(0x7fbe54cc0000, 2093056, PROT_NONE) = 0 mmap(0x7fbe54ebf000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x16000) = 0x7fbe54ebf000 mmap(0x7fbe54ec1000, 8600, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe54ec1000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libkrb5.so.3", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1@P2"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0664, st_size=1064656, ...}) = 0 mmap(NULL, 877584, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54bd2000 mprotect(0x7fbe54bf7000, 663552, PROT_NONE) = 0 mmap(0x7fbe54bf7000, 364544, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x25000) = 0x7fbe54bf7000 mmap(0x7fbe54c50000, 294912, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7e000) = 0x7fbe54c50000 mmap(0x7fbe54c99000, 65536, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xc6000) = 0x7fbe54c99000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libgssapi_krb5.so.2", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1@320"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0664, st_size=370600, ...}) = 0 mmap(NULL, 322224, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54b83000 mprotect(0x7fbe54b90000, 258048, PROT_NONE) = 0 mmap(0x7fbe54b90000, 204800, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd000) = 0x7fbe54b90000 mmap(0x7fbe54bc2000, 49152, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3f000) = 0x7fbe54bc2000 mmap(0x7fbe54bcf000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4b000) = 0x7fbe54bcf000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libstdc++.so.6", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF21133>1220215n"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0775, st_size=13172960, ...}) = 0 mmap(NULL, 1523040, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54a0f000 mmap(0x7fbe54ab1000, 520192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa2000) = 0x7fbe54ab1000 mmap(0x7fbe54b30000, 266240, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x121000) = 0x7fbe54b30000 mmap(0x7fbe54b71000, 61440, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x161000) = 0x7fbe54b71000 mmap(0x7fbe54b80000, 11616, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe54b80000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libgcc_s.so.1", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>13302"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0664, st_size=818984, ...}) = 0 mmap(NULL, 78856, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe549fb000 mmap(0x7fbe549fe000, 49152, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3000) = 0x7fbe549fe000 mmap(0x7fbe54a0a000, 12288, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf000) = 0x7fbe54a0a000 mmap(0x7fbe54a0d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x11000) = 0x7fbe54a0d000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/x86_64/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/haswell/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/x86_64/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "tls/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/x86_64/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "haswell/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "x86_64/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/src_libs/oracle/instantclient/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory) openat(AT_FDCWD, "/usr/glibc-compat/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3 fstat(3, {st_mode=S_IFREG|0644, st_size=4704, ...}) = 0 mmap(NULL, 4704, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fbe5533c000 close(3)                                = 0 openat(AT_FDCWD, "/lib/libc.musl-x86_64.so.1", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>19k5"..., 832) = 832 fstat(3, {st_mode=S_IFREG|0755, st_size=592432, ...}) = 0 mmap(NULL, 607032, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54966000 mprotect(0x7fbe5497b000, 503808, PROT_NONE) = 0 mmap(0x7fbe5497b000, 286720, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fbe5497b000 mmap(0x7fbe549c1000, 212992, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x5b000) = 0x7fbe549c1000 mmap(0x7fbe549f6000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x8f000) = 0x7fbe549f6000 mmap(0x7fbe549f8000, 9016, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe549f8000 close(3)                                = 0 openat(AT_FDCWD, "/opt/conda/bin/../lib/./libk5crypto.so.3", O_RDONLY|O_CLOEXEC) = 3 read(3, "177ELF2113>1@«…, 832) = 832
fstat(3, {st_mode=S_IFREG|0664,
st_size=137208, …}) = 0
mmap(NULL, 122896, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54947000
mprotect(0x7fbe5494d000, 86016, PROT_NONE) = 0
mmap(0x7fbe5494d000, 61440, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6000) = 0x7fbe5494d000
mmap(0x7fbe5495c000, 20480, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x7fbe5495c000
mmap(0x7fbe54962000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1a000) = 0x7fbe54962000
mmap(0x7fbe54965000, 16, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe54965000
close(3)                               
= 0
openat(AT_FDCWD, «/opt/conda/bin/../lib/./libcom_err.so.3», O_RDONLY|O_CLOEXEC) = 3
read(3, «177ELF2113>1@ «…, 832) = 832
fstat(3, {st_mode=S_IFREG|0664,
st_size=23144, …}) = 0
mmap(NULL, 20688, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54941000
mmap(0x7fbe54943000, 4096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x7fbe54943000
mmap(0x7fbe54944000, 4096, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3000) = 0x7fbe54944000
mmap(0x7fbe54945000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3000) = 0x7fbe54945000
close(3)                               
= 0
openat(AT_FDCWD, «/opt/conda/bin/../lib/./libkrb5support.so.0», O_RDONLY|O_CLOEXEC) = 3
read(3, «177ELF2113>1@@»…, 832) = 832
fstat(3, {st_mode=S_IFREG|0664,
st_size=62728, …}) = 0
mmap(NULL, 53896, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54933000
mprotect(0x7fbe54937000, 32768, PROT_NONE) = 0
mmap(0x7fbe54937000, 20480, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4000) = 0x7fbe54937000
mmap(0x7fbe5493c000, 8192, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x7fbe5493c000
mmap(0x7fbe5493f000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xb000) = 0x7fbe5493f000
close(3)                               
= 0
openat(AT_FDCWD, «/opt/conda/bin/../lib/./libcrypto.so.1.1», O_RDONLY|O_CLOEXEC) = 3
read(3, «177ELF2113>13007″…, 832) = 832
fstat(3, {st_mode=S_IFREG|0775,
st_size=3459120, …}) = 0
mmap(NULL, 3116936, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe5463a000
mmap(0x7fbe546b5000, 1859584, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7b000) = 0x7fbe546b5000
mmap(0x7fbe5487b000, 557056, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x241000) = 0x7fbe5487b000
mmap(0x7fbe54903000, 184320, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2c8000) = 0x7fbe54903000
mmap(0x7fbe54930000, 12168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe54930000
close(3)                               
= 0
openat(AT_FDCWD, «/opt/conda/bin/../lib/./libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/opt/conda/bin/../lib/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/haswell/x86_64/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/haswell/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/x86_64/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «haswell/x86_64/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «haswell/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «x86_64/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/src_libs/oracle/instantclient/libresolv.so.2», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/usr/glibc-compat/lib/libresolv.so.2», O_RDONLY|O_CLOEXEC) = 3
read(3, «177ELF2113>1260C»…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755,
st_size=84784, …}) = 0
mmap(NULL, 96896, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe54622000
mprotect(0x7fbe54626000, 65536, PROT_NONE) = 0
mmap(0x7fbe54626000, 49152, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x4000) = 0x7fbe54626000
mmap(0x7fbe54632000, 12288, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x10000) = 0x7fbe54632000
mmap(0x7fbe54636000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x7fbe54636000
mmap(0x7fbe54638000, 6784, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fbe54638000
close(3)                                = 0
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls/haswell/x86_64/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls/haswell/x86_64″,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls/haswell/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls/haswell»,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls/x86_64/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls/x86_64″,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/tls»,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/haswell/x86_64/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/haswell/x86_64″,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/haswell/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/haswell»,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/x86_64/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/x86_64″,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib/libm.so.6″,
O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
stat(«/home/nwani/m3/conda-bld/compilers_linux-64_1560109574129/h_env_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold_placehold/lib»,
0x7ffeca177750) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/opt/conda/bin/../lib/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/haswell/x86_64/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/haswell/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/x86_64/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «tls/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «haswell/x86_64/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «haswell/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «x86_64/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/src_libs/oracle/instantclient/libm.so.6», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/usr/glibc-compat/lib/libm.so.6», O_RDONLY|O_CLOEXEC) = 3
read(3, «177ELF21133>1340361″…, 832) = 832
fstat(3, {st_mode=S_IFREG|0755,
st_size=1321304, …}) = 0
mmap(NULL, 1323264, PROT_READ, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fbe544de000
mmap(0x7fbe544ed000, 630784, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf000) = 0x7fbe544ed000
mmap(0x7fbe54587000, 626688, PROT_READ, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa9000) = 0x7fbe54587000
mmap(0x7fbe54620000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x141000) = 0x7fbe54620000
close(3)                               
= 0
mprotect(0x7fbe54620000, 4096, PROT_READ) = 0
mprotect(0x7fbe54636000, 4096, PROT_READ) = 0
mprotect(0x7fbe54903000, 176128, PROT_READ) = 0
mprotect(0x7fbe5493f000, 4096, PROT_READ) = 0
mprotect(0x7fbe54945000, 4096, PROT_READ) = 0
mprotect(0x7fbe54962000, 8192, PROT_READ) = 0
mprotect(0x7fbe549f6000, 4096, PROT_READ) = 0
mprotect(0x7fbe54a0d000, 4096, PROT_READ) = 0
mprotect(0x7fbe54b71000, 45056, PROT_READ) = 0
mprotect(0x7fbe54c99000, 57344, PROT_READ) = 0
mprotect(0x7fbe54bcf000, 8192, PROT_READ) = 0
mprotect(0x7fbe54ebf000, 4096, PROT_READ) = 0
mprotect(0x7fbe550c8000, 32768, PROT_READ) = 0
brk(0x56324e861000)                    
= 0x56324e861000
munmap(0x7fbe5533c000, 4704)           
= 0
openat(AT_FDCWD, «/usr/glibc-compat/share/locale/locale.alias», O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/usr/glibc-compat/share/locale/C.UTF-8/LC_MESSAGES/libc.mo», O_RDONLY) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/usr/glibc-compat/share/locale/C.utf8/LC_MESSAGES/libc.mo», O_RDONLY) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/usr/glibc-compat/share/locale/C/LC_MESSAGES/libc.mo», O_RDONLY) = -1 ENOENT (No such file or directory)
openat(AT_FDCWD, «/etc/odbcinst.ini», O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644,
st_size=163, …}) = 0
read(3, «[ODBC Driver 17 for SQL Server]n»…, 4096) = 163
read(3, «», 4096)                      
= 0
close(3)                               
= 0
openat(AT_FDCWD, «/root/.odbcinst.ini», O_RDONLY) = -1 ENOENT (No such file or directory)
futex(0x7fbe54b80d9c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
futex(0x7fbe54b80da8, FUTEX_WAKE_PRIVATE, 2147483647) = 0
fstat(1, {st_mode=S_IFCHR|0620,
st_rdev=makedev(0x88, 0), …}) = 0
write(1, «[IM004][unixODBC][Driver Manager»…, 83[IM004][unixODBC][Driver Manager]Driver’s
SQLAllocHandle on SQL_HANDLE_HENV failed
) = 83
write(2, «[ISQL]ERROR: Could not SQLDriver»…, 40[ISQL]ERROR: Could not
SQLDriverConnect
) = 40
exit_group(1)                          
= ?
+++ exited with 1 +++`

Please help on what am i missing.

Источник

RRS feed

  • Remove From My Forums

  • Question

  • Hi,

    I am trying to connect to database from MSAccess. I get the following error when I run the code:

    2147467259 failure [[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed]

    I see some comments on web to fix the problem. None worked. Any suggestion?

    Thank you

All replies

  • Hi Soheil,

    Could you please share us more detailed information like how did you connect to SQL Server database from MS Access? Or have you checked the SQL Server error log at %ProgramFiles%Microsoft SQL ServerMSSQL.MSSQLMSSQLLOGERRORLOG, see if there’s
    more detailed error information?

    By the way, generally the Driver’s SQLAllocHandle on SQL_HANDLE_DBC failed error means: (DM) During SQLConnect, the Driver Manager called the driver’s SQLAllocHandle function with a HandleType of SQL_HANDLE_DBC and the driver returned an error.

    For more details, please refer: https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlconnect-function?view=sql-server-2017

    And also, I think you can try to enable
    ODBC Tracing in ODBC Data Source administrator -> Tracing tab and enable policy server tracing to capture database events. This will give us more hints on why the error happen

    Thanks,
    Xi Jin.

    MSDN Community Support
    Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
    MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Edited by

      Friday, June 15, 2018 8:56 AM

Источник

Problem

ODBC connection from Windows Db2 client failed like following

[IM004] [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed.

Diagnosing The Problem

In db2trace output we can see

981         sqleInitApplicationEnvironment data [probe 30]
982         | pdLog exit
983         | sqloxult_app entry
984         | sqloxult_app exit
985         sqleInitApplicationEnvironment exit [rc = 0xFFFFEC73 = -5005]
986         sqloxult_app entry
987         sqloxult_app exit
988         SQLAllocHandle entry
989         | CLI_utlTraceInit entry
990         | | CLI_latRequestStatic entry
991         | | CLI_latRequestStatic data [probe 1]
992         | | CLI_latRequestStatic error [probe 2]
993         | | CLI_latRequestStatic exit [rc = 0xFFFFFFFF = -1]
994         | CLI_utlTraceInit exit
995         SQLAllocHandle data [probe 2]
996         SQLAllocHandle exit [rc = 0xFFFFFFFF = -1]

Resolving The Problem

This is usually because extended security is enabled on Windows, while the user running ODBC test is not in DB2ADMNS group.

Adding the user to DB2ADMNS group should solve this issue.

If extended security is enabled and later disabled by uninstall/reinstall, the error may be still there as Db2 files are not removed completely. Please follow these steps

1) drop instance/database if there is any

2) remove all the files related with Db2 (especially the DB2PATH and DB2INSTPROF defined in «db2set -all»)

3) uninstall Db2

4) clean windows registries
5) reinstall Db2

6) test ODBC again

Document Location

Worldwide

[{«Business Unit»:{«code»:»BU058″,»label»:»IBM Infrastructure w/TPS»},»Product»:{«code»:»SSEPGG»,»label»:»Db2 for Linux, UNIX and Windows»},»ARM Category»:[{«code»:»a8m0z0000001gWCAAY»,»label»:»Connectivity->ODBC»}],»ARM Case Number»:»»,»Platform»:[{«code»:»PF033″,»label»:»Windows»}],»Version»:»All Version(s)»,»Line of Business»:{«code»:»LOB10″,»label»:»Data and AI»}}]

Источник


First published on MSDN on Jan 22, 2014

While connecting to SQL from client application(running on linux server),  using using ‘SQL Native client 11.0 (ODBC) driver for Linux’ we were getting following error message.

Error message

[root@axxxxxazureapi]#  isql -v< DSN> <USERNAME> <PASSWORD>

[IM004][unixODBC][Driver Manager]Driver’s SQLAllocHandle on SQL_HANDLE_HENV failed

[ISQL]ERROR: Could not SQLConnect

In my case the issue is related with wrong installation path of the sqlncli dll. when we were trying to connect to SQL from Linux the application is trying to get the dll from a different path.

The best way to get the root cause is to take ODBC trace while issue is happening. It will give you more details about the failing API.

Before getting the trace check the UnixODBC version with following command:

odbcinst –j from linux command prompt and verified that unixODBC 2.3.0 (exactly that version, not older or newer) is installed.

Output is following:

$ odbcinst -j

unixODBC 2.3.0

DRIVERS…………: /etc/odbcinst.ini

SYSTEM DATA SOURCES: /etc/odbc.ini

FILE DATA SOURCES..: /etc/ODBCDataSources

USER DATA SOURCES..: /home/odbcuser/.odbc.ini

SQLULEN Size…….: 8

SQLLEN Size……..: 8

SQLSETPOSIROW Size.: 8

How to get the ODBC trace:

The ODBC Driver for SQL Server on Linux supports tracing of ODBC API call entry and exit.

To trace your application behavior, first add the following line to the odbcinst.ini file:

Trace=Yes

Then start your application with strace. For example:

strace -t -f -o trace_out.txt executable

In place of executable just use the command that you are using to run your application. In our case it is like following.


strace -t -f -o trace_out.txt isql -v <DSN>< USERNAME> <PASSWORD>

Once you get the error check the trace file. It will give you more information about the connection failure. On that basis you can troubleshoot the issue.

In my case the path of sqlncli.dll is not found because the application is pointing to a different path and the sqlncli.dll was installed to a different location. After moving the file to that location our application was working fine.


Author : Mukesh(MSFT), Suport engineer, Microsoft


Reviewed by : Snehadeep(MSFT), SQL Developer Technical Lead, Microsoft

Источник

Понравилась статья? Поделить с друзьями:
  • Ошибка sql указанный sql server не найден
  • Ошибка sql таблица не найдена schemastorage
  • Ошибка sql таблица не найдена scheduledjobs
  • Ошибка sql таблица не найдена reference
  • Ошибка sql таблица не найдена commonsettings