Using VS.NET professional, I can connect to an Oracle database and view the contents of the tables. I need to be able to update the tables in Oracle from VB but I get an error every time I try using a recordset. The error message is:- "Current recordset does not support updating. This may be a limitation of the provider or of the selected locktype."

I have tried using the MSDAOra provider and the OLEDB provider but with no success. The table I am trying to update does have a primary key and I do not think it is linked to any other tables.

Anybody got any tips or ideas?

:(

Derek

hi

go to the link below

http://www.connectionstrings.com/

i hope it will help

What is the code you are using to open the recordset?