OLE DB PROVIDER FOR ORACLE

[Naveen K Thalanki]

The OLE DB Provider for Oracle that i use is 'MSDAORA.1'.

Using this provider I tried to create an updatable recordset but when I attempt
to update the recordset, I get back an error message stating that the object
or provider does not support the requested operation.

I made sure that I created a recordset that based on the server, with its
locktype property set to optmisitic locking.

Is this a problem with the provider or a problem with my code.
Is there a way I could query the OLE DB Provider to find out whether it supports
updatable recordsets.

Or does anyone of you out there work on this version of the OLE DB provider
for updating recordsets.

Thanks in advance for any help you can give
Regds
Naveen

[challis]

Hi

That provider only supports static, and forward only recordsets

challis

"Naveen K Thalanki" <thalanki_naveen@rocketmail.com> wrote:
>
>The OLE DB Provider for Oracle that i use is 'MSDAORA.1'.
>
>Using this provider I tried to create an updatable recordset but when I
attempt
>to update the recordset, I get back an error message stating that the object
>or provider does not support the requested operation.
>
>I made sure that I created a recordset that based on the server, with its
>locktype property set to optmisitic locking.
>
>Is this a problem with the provider or a problem with my code.
>Is there a way I could query the OLE DB Provider to find out whether it
supports
>updatable recordsets.
>
>Or does anyone of you out there work on this version of the OLE DB provider
>for updating recordsets.
>
>Thanks in advance for any help you can give
>Regds
>Naveen