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 10.2.0.1.0 to 10.2.0.4Microsoft 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 |