Microsoft JET Database Engine (0x80004005)
/dtk/common.asp, line 24
when running my ASP – Access Database on my localhost.
My script is following:
Dim dcnDB 'As ADODB.Connection
Set dcnDB = Server.CreateObject("ADODB.Connection")
dcnDB.ConnectionString = _
& "Persist Security Info = False;Data Source=" _
Set OpenDatabase = dcnDB
The error occours when calling dcnDB.Open
Everything has been working. It just stopped, the next day I turned my PC on. Then I checked the security settings on the folder containing the database and ASP pages. Temp folders (%tmp%, %temp). The IUSR_PCName and IWAM_PCName has full access to these folders. When searching the internet for this error – all answers is the permission to access the temp and other folders. But the permissions is OK according to the security tap.
The script is working fine on the webhotel.
I am running Windows XP – servicepack 3 and all other updates.
Nope - not running the entire website from a tempfolder. But when running the website on the localhost/127.0.0.1 the database uses the temp folder for temporaly files. And that why the IIS needs access
A webhotel is a ISP.
So - running the website from my ISP - works great. But running i local - not works great.
<-What does all this have to do with temp folders?->
Actual nothing. But all hits, when searching for this error, describes how to check and add the permission for the IIS to access temp folders. But this is not actual my problem. The IIS has fully access.
But when I run my webside local on my computer - this error occours. But if it not related to above - then - what cause the error?
So - has somebody seen this error related to something else??
I have granted access all temp and local web folders, with iusr_pcname and iwam_pcname with full control.
And I had actually everything running perfect. The data from access database where shown on the webpages. But one day it stopped working. The error code where shown when it tried to open the database. Then start check and check the permissions on the folders. These is intact. So if - permissions is intact - what is then the problem???
Have you setup iis to write to folder where the mdb is.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.