Solved

What is MDAC and do I need to install it?

Posted on 2007-04-10
3
751 Views
Last Modified: 2011-09-20
What is MDAC and do I need to install it? I run w2k3 server, 12 xp pro machines, sql2000, and crystal reports, and hotdocs2006 and use excel.  
0
Comment
Question by:195ecentralave
3 Comments
 
LVL 57

Expert Comment

by:Pete Long
ID: 18881527
Hello 195ecentralave,

Media Access Data Componants http://www.microsoft.com/downloads/details.aspx?DisplayLang=en&FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c

usually needed to communicate with databases - so YES for SQL you will need to get involved with them

Regards,

PeteLong
0
 
LVL 4

Expert Comment

by:Kitezh
ID: 18881533
Here is the explanation of MDAC and seeing that you use SQL and DB software I wuld say yes you do need it. This link will give you more details :

http://support.microsoft.com/kb/842193
0
 
LVL 4

Accepted Solution

by:
zivko earned 500 total points
ID: 18881708
Hi,

MDAC means Microsoft Data Access Component.
It is a suit of components provided by Microsoft to enable various applications to access different Databases type (SQL, Oracle, Csv, Excel, Access, etc).

So It depend if you have an application using this component on your computer/server.
Having SQL Server running doesn't mean you need MDAC to be installed if you don't have any application running that is based on this component.

Regards,
Zivko
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to set permissions to allow a limited-permissions user to start and stop a particular System Service.   It is always best to give users only the permissions that they need to perform their job, so tweaking particular permi…
Have you ever had a hard drive that you can't boot into, but need to change the registry? Here is the solution! This article guides you through accessing and editing a registry of a non-primary drive. To read registry information on a non-prim…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question