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?