locked
connect access database RRS feed

  • Question

  • User-182549627 posted

    Hi
    I can't get classic asp page to connect to a access database, my code is:

    driverString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("menuoffline.mdb")
    Set db = Server.CreateObject("ADODB.Connection") 
    db.Open(driverString)

     It always worked on my windows xp, with iis6, now I am using windows vista buide 5600.

    I have on the access database file, given everyone full kontrol, and I have allowed .mdb files in the

    C:\Windows\System32\inetsrv\config\applicationHost.config

    I get the following error:
     Microsoft JET Database Engine error '80004005'
    Unspecified error

     Thanks

     

    Jimmy

     

     

    Thursday, September 28, 2006 2:54 PM

All replies

  • User-848894299 posted

    Hi Jimmy,

    Could you try whether it works or not if you make the request using local administrator (NTLM or Basic Auth) credential? We are investigating a similar repro with the Jet team.

    thanks,

    Ray 

    Monday, October 2, 2006 1:57 AM
  • User-182549627 posted

    Hi Ray

     Fantastic, after having changed to Basic Authentication, it works.

    Than you very much.  I have spent too much time trying to solve this, so thank you very much :-)

     

    Best regards Jimmy

    Monday, October 2, 2006 6:10 AM
  • User989702501 posted
    Mm.. what's wrong with Integrated auth?
    Tuesday, October 3, 2006 4:06 AM
  • User-848894299 posted

    You can also turn off the 'loadUserProfile' IIS7 property which will give you the same result as your ASP/Access application in IIS6. Here is an example of the xml that you can change to:

    ....

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

    ...

    Ray

    Tuesday, October 3, 2006 7:39 PM
  • User1788700852 posted

    I read but I didn't understand the topic

     "local administrator (NTLM or Basic Auth) credential"

    ????

     

    Wednesday, October 11, 2006 2:41 PM
  • User-848894299 posted

    Can you try this link http://forums.iis.net/thread/1422841.aspx ?

    Don't worry about the "local administrator ...". That was temporary work around during the investigation of this issue.

    Wednesday, October 11, 2006 2:58 PM