?
Solved

What is MDAC and do I need to install it?

Posted on 2007-04-10
3
Medium Priority
?
762 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

by Nathan Brom/Bromy2004 Introduction There are numerous websites out there for any different type of program you can imagine.  Of those, you'll need to decide which ones are legitimate and aren't trying to steal your money or infect your comput…
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…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
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…

752 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