IIS7 - Classic ASP

Re: IIS 7 update MS Access database trouble

xem — Sun, 01 Jun 2008 20:17:56 GMT

I love You.

I'm spanish and I have the error " Microsoft JET Database Engine error '80004005' "...

I try the solution than microsoft gives :

icacls %WINDIR%\ServiceProfiles\NetworkService\AppData\Local\temp /grant Users:(CI)(RX,WD,AD)
icacls %WINDIR%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

But I haven't good results..I was Fool with problem!!!!!..because I'm a Dell with Vista business and my user not is "Users" is your solution with "IUSR"...

I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.I love You.

Thanks!Thanks!Thanks!Thanks!Thanks!Thanks!Thanks!

Xem.From Spain

(Sorry for my english)

Re: IIS 7 update MS Access database trouble

bigdrawsinbmp — Mon, 26 May 2008 16:38:05 GMT

thanks for your sharing your experience,...

i did this ...

icacls %WINDIR%\ServiceProfiles\NetworkService\AppData\Local\temp /grant IUSR:(CI)(RX,WD,AD)
icacls %WINDIR%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

and i solved my trouble.

Re: IIS 7 update MS Access database trouble

alxandr — Thu, 06 Dec 2007 06:50:31 GMT

Yes... It dosn't work... It's just set back to "protected from reading and writing" (don't know the word in english) again...

Re: IIS 7 update MS Access database trouble

steve schofield — Thu, 06 Dec 2007 04:50:15 GMT

I'm not sure the syntax of icacls, have you tried the low tech way of adjusting using Windows Explorer?

Re: IIS 7 update MS Access database trouble

alxandr — Wed, 05 Dec 2007 20:48:11 GMT

I get the error: "0 filer er behandlet, 1 filer ble ikke behandlet" on vista (I know, i know, norwegian... Anyway, it means "0 files has been treated, 1 file was not treated") when trying to run the icacls command. What do I do? I'm runing cmd as administartor and everything... Pleas help.

Re: IIS 7 update MS Access database trouble

qbernard — Wed, 07 Mar 2007 05:48:04 GMT

Changed permission on folder with mdb file to IIS_USR to write option.

>> You are granting the permissions to IIS_USR group and not IUSR ? what's the request user in your case?

Re: IIS 7 update MS Access database trouble

steve schofield — Tue, 06 Mar 2007 21:16:02 GMT

I'm definitely going to bookmark this thread! Two solutions in one thread. Glad you got this working.

Re: IIS 7 update MS Access database trouble

Brian Lee — Tue, 06 Mar 2007 14:37:54 GMT

Got our's working... in reverse I found the following worked.

Command: icacls %WINDIR%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

Changed permission on folder with mdb file to IIS_USR to write option.

We're running Vista Business iis7, we can read, write, update our mdb files.

Thanks again,

Re: IIS 7 update MS Access database trouble

qbernard — Mon, 05 Mar 2007 04:16:47 GMT

what's the actual error msgs now? disable IE friendly error msgs and see if you have more meaningful error msgs other than 500 error.

Re: IIS 7 update MS Access database trouble

Brian Lee — Mon, 05 Mar 2007 03:09:26 GMT

Ok, I've confirmed my C:\Windows\System32\inetsrv\config\applicationHost <applicationPoolDefaults> network services are set to false... the C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp folder has the "CREATOR OWNER" and "IUSR" users. Well, I'am still unable to access my mdb file... did you all did anything else.

I did the following...

%windir%\system32\inetsrv\appcmd set appPool "DefaultAppPool" -processModel.loadUserProfile:false

icacls %WINDIR%\ServiceProfiles\NetworkService\AppData\Local\temp /grant IUSR:(CI)(RX,WD,AD)
icacls %WINDIR%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

Re: IIS 7 update MS Access database trouble

thomad — Wed, 07 Feb 2007 03:10:42 GMT

West,

Try the following:

%windir%\system32\inetsrv\appcmd set appPool "DefaultAppPool" -processModel.loadUserProfile:false

OR assuming your ASP page has anonymous authentication enabled:

icacls %WINDIR%\ServiceProfiles\NetworkService\AppData\Local\temp /grant IUSR:(CI)(RX,WD,AD)
icacls %WINDIR%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

If you use authentication you should use this command:

icacls %WINDIR%\ServiceProfiles\NetworkService\AppData\Local\temp /grant Users:(CI)(RX,WD,AD)
icacls %WINDIR%\serviceprofiles\networkservice\AppData\Local\Temp /grant "CREATOR OWNER":(OI)(CI)(IO)(F)

Hope this helps.

IIS 7 update MS Access database trouble

west1428 — Sat, 03 Feb 2007 02:46:20 GMT

I am now able to view data in an ASP page after changing the permission for Authenticated Users that I found here http://forums.iis.net/thread/1422841.aspx .

Here is the trouble I am having now...

When ever I try to update a database I get the same 500 error I had before when I was just trying to view the data.

Are there some special permissions or securities in Vista and IIS 7 that is stopping me?

Can anyone help?

Below is the script I am using.

' Get
' -------------------------------------------------------------------------------------------------

index=Request.Form("index")
bYear=Request.Form("bYear")
bMonth=Request.Form("bMonth")
bDay=Request.Form("bDay")
eYear=Request.Form("eYear")
eMonth=Request.Form("eMonth")
eDay=Request.Form("eDay")
header=Request.Form("header")
subHeader=Request.Form("subHeader")
content=Request.Form("content")
published=Request.Form("published")

' Check
' -------------------------------------------------------------------------------------------------

header = replace(header,"'","'")
subHeader = replace(subHeader,"'","'")
content = replace(content,"'","'")

bDate=""&bMonth&"/"&bDay&"/"&bYear&""
eDate=""&eMonth&"/"&eDay&"/"&eYear&""

if published<>"yes" then
published="no"
end if

' Create DB connection
'---------------------------------------------------------------------------------------

set myConnection = createobject("ADODB.connection")
myConnection.open "cms_goretti"

' Change
' -------------------------------------------------------------------------------------------------

myCommand="UPDATE admissionsEventsTable SET "
myCommand=myCommand & "bYear = " & bYear & ","
myCommand=myCommand & "bMonth = " & bMonth & ","
myCommand=myCommand & "bDay = " & bDay & ","
myCommand=myCommand & "eYear = " & eYear & ","
myCommand=myCommand & "eMonth = " & eMonth & ","
myCommand=myCommand & "eDay = " & eDay & ","
myCommand=myCommand & "header = '" & header & "',"
myCommand=myCommand & "subHeader = '" & subHeader & "',"
myCommand=myCommand & "content = '" & content & "',"
myCommand=myCommand & "bDate = '" & bDate & "',"
myCommand=myCommand & "eDate = '" & eDate & "'"
myCommand=myCommand & " WHERE index = " & index & ""

set myRecordset = createobject("ADODB.recordset")
myRecordset.open myCommand,myConnection

set myRecordset = nothing

' Close db connection
' -------------------------------------------------------------------------------------------------

myConnection.close

set myConnection = nothing

' Redirect
' -------------------------------------------------------------------------------------------------

Response.Redirect "../interface/index.asp"