Help With Error

[Adam]

Hey Guys,

I’m trying to create an application that uses an OLEDBConnection.
Every time I try to run my app when I get to the opening of the
connection I get this error.

"The .Net Framework Data Providers require Microsoft Data Access
Components (MDAC). Please install Microsoft Data Access Components
(MDAC) version 2.6 or later."

I have downloaded the latest version of MDAC (2.7) and installed it but
i still get the same error. I downloaded this utility from MS and its
supposed to check which version of MDAC i have installed and it says I
have all of them installed from 2.1 to 2.8 sp1. It doesn’t make any
sense, I have used this type of connection before but i have formatted
since so I’m not sure if there is some little setting that i missed or
if i just got lucky last time. Any input will be greatly appreciated so
thx in advance.

- Adam

P.S.
I am running Windows XP Pro SP2 with Visual Studio .NET 2003 & Visual
Studio .NET 2005 Beta 2. I had the same problem without VS.NET 2005
installed I was kind of hoping that hen I installed VS.NET 2005 it would
fix my problem but it didn’t.

 

[Ignacio Machin \( .NET/ C# MVP \)]

hi

post your connection string


cheers,

 

[Adam]

Hey Ignacio,

I have solved my problem … Well not really; I had read somewhere that
what I needed to do was replace the “msdart.dll” with the one I
extracted from MDAC 2.8 RTF. In order to do this I needed to turn off
SFC (System File Checker), I’m not going to get into that but lets just
call it a disaster. So long story short I had to re-install windows and
after I installed VS.NET I ran the same piece of code and it worked.

Just for the record here is the connection string for those who would
like to see anyways.

@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + StartUpPath + DB +
";Jet OLEDBatabase Password=123456";

StartUpPath and DB are 2 variables I have set up which are pretty
self-explanatory.

Thx for the reply
-Adam