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