My Oracle Support Banner

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 MARCH 24, 2022

Applies to:

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


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.


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.