MS Access provider missing

[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

 

[William \(Bill\) Vaughn]

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.
__________________________________

 

[thomas wenning]

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

You mean jet 8.0? Install mdac 2.8!!!!

OLE.
I'm using framework 2.0 with access 2000

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

 

[Paul Clement]

¤ 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)

 

[SteveK]

Thanks all, it was the syntax error ;(