I try to connect to an access database using the OleDbDataAdapter wizard.
I choose the Microsoft jet 4.0 provider and
when i test my connection i receive the following message:
"Test connection failed because of an error in initializing provider.Class not registered"
How can i solve this?
Could i use another provider and who?

Hi,

Following is a typical ADO.Net connection string to a MS Access database file (It works):
[Note: Change H:\MSAccess\db1.mdb to your own mdb file]

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=H:\MSAccess\db1.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

I tried and I received the following message when I clicked F5:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

Additional information: No error information available: REGDB_E_CLASSNOTREG(0x80040154).

It seems that this OLE driver dlls are not properly registered.
Have you tried re-installing .Net ?

First of all,
Thank you for your time and advises.
Second,
I tried re-installing but nothing change.I don't Know if this OLE driver dlls are part of .net or part of windows(xp).Also i have installed office 2003. Could it be a compatibility problem?