MS Access provider missing

  • Thread starter Thread starter SteveK
  • Start date Start date
S

SteveK

I have use ADO.NET with SQL Server before, but never with access. Since my
dept. is being very cheap, I need to use Access. I made a quick test
application and when I test the connection, I get this error:

---------------------------
The 'Microsoft.Jet.OLEDB.4.0 Data Source=C:\Moves.mdb' provider is not
registered on the local machine.
---------------------------



My Connection string looks like this:
const string connectionStr = "Provider=Microsoft.Jet.OLEDB.4.0 Data
Source=C:\\Moves.mdb";


I'm not sure how I can add the provider. I installed service pack 8 for
OLE.
I'm using framework 2.0 with access 2000
 
Why not use MSDE? It's free and programs just like SQL Server (because it is
SQL Server).
You have to install JET separately from the MDAC stack.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
SteveK said:
I have use ADO.NET with SQL Server before, but never with access. Since my
dept. is being very cheap, I need to use Access. I made a quick test
application and when I test the connection, I get this error:

---------------------------
The 'Microsoft.Jet.OLEDB.4.0 Data Source=C:\Moves.mdb' provider is not
registered on the local machine.
---------------------------



My Connection string looks like this:
const string connectionStr = "Provider=Microsoft.Jet.OLEDB.4.0 Data
Source=C:\\Moves.mdb";


I'm not sure how I can add the provider. I installed service pack 8 for
Click to expand...

You mean jet 8.0? Install mdac 2.8!!!!
OLE.
I'm using framework 2.0 with access 2000
Click to expand...
Hi Steve,

mdac 2.6 and upper must be installed!
Connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"
look here http://www.connectionstrings.com/ .

Greeting

Thomas
 
¤ I have use ADO.NET with SQL Server before, but never with access. Since my
¤ dept. is being very cheap, I need to use Access. I made a quick test
¤ application and when I test the connection, I get this error:
¤
¤ ---------------------------
¤ The 'Microsoft.Jet.OLEDB.4.0 Data Source=C:\Moves.mdb' provider is not
¤ registered on the local machine.
¤ ---------------------------
¤
¤
¤
¤ My Connection string looks like this:
¤ const string connectionStr = "Provider=Microsoft.Jet.OLEDB.4.0 Data
¤ Source=C:\\Moves.mdb";
¤
¤
¤ I'm not sure how I can add the provider. I installed service pack 8 for
¤ OLE.
¤ I'm using framework 2.0 with access 2000

There is a syntax error in your connection string (missing semi-colon):

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Moves.mdb"


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top