« Previous Next »

Thread: connect access database

Last post 10-11-2006 2:58 PM by iisray. 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

  • 09-28-2006, 2:54 PM

    • esso
    • Not Ranked
    • Joined on 09-28-2006, 6:43 PM
    • Posts 2

    connect access database

    Reply Contact

    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

     

     

  • 10-02-2006, 1:57 AM In reply to

    • iisray
    • Top 500 Contributor
    • Joined on 07-08-2006, 12:44 AM
    • Posts 22

    Re: connect access database

    Reply Contact

    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 

  • 10-02-2006, 6:10 AM In reply to

    • esso
    • Not Ranked
    • Joined on 09-28-2006, 6:43 PM
    • Posts 2

    Re: connect access database

    Reply Contact

    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

  • 10-03-2006, 4:06 AM In reply to

    • Bernard
    • Top 50 Contributor
    • Joined on 05-24-2006, 4:30 AM
    • Malaysia
    • Posts 291

    Re: connect access database

    Reply Contact
    Mm.. what's wrong with Integrated auth?
    Cheers,
    Bernard Cheah

  • 10-03-2006, 7:39 PM In reply to

    • iisray
    • Top 500 Contributor
    • Joined on 07-08-2006, 12:44 AM
    • Posts 22

    Re: connect access database

    Reply Contact

    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

  • 10-11-2006, 2:41 PM In reply to

    • hugolima
    • Not Ranked
    • Joined on 10-11-2006, 1:55 PM
    • Posts 4

    Re: connect access database

    Reply Contact

    I read but I didn't understand the topic

     "local administrator (NTLM or Basic Auth) credential"

    ????

     

  • 10-11-2006, 2:58 PM In reply to

    • iisray
    • Top 500 Contributor
    • Joined on 07-08-2006, 12:44 AM
    • Posts 22

    Re: connect access database

    Reply Contact

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