Re: Oracle Returns Error When Adding Record To Recordset With ADO

[Quoted] It sounds like you the OLE DB provider you are using (this could be the Oracle OLE DB Provider, the Microsoft OLE DB Provider for Oracle or the Microsoft OLE DB Provider for ODBC or some other 3rd party Provider) doesn't support adding records to recordset objects. You may try to get around this by using a different provider.

However, using the AddNew method is probably the slowest way to insert a record into the table. Your application will likely perform and scale better if you dynamically create a SQL string and use the Command.Execute method, or better yet create a stored procedure and call it with a Command object as well.

Good Luck!

On Sat, 26 Aug 2000 22:41:47 GMT, gteets_at_rr.cinci.com (Greg Teets) wrote:

>I am using an ADO object to select records from a table and it works
>fine.
>
>However, in the next line of the program I try to add a new record as
>follows:
>
>RSSales.AddNew Array("sym", "name"), Array("TEST", "TESTCO")
>
>When I run the program, the select works fine and then I get the
>following error when it tries to add the record to the recordset:
>
>"The operation requested by the application is not supported by the
>provider."
>
>Please explain what I am doing wrong.
>
>Thanks in advance.
Received on Sun Aug 27 2000 - 03:13:13 CEST