Results 1 to 13 of 13
  1. #1
    Join Date
    Feb 2011
    Posts
    6

    Unanswered: (0x80004005) Unspecified error

    My problem is that I get following error :

    Microsoft JET Database Engine (0x80004005)
    Unspecified error
    /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 = _
    "Provider=Microsoft.Jet.OLEDB.4.0;" _
    & "Persist Security Info = False;Data Source=" _
    & Server.MapPath("Master.mdb")
    dcnDB.Open
    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.

    Why did it stop working????

    Any ideas???

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Now hold on a minute here. You're running your entire website out of a temp folder?

    What is a webhotel?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2011
    Posts
    6

    (=x80004005) Unspecified error

    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.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What does
    Code:
    <%=Server.MapPath("Master.mdb")%>
    return?
    George
    Home | Blog

  5. #5
    Join Date
    Feb 2011
    Posts
    6

    (0x80004005) Unspecified error

    The server.mapPath returns:

    C:\Inetpub\wwwroot\DTK\Master.mdb.

    And that is where the database and asp files are located in local folder.

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What does all this have to do with temp folders?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Feb 2011
    Posts
    6

    (0X80004005) Unspecified error

    Hi Teddy.

    <-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??

  8. #8
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You need to grant file permissions on the files your website wants to use.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  9. #9
    Join Date
    Feb 2011
    Posts
    6

    (0x80004005) Unspecified error

    Hi Teddy.

    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???

  10. #10
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,422
    Provided Answers: 7
    Have you setup iis to write to folder where the mdb is.
    hope this help

    See clear as mud


    StePhan McKillen
    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.

  11. #11
    Join Date
    Feb 2011
    Posts
    6

    0x80004005) Unspecified error

    Hi Myle.
    Yes I have. I had worked before. After turning the PC on next day, it stopped working????

  12. #12
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Then clearly something changed.

    Throw all of your assumptions about how the environment is configured out the window. Re-confirm everything.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  13. #13
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Can you open the database interactively? Perhaps it has become corrupt or locked in some way.

    If everything working one day and not the next you need to have a look at what changed...

    Was there a service pack installed on your machine via SMS or something similar?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •