Hi, I am trying to use an OleDbDataAdapter and DataBuilder with a recordset to update and insert rows into a table in Oracle. All the documentation and examples I can find are all for SQL Server(using the SqlDataAdapter variant). I can get my code to work on Access (with the OleDBData* classes), but when I go to Oracle it all breaks down.
What I get is that I can use DataAdapter.Fill() to hidrate the record set, but if I make any changes and call DAtaAdapter.Update(), it throws the following exception: System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. I have the latest drivers from Oracle (I hope). Any ideas would be greatly appreciated. Noam You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
