In Chapter9 Page 306 Updating the database, I get the following Server Error. It suggests that the dataset 'data' has not been updated since it was introduced as an argument of dataAdapter in line 23, has anyone experienced this problem or knows how to pass a revised value into the recordset?

Server Error in '/BookASP_NET' Application.
--------------------------------------------------------------------------------

Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.

Source Error:


Line 82: '============================================
Line 83: ' Update the data store
Line 84: dataAdapter.Update(Data, "Employees")
Line 85:
Line 86: '============================================


Source File: c:\inetpub\wwwroot\BookASP_NET\CH9\UpdateDatabase. aspx Line: 84

Hi there,

The "Operation must use an updateable query" error usually indicates a permission issue. Check out this FAQ to find out how to fix this:

http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263

Although it's targeted at classic ASP, it'll work for .NET as well.

You may need this FAQ to find out the account that IIS is using: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=287

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Want to know how this ended? Look here: http://p2p.wrox.com/topic.asp?TOPIC_ID=15434


Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.