• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

What is MDAC and do I need to install it?

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
195ecentralave
Asked:
195ecentralave
1 Solution
 
Pete LongConsultantCommented:
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
 
KitezhCommented:
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
 
zivkoCommented:
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now