Results 1 to 5 of 5

Thread: error message

  1. #1

    Thread Starter
    Lively Member nutstretch's Avatar
    Join Date
    May 2000
    Location
    UK
    Posts
    85

    error message

    I am trying to add data to a database and I am getting this message:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    /booking.asp, line 35

    hese are the lines it refers to:

    et Conn=Server.CreateObject("ADODB.Connection")
    Conn.Open "DRIVER=Microsoft Access Driver (*.mdb) ;DBQ=" & Server.MapPath("HeenaA.mdb")

    Please what have I done wrong
    if at first you don't succeed, drink the rest of the bottle and loop to the same place tomorrow

  2. #2
    PowerPoster
    Join Date
    Nov 2001
    Location
    Trying to reach and stay in the cloud
    Posts
    2,089

    hi

    Just a clarification - is the DB "heenaA.mdb" in the same directory as that of the file????

  3. #3

    Thread Starter
    Lively Member nutstretch's Avatar
    Join Date
    May 2000
    Location
    UK
    Posts
    85
    yes it is
    if at first you don't succeed, drink the rest of the bottle and loop to the same place tomorrow

  4. #4
    PowerPoster
    Join Date
    Nov 2001
    Location
    Trying to reach and stay in the cloud
    Posts
    2,089
    I think perphaps ur ODBBC drivers are corrupted u can download and install them again from microsoft's site.

    Alternatively u can try this :

    Code:
    Conn.Open "Provider=Microsoft.jet.oledb.4.0;Data source=" & Server.MapPath("HeenaA.mdb")
    Hope this helps

  5. #5

    Thread Starter
    Lively Member nutstretch's Avatar
    Join Date
    May 2000
    Location
    UK
    Posts
    85

    resolved

    thanks I'll try that
    if at first you don't succeed, drink the rest of the bottle and loop to the same place tomorrow

Posting Permissions

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



Click Here to Expand Forum to Full Width