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