Home » SQL & PL/SQL » SQL & PL/SQL » Retrieving views in ASP
Retrieving views in ASP [message #10743] Fri, 13 February 2004 11:03 Go to next message
aileen
Messages: 8
Registered: January 2004
Junior Member
Is it possible to retrieve the data from an Oracle view into an ADO recordset on an ASP?

Have the code working fine when using a table, but when I substituted the table for a view the following error was thrown:

Microsoft OLE DB Provider for ODBC Drivers (0x80020009)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I think the problem may lie in using a view???

 
Re: Retrieving views in ASP [message #11274 is a reply to message #10743] Wed, 17 March 2004 05:02 Go to previous message
Mariam
Messages: 2
Registered: August 2001
Junior Member
I have the same problem. but i also have this problem on retrieving from table
so if you can send me the code to retrieve from oracle tables I will appriciate that
Previous Topic: Problem with 'NOT IN'
Next Topic: Urgent---exception handling problem
Goto Forum:
  


Current Time: Fri Apr 19 05:20:00 CDT 2024