connect access database

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

 

 

Answer 1

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 

Answer 2

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

Answer 3

User989702501 posted
Mm.. what's wrong with Integrated auth?

Answer 4

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

Answer 5

User1788700852 posted

I read but I didn't understand the topic

 "local administrator (NTLM or Basic Auth) credential"

????

 

Answer 6

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.