Last post Sep 12, 2008 04:32 AM by kemical
Sep 11, 2008 05:20 AM|MaksudModan|LINK
i am using ms-acess database in my asp.net with c# application. It is working fine locally. but after upload published website to url. it has some problem
My application fetch data from database. but when i do insert or update opration to database its give error.
is there any setting i have to do? or can any body give me solution
Thanks in Advaace
Sep 11, 2008 09:42 AM|kemical|LINK
You need to grant write access to the folder that the database in for the user account that IIS runs under when executing the asp code, typically IUSR_MACHINE.
Sep 11, 2008 04:25 PM|Mikesdotnetting|LINK
You need to apply MODIFY permissions on the folder that contains the database file to the correct user. For Windows Server 2003, this is the NETWORK SERVICE account. On XP Pro, it's ASPNET.
This was pretty easy to answer because the problem is a common one:
http://www.mikesdotnetting.com/Article.aspx?ArticleID=74. For future reference, it's always a good idea to post the actual error message you get.
Sep 11, 2008 04:30 PM|Mikesdotnetting|LINK
the user account that IIS runs under when executing the asp code, typically IUSR_MACHINE
That's the correct user for classic ASP, but not for ASP.NET (unless you are using impersonation).
Sep 12, 2008 04:32 AM|kemical|LINK
Woops... Guess I was going through a "classic" relapse [:|]