Results 1 to 3 of 3

Thread: error msg

  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unanswered: error msg

    I have been learning asp since last friday (for 8 days now) because i was tasked with the creation of this site. I'm a reasonably fast learner and i picked it up pretty quick. The only problem is that i haven't had the experience w/ asp to decode error messages. I've been looking on google at forums just like this for the past 3 days trying to implement whatever helped the guy before me and nothing has worked. With that being said...

    Here's the error message:

    Microsoft OLE DB Provider for ODBC Drivers
    error '80004005'

    [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

    bla bla bla.

    and here's the code for opening the db:

    Code:
    dim con
    dim rs
    set con=Server.CreateObject("ADODB.Connection")
    
    con.Open "DSN=updatedb"
    set rs=Server.CreateObject("ADODB.Recordset")
    Can anyone see anything wrong w/ my code? Other than the fact that you think dsn-less connection is better (i understand dsn connection more so i used that). Thanks for you time.

  2. #2
    Join Date
    Oct 2007
    Posts
    2
    PS: i've already set the system dsn and user dsn to the correct databases and updated the .mdb drivers.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Have you verified that the DSN itself is functioning correctly? What happens if you try to use that DSN to wire up a different ODBC-aware platform, such as Excel or Access?
    oh yeah... documentation... I have heard of that.

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

Posting Permissions

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