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 8 of 8
  1. #1
    Regular Coder
    Join Date
    Nov 2007
    Posts
    682
    Thanks
    319
    Thanked 1 Time in 1 Post

    ADODB.Connection error '800a0e7a'

    How do I fix this?

    Code:
    ADODB.Connection error '800a0e7a' 
    
    Provider cannot be found. It may not be properly installed. 
    
    /nightclub_photography/home.asp, line 75
    ASP Code
    PHP Code:
    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open Server.MapPath("data/database/jamsnaps.mdb")
                
    set rs=Server.CreateObject("ADODB.recordset")
    rs.Open "select * from users"conn
                
    for each x in rs.fields
    response
    .write(x.name)
    response.write(" = ")
    response.write(x.value)
    next
    %> 

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    29,543
    Thanks
    89
    Thanked 4,934 Times in 4,895 Posts
    What operating system are you using? And is it 32 bit or 64 bit? JET driver isn't available in some 64-bit systems. You may be hosed.
    Be yourself. No one else is as qualified.

  • Users who have thanked Old Pedant for this post:

    martynball (05-12-2013)

  • #3
    Regular Coder
    Join Date
    Nov 2007
    Posts
    682
    Thanks
    319
    Thanked 1 Time in 1 Post
    Windows 7 64-bit. Is there an alternative to "Jet"? All I need to do is access a database.
    Last edited by martynball; 05-12-2013 at 10:41 PM.

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    29,543
    Thanks
    89
    Thanked 4,934 Times in 4,895 Posts
    Well, best thing to do is stop using Access.

    Use SQL Server Express or, my preference, MySQL.

    However...

    You could try this:
    Code:
    conn.Provider= "Microsoft.ACE.OLEDB.12.0"
    Supposedly, if you have Office with Access installed, that driver should be available.

    Also, supposedly, it is available for download from MS here:
    http://www.microsoft.com/en-us/downl....aspx?id=13255
    Be yourself. No one else is as qualified.

  • Users who have thanked Old Pedant for this post:

    martynball (05-14-2013)

  • #5
    Regular Coder
    Join Date
    Nov 2007
    Posts
    682
    Thanks
    319
    Thanked 1 Time in 1 Post
    Edit: "conn.Provider= "Microsoft.ACE.OLEDB.12.0"" - Works perfect thanks
    Last edited by martynball; 05-14-2013 at 06:11 PM.

  • #6
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    29,543
    Thanks
    89
    Thanked 4,934 Times in 4,895 Posts
    Just for grins, I did download that driver from the URL I noted and ran a simple test against an old ".mdb" file I had lying around. Yep, as you say, it worked great.
    Be yourself. No one else is as qualified.

  • #7
    New to the CF scene
    Join Date
    Aug 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi I have the same error. I am running a local server on windows 7 pro, IIS7 and MS SQL Express 2012. I have restored the database in SQL. I have set the connection string IIS.

    ADODB.Connection error '800a0e7a'

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

    /online.asp, line 60

    Line 60 on my online.asp file is as follows.

    O_CONN.Open C_DSN_NAME
    Set Base = new oBase
    Set oMD5 = new MD5
    Base.Connect(O_CONN)
    Set oFO = oFS.GetFolder(C_DOC_ROOT & "/code/modules/")
    For Each x in oFO.SubFolders
    If instr(x.Name,"installed.") = 1 Then
    sModule = Replace(x.Name,"installed.","")
    str_call = "Set " & sModule & "= New O_" & sModule
    execute(str_call)
    str_class_vars = sModule & ".Connect O_CONN,iID"
    execute(str_class_vars)

    I have enable 32bit in my application pool but still get the error.

    Please can someone point me in the right direction on how to resolve the database connection to my MS SQL database?

  • #8
    New to the CF scene
    Join Date
    Aug 2015
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If you are running a 64-bit OS, there is no 64-bit Jet 4.0 driver. You need to configure your application pool to run 32-bit.


  •  

    Posting Permissions

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