Hi,

Can anyone think of a reason why I would be getting a "Operation must use an updateable query" error when trying to update Northwind.mdb using 'adapter.Update(customerDataset)'. I used the OleDbCommandBuilder.

The the exact same command works perfectly using the SQLClient namespace against the SQL Server version of the Northwind database. I used the SQLClientCommandBuilder.

All I did was change the SQLClient to OLEDB and the path to the database. Hmmmmm.....

Thanks,

Bob

Your ASPNET account has not write permission on Northwind.mdb

...but the Soon is eclipsed by the Moon

But...

Northwind is unsecured:

   "Provider=Microsoft.Jet.OLEDB.4.0;" & _
   "Data Source=C:\Inetpub\wwwroot\OleDbWebSite\Northwind.m db;" & _
   "User ID=Admin;" & _
   "Password="

The connection string is in Global.asax

Is there somewhere else I should be looking? In the IIS virtual directory maybe? Kinda' new to web databases...

Thanks for the reply,

Bob

I'm working with the project from the Wrox Book "Beginning Visual Basic .NET Databases". Chapter 11 is called "ASP.NET". The download project works fine in SQL Server. I'm just trying to get it to run off the Northwind.mdb database. I barely had to change the code at all. I just changed "SQL" to "OleDb" in about 4 places and put a copy of the Northwind.mdb in www\inetpub\OleDbWebSite\Northwind.mdb............ ....Im running everything locally...thought that would do it...

Put this:
in order to find user account, and then grant write permission on Northwind.mdb to this account.
If yoour ASPX page run under IIS anonymous account, then u can disable anonymous access on IIS settings or grant mentioned permission to this account.

...but the Soon is eclipsed by the Moon

Hi there,

The database may be unsecured, but the ASP.NET account needs write permissions to the database and the folder it resides in on the NTFS level.

So, make sure that the right security permissions for this account are set under Windows security.

HtH

Imar


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

Thanks guys,

I got a writable dataset by disabling anonymous access, enabling Windows authentication, and adding <identity impersonate="true"/> to the Web.config file. Guess I'm impersonating my own administrator log on.

I noticed the aspnet_wp account under User Accounts. Is that what you are referring to as the ASPNET account? Maybe I should just assign administrator priviledges to that account, huh?

Oh, I stole this from another Wrox book, but its an easy VB.NET way to view the user account:

Imports System.Security.Principal
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
      System.EventArgs) Handles MyBase.Load
      Response.Write(WindowsIdentity.GetCurrent().Name)
End Sub

Bob,
By default aspx page is processed under IUSR_machine_name account if IIS anonymous access is enabled, or LOCAL SYSTEM account (ASPNET - you saw under accounts) if it's disabled.
If the impersonation is enabled then the process willbe executed under appropriate Windows logon account.
You can, however, configure Web application to execute under specified account by adding this line in Web.config file:
<identity impersonate="true" userName="BobsComp\Bob" password="pass" />
You should be aware that this account needs to have RW permissions to the directory "Temporary ASP.NET files".

...but the Soon is eclipsed by the Moon

Thanks Milos,

I think I'm getting it a little. How was the ASPNET (aspnet_wp) user account created, by the .NET Framework install?

Bob

Hi all,

For future reference, the following KB articles are good references for this issue:

316675 - PRB: Cannot Connect to Access Database from ASP.NET
315736 - HOW TO: Secure an ASP.NET Application by Using Windows Security

Thanks again,

Bob