Chapter 9

Rachel P · June 17th, 2005, 08:39 AM

I'm having some trouble getting this example to work. The only edit I've made to the code is to change the connectionString to that appropriate for a database running on my local machine, the rest of the example having been downloaded directly from the sample online code. The error I'm getting is that the call to

Code:

dataAdapter.Update(data, "Employees")

, which appears on Line 92 in the original sample code, produces the error

Code:

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

The query in question, I take it, is the

Code:

SELECT EmployeeID, FirstName, LastName FROM Employees;

one used to instantiate the dataAdapter?

I've checked this query physically within Northwind.mdb, and it produces an editable result using Access's own query tool. I've tried removing all relationships with other tables in Northwind to see if that fixed the problem, but had no luck with that.

Do any of you have any ideas on what's producing the error?

Thanks, Rach.

Rachel P · June 18th, 2005, 04:59 AM

I've been having a further look at this problem, and it seems to be an issue that's specific to Visual Studio and/or IIS. The code runs fine on Web Matrix's own web server.

Imar · June 18th, 2005, 05:59 AM

This sounds like a permissions issue to me.

Apparently, the Web Matrix web server runs under a different user account than IIS.

Check out this FAQ to find out how to fix this:

http://imar.spaanjaars.com/QuickDocId.aspx?QUICKDOC=263

HtH,

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

Rachel P · June 18th, 2005, 06:25 AM

Thank you, Imar; that's exactly what the problem was. I really appreciate you taking the time to help.

Rach. :)

Imar · June 18th, 2005, 11:40 AM

You're welcome. Glad it's working.

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