Results 1 to 1 of 1

Thread: Database - Where can I get MDAC, or drivers for Sql Server/Access/Excel?

  1. #1

    Thread Starter
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Bristol, UK

    Database - Where can I get MDAC, or drivers for Sql Server/Access/Excel?

    In order for your program(s) to work with databases, the relevant drivers need to be installed to the computer.

    The basic framework (such as ADO) has historically been included in MDAC (Microsoft Data Access Components), along with some drivers - such as ones for SQL Server 2000 and earlier, and Access .mdb files. Note that MDAC (or the equivalent) is pre-installed on Windows XP/Vista/7.

    However, recent versions of MDAC do not include the components for Office files (Access/Excel/...), so you will need to separately install the Data Connectivity Components (for Office 2007 or earlier files) or Jet (only for earlier Office files).

    The items mentioned above can all be downloaded directly from Microsoft, the locations for downloads (and relevant documentation) are:
    MDAC and Jet

    Office 2007 (Access/Excel/...) driver - Data Connectivity Components [ACE]

    SQL Server driver - Native Client (for 2008 and earlier) (for 2005 and earlier)
    (recommended for SQL Server 2005 and later, as it has extra features. For SQL Server 2000 you can just use MDAC)
    Last edited by si_the_geek; Oct 16th, 2009 at 11:15 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width