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
Solved

What is MDAC and do I need to install it?

Posted on 2007-04-10
3
750 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Preface Having the need * to contact many different companies with different infrastructures * do remote maintenance in their network required us to implement a more flexible routing solution. As RAS, PPTP, L2TP and VPN Client connections are no…
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

828 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