Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Provider not found with ado.net

Posted on 2011-03-02
6
Medium Priority
?
422 Views
Last Modified: 2012-05-11
I am using this code to connect to an access database in vb2008 and using the adodb reference but it says:

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

I use the Jet provider in other programs on the computer so I know it is there.

Dim cn As New ADODB.Connection
        Dim rs As New ADODB.Recordset
        On Error GoTo ErrTrap

        cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\builtin.mdb;User Id=admin;Password=;")
        rs.Open("select * from TestCase", cn)
        While Not rs.EOF
            MsgBox(rs("EmailAddress").Value)
            rs.MoveNext()
        End While
        rs.Close()
        cn.Close()
0
Comment
Question by:onemorecoke
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 35023764
Did you look in your refernces in that project to see if you really are seeing ADO?
0
 
LVL 3

Author Comment

by:onemorecoke
ID: 35023806
My reference should be ADODB.DLL right?  Seems like everything is good.  I use the same connection string in a VB6 program with no problems.
0
 
LVL 3

Author Comment

by:onemorecoke
ID: 35023834
Could it be a 32bit/64bit issue?  Started up a new project with just defaults so I am assuming it is 32bit.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 27

Expert Comment

by:planocz
ID: 35023943
You should be using something like this
Microsoft ActiveX Data Objects 2.8 Library
Are you using VS 2005 or 2008?
0
 
LVL 3

Accepted Solution

by:
onemorecoke earned 0 total points
ID: 35024614
I figured it out.  I had to force the configuration manager to be in x86 mode, then it started understanding the Jet provider.  I thought it would default to x86 but apparently not.
0
 
LVL 3

Author Closing Comment

by:onemorecoke
ID: 35067799
No one answered it correctly but I kept working on it
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question