Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2002
    Posts
    2

    Unanswered: ADODB.Connection error '800a0e7a'

    keep gettin this error msg - its sposed to list
    items from an access database.

    Im using windows 98
    ms PWS
    and have mdac 2.7 installed

    im not sure what else i can do to fix it
    thanks for any help


    ADODB.Connection error '800a0e7a'

    Provider cannot be found. It may not be properly installed.

    /db.asp, line 34



    Dim dbc
    Dim strConn
    Dim strpath

    'this procedure is called wherever a connection is needed. Returns 'dbc' as active connection
    sub openConn()
    'use appropriate connection string
    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("admin/scart.mdb")

    Set dbc = Server.CreateObject("ADODB.Connection")
    dbc.open strConn (**line 34**)
    end sub

    sub closeConn()
    if isobject(dbc) then
    if dbc.State = adStateOpen then
    dbc.Close
    end if
    set dbc = nothing
    end if
    end sub
    %>

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Try to register the driver you are using - I believe you are using the "MS Jet 4 ole db provider" -- if so, find the msjetoledb40.dll and register it manually. If this fails, reinstall mdac.

  3. #3
    Join Date
    Nov 2002
    Posts
    2
    i didnt even have that dll but tracked down MS Jet containing that dll and installed it - now works

    thanks

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Happy to help.

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    FYI - If you continue having problems, reinstall mdac - this may be a result of an incomplete installation and might cause you more problems in the future.

  6. #6
    Join Date
    Dec 2002
    Posts
    3

    Question

    I have the same problem as what rnealejr had. I tried to reinstall msjetoledb40.dll but i dont know how. I never installed any MDAC software. It comes with .net server or sql server i presume. Could anyone please tell me what i should do in order to solve this problem?

    ADODB.Connection error '800a0e7a'

    Provider cannot be found. It may not be properly installed.

    /connect.inc, line 3

    Thanks.

  7. #7
    Join Date
    Dec 2002
    Posts
    3
    oh..i forgot to mention that i do find msjetoledb40.dll in my computer. PLease let me know what are the steps to solve my problem. Thanks.

  8. #8
    Join Date
    Feb 2002
    Location
    North Wales, UK
    Posts
    114
    To install MDAC you can either use WindowsUpdate.com or download the file manually here http://www.microsoft.com/data/download.htm
    J^ - web | email
    newsASP Developer

  9. #9
    Join Date
    Dec 2002
    Posts
    3
    Got it! thank you so much!

Posting Permissions

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