IIS7 - Classic ASP

Re: connect access database

iisray — Wed, 11 Oct 2006 18:58:50 GMT

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.

Re: connect access database

hugolima — Wed, 11 Oct 2006 18:41:08 GMT

I read but I didn't understand the topic

"local administrator (NTLM or Basic Auth) credential"

????

Re: connect access database

iisray — Tue, 03 Oct 2006 23:39:08 GMT

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:

....

...

Ray

Re: connect access database

Bernard — Tue, 03 Oct 2006 08:06:17 GMT

Mm.. what's wrong with Integrated auth?

Re: connect access database

esso — Mon, 02 Oct 2006 10:10:48 GMT

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

Re: connect access database

iisray — Mon, 02 Oct 2006 05:57:44 GMT

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

connect access database

esso — Thu, 28 Sep 2006 18:54:13 GMT

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