Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Dec 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool 0x80004005 unspecific error

    I have written a few .asp & .htm programs that add, update, and delete from an access database. When I run these programs (through the msn browers) //localhost/voucher/vcgetemp.htm all works well. I currently have moved these programs to one of our servers. Techservices then create a vertual drive to access these programs.

    Problem:
    Whne I start the first program where I enter in some information, I then ACTION to another .asp page which opens the database and checks to see if the information is correct, at which point the user hits Display, this will then call another .asp and that's when I get the error 0x80004005 unspecified error.

    Code:

    Instantiate an ADO Connection object.
    Set objDBConn = Server.CreateObject("ADODB.Connection")

    ' Using the connection string open the connection.
    strConn = "vouchers"
    objDBConn.Open strConn

    The error is pointing to objDBConn.Open strConn. Please note that strConn = "vouchers" was opened in the previous .asp. I do have that close and nothing statements in the previous .asp.

    Sometimes if I wait for a few minutes and press display the next page is displayed with the data, but not always.

    Thanks

  • #2
    Regular Coder
    Join Date
    Aug 2002
    Location
    Texas
    Posts
    287
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The 0x80004005 error is basically the database saying that it does not understand what you are wanting it to do...

    The web programming model is basically a stateless model - if you gave
    "vouchers" a value in page1, page2 (or next requested page) is not going to have any idea what "vouchers" is unless it is a session variable or passed in via querystring or form post. Best to define the value for the connection in the page erroring out - not like a desktop app - each page request made of the server is treated independantly and totally ignorant of any other previous requests,variables,etc. unless you explicitely design some method to pass that info...and connection strings you do not want flying across the network!

    fv

  • #3
    New Coder
    Join Date
    Aug 2004
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I had the same error in a project I'm working on today and it ended up I needed to put a fieldname (with no spaces in the name) in brackets for some reason.

    ...WHERE Positions LIKE 'MCC'... --> ...WHERE [Positions] LIKE 'MCC'...

    Slim chance this may help ya out, but ya never know...

  • #4
    New Coder
    Join Date
    Aug 2003
    Location
    Shawnee Mission, Kansas
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code:
    strCon = "Provider=Microsoft.Jet.OleDb.4.0;DSN=vouchers;"
    John Shepard
    Beyond The Impossible
    -----------------------------
    http://freeasphelp.tech.nu/
    FreeASPHelp by John Shepard
    Sign Up for a free account today!
    100% Free ASPHelp


  •  

    Posting Permissions

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