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
    27,664
    Thanks
    80
    Thanked 4,641 Times in 4,603 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.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • 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 11:41 PM.

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,664
    Thanks
    80
    Thanked 4,641 Times in 4,603 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
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • 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 07:11 PM.

  • #6
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,664
    Thanks
    80
    Thanked 4,641 Times in 4,603 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.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

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