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 6 of 6
  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,267
    Thanks
    83
    Thanked 4,892 Times in 4,853 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,267
    Thanks
    83
    Thanked 4,892 Times in 4,853 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,267
    Thanks
    83
    Thanked 4,892 Times in 4,853 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.


  •  

    Posting Permissions

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