Asked by:
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 errorThanks
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