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
P.S - Please note I had already posted this in database general section then
realised this would be a better forum so please excuse the double posting

[Paul Clement]

On 21 Feb 2001 15:22:01 -0800, "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
¤ P.S - Please note I had already posted this in database general section then
¤ realised this would be a better forum so please excuse the double posting

Since I can't see how you created your Recordset (what arguments you used) this is rather difficult
to troubleshoot.

However, if you are certain that you are specifying the correct arguments in creating an updateable
Recordset, then make certain that your Oracle Administrator has provided your user ID with update
rights to the table.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

[Joergen Hoeyer]

Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote:
>On 21 Feb 2001 15:22:01 -0800, "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
>¤ P.S - Please note I had already posted this in database general section
then
>¤ realised this would be a better forum so please excuse the double posting
>
>Since I can't see how you created your Recordset (what arguments you used)
this is rather
>difficult
>to troubleshoot.
>
>However, if you are certain that you are specifying the correct arguments
in creating
>an updateable
>Recordset, then make certain that your Oracle Administrator has provided
your user ID
>with update
>rights to the table.
>
>
>Paul ~~~ pclement@ameritech.net
>Microsoft MVP (Visual Basic)

[Joergen Hoeyer]

Things like that wont work unless you have Primary key on at least one column...........Try
that