Re: Oracle 8.0.5 and ADO 2.0 Question

Beth

Oracle 8 does not work with MTS in it's default installation. You need to consult the Oracle documentation on configuring it for XA compliance whish is required even to make a connection within an MTS object. If not you get the 'Driver not capable...' error.

You have to make system view available in Oracle and modify the configuration of the Oracle ODBC driver. We use Microsoft ODBC Driver for Oracle 2.573.2927.

Hope this helps

Terry

Beth Massi wrote in message <7fqel5$8rt_at_sjx-ixn9.ix.netcom.com>...
>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 Wed May 26 1999 - 08:47:43 CDT