MDAC/ Dot.net clash

[flashgorman]

Hi,

I am having trouble getting an oledb provider to work in a dot.net page.

I get the message :

"The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data
Access Components(MDAC) version 2.6 or later"

Running the component checker tells me i have MDAC 2.7 refresh installed but
a detailed analysis shows a few dll's and registry keys that refer to 2.5. I
guess I have a 2.5/2.7 hybrid that dot.net doesn't like.

I have tried reinstalling MDAC 2.7 but it still has the same discrepancies.
Should I try and install 2.5 then 2.7?

Please let me know if there is a more appropriate group to ask this on.

Cheers

 

[Cowboy]

First step would be running the following tool:
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&displaylang=en

NOTE: With some of the newer MDACs, the JET engine was a separate download.
If you are trying to contact Access, Excel, et al, you will need to download
this update.

http://www.microsoft.com/downloads/...c4-350e-4cd0-a12a-d7f70a153156&displaylang=en

I would personally aim for MDAC 2.8, which can be downloaded from the
downloads section at http://www.microsoft.com/data/:
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

This will not help with the JET problem, however, so you will still need to
download the latest JET provider.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************

 

[flashgorman]

First step would be running the following tool:
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&displaylang=en

As mentioned previously I've done this and it gives some discrepancies,
namely a few 2.5 dlls and registry keys.

http://www.microsoft.com/downloads/...c4-350e-4cd0-a12a-d7f70a153156&displaylang=en

I would personally aim for MDAC 2.8, which can be downloaded from the
downloads section at http://www.microsoft.com/data/:
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

Tried this, still got the 2.5 remmants.

Do you think its worth trying to install 2.5 and then install a higher
version?