MDAC/ Dot.net clash

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

flashgorman - 20 May 2004 09:28 GMT

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

Signature

http://www.flashgorman.com

Reply to this Message

Cowboy - 20 May 2004 16:09 GMT

First step would be running the following tool:
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-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/details.aspx?familyid=2deddec4-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/details.aspx?FamilyID=6c050fe3-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.

Signature

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

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

> Hi,
>
[quoted text clipped - 15 lines]
>
> Cheers

Reply to this Message

flashgorman - 21 May 2004 09:53 GMT

> First step would be running the following tool:

http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-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/details.aspx?familyid=2deddec4-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/details.aspx?FamilyID=6c050fe3-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?

Reply to this Message

MDAC/ Dot.net clash

Free Magazines