IIS7 - Security

Re: ODBC Microsoft Access-driver?

Chris Buchanan — Mon, 18 Aug 2008 18:17:29 GMT

Hi. I've got the same problem with Vista, but there's nothing (hidden or otherwise in my c:\windows>\System32\InetSrv folder. Any other ideas?

Re: ODBC Microsoft Access-driver?

sainath0009 — Mon, 30 Jun 2008 14:26:45 GMT

Hay i had the same problam and resolved by Changing(cannot access the ms Access database file through asp in iis 7 )

thanks for the posting.....:)))

Re: ODBC Microsoft Access-driver?

RobertTengs — Tue, 06 Mar 2007 07:13:58 GMT

I change the following:

In the file ApplicationHost.Config (c:\windows>\System32\InetSrv\config\) the section where:
<applicationPoolDefaults>
<processModel identityType="NetworkService" />
</applicationPoolDefaults>

Change to:

And now all my old ASP works again :)

Re: ODBC Microsoft Access-driver?

Brian Lee — Mon, 05 Mar 2007 16:47:34 GMT

Bill, is the AppPool a user that need's to have access to the mdb file then?

Re: ODBC Microsoft Access-driver?

RobertTengs — Tue, 06 Feb 2007 07:37:39 GMT

It all works fine in IIS 6...

Here is the Connection i´m trying to do:

Sub AbnDB
  Set Conn = Server.CreateObject("ADODB.Connection")
  DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../../db/270906tracms.mdb")
  Conn.Open DSN
End Sub

(and relativ path is enable)

Re: ODBC Microsoft Access-driver?

bills — Mon, 05 Feb 2007 23:25:19 GMT

that is a different error than what I've seen with the profile issue - which is usually resolved with the steps you've taken above.

Have you checked to make sure the AppPool (by default runs as NetworkService) as the appropriate access to the .mdb file?

Could you post some sample code / file that reproduces the issue?

ODBC Microsoft Access-driver?

RobertTengs — Mon, 05 Feb 2007 14:05:53 GMT

I have installed Vista and running IIS7 but cant make it to run with "ODBC Microsoft Access-driver"

I have tried "RUN" on theese commands

icacls %windir%\serviceprofiles\networkservice\AppData\Local\Temp /grant Users:(CI)(S,WD,AD,X)

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

%windir%\system32\inetsrv\appcmd set config -section:applicationPools /[name='DefaultAppPool'].processModel.loadUserProfile:false

But nothing works?

I stille get this error:

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

Please can somebody helt me???