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 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

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
  Symptoms
  Changes
  Cause
  Solution
  References

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