Re: Updates with MSDAORA provider for ADO

From: smushran <smushran_at_nospam.us.oracle.com>
Date: Thu, 13 Jan 2000 19:32:09 GMT
Message-ID: <387e2780.75368375@newshost.us.oracle.com>

To create updatable rowsets with MSDAORA, set cursorlocation to client.
objRst.CursorLocation = adUseClient

You can also checkout Oracle's OLE DB Provider downloadable from http://technet.oracle.com/ which supports updatable rowsets with both cursorlocations (server and client).... adUseServer (default) and adUseClient.

Sunil Mushran

On Thu, 06 Jan 2000 19:12:55 +0100, hmueller <holger.mueller_at_meta-level.de> wrote:

>Hi!
>I try to update my recordset over the provider MSDAORA for ADO (used
>for ORACLE connections).
>When the command is executed, the following exception is thrown:
>'The operation requested by the application is not supported by the
>provider.'
>When I query the 'Supports' method with parameter 'adUpdate' the result
>is FALSE.
>
>When I change my application to use a data source with the 'MSDASQL'
>provider the update works.
>
>Which settings do I need for updating an Recordset with MSDAORA?
>
>Thanks a lot
> Holger Mueller
>
Received on Thu Jan 13 2000 - 13:32:09 CST