data access iis7/vista

Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting "An error occurred on the server when processing the
URL".

I think the problem is in the file permission. Under XP Pro/IIS6 is used to
have to set the .mdb file security via windows explorer to give
IUSR_machinename full permissions on this file for anonymous web access.

Cant seem to do this with Vista explorer - says object cannot be found.

Also, getting conflicting statements from IIS Help - it tells me firstly
that

a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
This account is created when you install IIS 7.0.

and then

b. Similarly, a new Windows built-in account named IUSRS replaces the
local IUSR_MachineName anonymous account from IIS 6.0.

Anyway, whatever syntax I use, I cant seem to add anonymous web user
permission to daters.mdb via the security tab in Windown Explorer.

Any help greatly appreciated - getting very frustrated

Thanks

Hugh

Re: data access iis7/vista

Hi,

Before assuming that this is a permissions issue, can you post the HTTP
status and substatus codes?

Also, have you installed the custom errors module? If you do so, and access
the site as http://localhost or http://127.0.0.1 you should get a very
detailed error message indicating what the problem is. Can you post that
erro rmessage please?

Cheers
Ken

"hugh welford" wrote in message
news:uoPk1hM6HHA.1188@TK2MSFTNGP04.phx.gbl...
> Hi
>
> Have just installed IIS7 on Vista and am trying to access a .mdb file
> through ASP. Getting "An error occurred on the server when processing the
> URL".
>
> I think the problem is in the file permission. Under XP Pro/IIS6 is used
> to
> have to set the .mdb file security via windows explorer to give
> IUSR_machinename full permissions on this file for anonymous web access.
>
> Cant seem to do this with Vista explorer - says object cannot be found.
>
> Also, getting conflicting statements from IIS Help - it tells me firstly
> that
>
> a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
> This account is created when you install IIS 7.0.
>
> and then
>
> b. Similarly, a new Windows built-in account named IUSRS replaces the
> local IUSR_MachineName anonymous account from IIS 6.0.
>
> Anyway, whatever syntax I use, I cant seem to add anonymous web user
> permission to daters.mdb via the security tab in Windown Explorer.
>
> Any help greatly appreciated - getting very frustrated
>
> Thanks
>
> Hugh
>

Re: data access iis7/vista

a) configure asp to send detail error msgs, and disable IE friendly error
msgs.
%windir%\system32\inetsrv\appcmd.exe set config -section:asp
/scriptErrorSentToBrowser:true

b) look at this kb
Error message when you request an ASP page that connects to an Access
database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
http://support.microsoft.com/Default.aspx?id=926939

--
Regards,
Bernard Cheah
http://www.iis.net/
http://msmvps.com/blogs/bernard/


"hugh welford" wrote in message
news:uoPk1hM6HHA.1188@TK2MSFTNGP04.phx.gbl...
> Hi
>
> Have just installed IIS7 on Vista and am trying to access a .mdb file
> through ASP. Getting "An error occurred on the server when processing the
> URL".
>
> I think the problem is in the file permission. Under XP Pro/IIS6 is used
> to
> have to set the .mdb file security via windows explorer to give
> IUSR_machinename full permissions on this file for anonymous web access.
>
> Cant seem to do this with Vista explorer - says object cannot be found.
>
> Also, getting conflicting statements from IIS Help - it tells me firstly
> that
>
> a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
> This account is created when you install IIS 7.0.
>
> and then
>
> b. Similarly, a new Windows built-in account named IUSRS replaces the
> local IUSR_MachineName anonymous account from IIS 6.0.
>
> Anyway, whatever syntax I use, I cant seem to add anonymous web user
> permission to daters.mdb via the security tab in Windown Explorer.
>
> Any help greatly appreciated - getting very frustrated
>
> Thanks
>
> Hugh
>

Re: data access iis7/vista

Thanks for the feedback, guys

Input from various people has resulted in me assuring that the following
have full
control permissions for IUSR and IIS_IUSRS accounts - this may or may not be
over the top, but it has solved the problem

a. The .mdb file to be accessed
b. C:\Windows\Temp
c. C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp

Hope this is useful

Regards

Hugh



"hugh welford" wrote in message
news:uoPk1hM6HHA.1188@TK2MSFTNGP04.phx.gbl...
> Hi
>
> Have just installed IIS7 on Vista and am trying to access a .mdb file
> through ASP. Getting "An error occurred on the server when processing the
> URL".
>
> I think the problem is in the file permission. Under XP Pro/IIS6 is used
> to
> have to set the .mdb file security via windows explorer to give
> IUSR_machinename full permissions on this file for anonymous web access.
>
> Cant seem to do this with Vista explorer - says object cannot be found.
>
> Also, getting conflicting statements from IIS Help - it tells me firstly
> that
>
> a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
> This account is created when you install IIS 7.0.
>
> and then
>
> b. Similarly, a new Windows built-in account named IUSRS replaces the
> local IUSR_MachineName anonymous account from IIS 6.0.
>
> Anyway, whatever syntax I use, I cant seem to add anonymous web user
> permission to daters.mdb via the security tab in Windown Explorer.
>
> Any help greatly appreciated - getting very frustrated
>
> Thanks
>
> Hugh
>