« Previous Next »

• 09-28-2006, 2:54 PM

  esso 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 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 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 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 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 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 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.