« Previous Next »

Thread: ODBC Microsoft Access-driver?

Last post 08-18-2008 2:17 PM by Chris Buchanan. 6 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (7 items)

Sort Posts:

Shortcuts

Search | Active Posts | Unanswered Posts | View all users

  • 02-05-2007, 9:05 AM

    ODBC Microsoft Access-driver?

    Reply Contact

    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???

  • 02-05-2007, 6:25 PM In reply to

    • bills
    • Top 25 Contributor
    • Joined on 02-03-2006, 5:33 PM
    • Redmond, WA
    • Posts 433

    Re: ODBC Microsoft Access-driver?

    Reply Contact

    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?

    ~~~~~~~~~~~~~~~~~~~~~~~~
    Bill Staples
    Product Unit Manager, IIS
    blog: http://blogs.iis.net/bills

  • 02-06-2007, 2:37 AM In reply to

    Re: ODBC Microsoft Access-driver?

    Reply Contact

    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)

  • 03-05-2007, 11:47 AM In reply to

    • Brian Lee
    • Not Ranked
    • Joined on 03-05-2007, 2:35 AM
    • Omaha, NE
    • Posts 5

    Re: ODBC Microsoft Access-driver?

    Reply Contact
    Bill, is the AppPool a user that need's to have access to the mdb file then?
    “Accuracy is Timely”
    Brian Lee
    Developer

  • 03-06-2007, 2:13 AM In reply to

    Re: ODBC Microsoft Access-driver?

    Reply Contact
    I change the following:

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

    Change to:

    <applicationPoolDefaults>
      <processModel identityType="NetworkService" loadUserProfile="false" />
    </applicationPoolDefaults>

     And now all my old ASP works again :)

  • 06-30-2008, 10:26 AM In reply to

    Re: ODBC Microsoft Access-driver?

    Reply Contact

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

    <applicationPoolDefaults>
      <processModel identityType="NetworkService" />
    </applicationPoolDefaults>

    to 

    <applicationPoolDefaults>
      <processModel identityType="NetworkService" loadUserProfile="false" />
    </applicationPoolDefaults>

     

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

  • 08-18-2008, 2:17 PM In reply to

    Re: ODBC Microsoft Access-driver?

    Reply Contact

    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?
Page 1 of 1 (7 items)
Microsoft Communities