Executing a Simple Query With the 64-bit Oracle Provider for OLE DB Returns Only 1 row of Data (Doc ID 393797.1)

Last updated on SEPTEMBER 16, 2010

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.1.0 to 10.2.0.4 - Release: to 10.2
Microsoft Windows x64 (64-bit)
Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)

Symptoms

Executing a simple ASP page in 64-bit mode on Windows 2003 AMD using the Oracle Provider for OLE DB driver and AdUseServer returns a recordset of only one row of data when the query should return results greater than 1 row. The number of rows returned is exactly equal to the Recordset.CacheSize. The default for Recordset.CacheSize is 1.

Changes

This behavior was observed after migrating the ASP application to the x64 Platform. This does not reproduce on 32-bit Windows.

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