MDAC version problem

Question

0.00/5 (No votes)

See more:

Dear All,

I have a problem. I downloaded the .net project(web) from clients server in order to modify. it is vs2003 asp.net by the way.

The software is supposed to extract some data from excel file.

however when the code comes the following exception is thrown.

The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC) version 2.6 or later. Version 02.10.3711.9 was found currently installed.

I checked via component checker the mdac 2.8 SP1 on XP SP3. So the problem is not the version. Somehow .net does not see it while running.

i tried to install the MDAC 2.8 sp1 anyway, however it says it is detected that the service pack of the sytem is newer than this, there is no need to install this pack.

Posted 1-Jul-10 11:21am

Ersan Ercek

Updated 1-Jul-10 11:31am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ersan Ercek · Answer 1 · 2010-07-01T23:12:00

I solved the problem however rather than removing the question, I prefer to explain how, in order to help you aferwards.

Despite the lots of incompatibilty posts in several forums,

It is necessary to reinstall MDAC. However XP.SP3 does not make it easier for you. You need to :

Start-Run %windir%\inf thereby you go to the folder where you can find
mdac.inf. Right Click Install...

You need to refer C:\WINDOWS\ServicePackFiles\i386 folder...(if missinf XP SP3 cd) There there may be several files missing files. While loading you are notified so, find these files from other computers where XP-SP3 runs and copy the foler servicepackfiles.

That is it.

Hope this helps