1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Error Type: <br> (0x80004005) <br> Unspecified error <br> /1stsite/AddSheet.asp, line

Discussion in 'Software Development' started by Urgent, Aug 12, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. Urgent

    Urgent Thread Starter

    Joined:
    Aug 11, 2004
    Messages:
    20
    Error Type:
    (0x80004005)
    Unspecified error
    /1stsite/AddSheet.asp, line 29 (n)

    What does this error message mean? :confused:
    Here is line 29:
    objRS.Open "Names", objConn, adOpen, adLock, adCmdTable :confused:

    My values are defined as so:

    Dim adOpen, adLock, adCmdTable, objConn, objRS

    adOpen = 0
    adLock = 1
    adCmdTable = 2

    set objRS = Server.CreateObject("ADODB.Recordset")
    set objConn = server.CreateObject("ADODB.Connection")
    objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;"&_
    "Data Source=C:\MYDB.mdb;"&_
    "Persist Security Info=False"

    The table exists, database defined by objConn also exists, and I have exhaused my own diagnostic skills, can anyone help?
     
  2. Urgent

    Urgent Thread Starter

    Joined:
    Aug 11, 2004
    Messages:
    20
    Ok, Ive realised what it was, some of my labels were defined under the same name as default ASP variables, therefore it was throwing a wobbly at having 2 labels of the same name denoting different functions, I have now renamed everything to have a unique name and it is now co-operating. I hape someone else finds this useful
     
  3. moebius

    moebius

    Joined:
    Oct 7, 2003
    Messages:
    1,741
    i was just about to tell you that 0x80004005 is an error in an adodb or odbc connection object, and usually occurs when the the login ID for IIS, [iuser_NT], doesnt have sufficient privileges to access/modify a database...
     
  4. chrisr

    chrisr

    Joined:
    Aug 25, 2004
    Messages:
    1
    I have had the same problem and have spent many many hours now tring to figure it out. One minute it will work, then the next request it wont, and then it wont for about 3 mins, then it will for 1 request, then not again for about another 3 mins!! How frustrating!?!!?! From what i have researched, i can now get it to work correctly :) . It seems under this driver, if you dont specify a password, you could be liable to receive 'unspecified errors' intermittently!. What i found was the best solution was to just put a dummy password in the connection string (that is if you mdb does niot have a password).

    Example:

    adoCon.Open "DRIVER={Microsoft Access Driver(*.mdb)};DATA SOURCE=mydsn;uid=;pwd=cfgdf;" 'dummy password, just to satisfy a MS BUG!!!

    Maybe this is a bug, maybe it isnt, what i do know is, is that its a real pain in the @$$! :D

    I hope this helps somone who has the same problem so that they dont spend hours on it like i did!

    Have fun and happy programming!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/261098

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice