Re: Oracle 8.0.5 and ADO 2.0 Question

Enlighten me. What's a disconnected recordset and why do you want one ? I've successfully used ADO recordsets to pass around to grid controls and such, and I did encounter problems with the Oracle OLE DB provider. It lacks support for bookmarks.
J.D.

Andrew Cameron wrote:

> We are running into a similar problem when attempting to use disconnected
> recordsets with Oracle, if we set up a command object and execute the store
> proc into a command object initiated recordset, we cannot disconnect the
> command, while this is possible with the ADO recordset variable, we cannot
> seem to do it when initiated with a ADO command object.
>
> Any help would be appreciated...
>
> Andrew Cameron
>
> Terry Bland <terrybland_at_capgemini.co.uk> wrote in message
> news:#L17W63p#GA.212_at_cppssbbsa03...
> > 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 Jun 02 1999 - 13:27:06 CDT