ODBC Hangs While Transferring Table Data From MS Access To Oracle (Doc ID 1069933.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version: 10.2.0.4 to 10.2.0.4 - Release: 10.2 to 10.2
Microsoft Windows (32-bit)
Microsoft Access

Symptoms


A Microsoft Access hang occurs while transferring table content from Access to Oracle Database version 10.2.0.4.0 using the Oracle ODBC Driver version 10.2.0.4.0 patch 20 (also tried patch 22 and 25).
This issue does not occur using the earlier Oracle ODBC Driver version 10.2.0.4 (base release - <>).

Hang dump shows the following stack.
Function Source
NTDLL!ZwWaitForSingleObject+b
KERNEL32!WaitForSingleObjectEx+71
KERNEL32!WaitForSingleObject+f
sqora32!SQLTablesW+6d6
sqora32!SQLSetScrollOptions+5fa
sqora32!SQLSetScrollOptions+298
sqora32!SQLSetStmtAttrW+74
odbc32!SetStmtAttr+2d1
odbc32!SQLSetStmtAttrW+30
msdasql!CBindingODBC3::OLEDBAdjustBindings+ed
msdasql!CUpdateODBC::Update+603
...


It works when using 11.1.0.7.20 ODBC driver
or the Microsoft ODBC driver for Oracle

Changes

Applied 10.2.0.4.0 Patch Bundle 20.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms