Oracle 8.0.5 and ADO 2.0 Question

Hi,
Nobody posted any replies to the last post I made, so I thought I'd ask one more time. Guess not many people use ADO to access Oracle 8, huh?...

I have a question regarding Oracle Version 8.0.5 and ADO 2.0. I am new to ADO and was under the impression that I was supposed to use the MSDAORA Provider when connecting to Oracle via ADO, however, when I try to open the connection it gives me an error message "Driver not capable". So I tried MSDASQL provider and it will let me connect, update, addnew recordsets and everything, which is great, but it won't let me create disconnected recordsets now. I get the error message "Operation is not allowed if the object is closed" if I try to do anything to my Client side recordset after disconnecting it (closing the connection). I am also concerned that the MSDASQL Provider will give me more trouble as I go on developing. Is there a version compatibility issue with MSDAORA Provider? Do I need to download a patch or something? or do I need to work with Oracle 7.3?

Thanks in Advance!
Beth Received on Fri Apr 23 1999 - 13:43:04 CDT