si_the_geek
Jul 17th, 2005, 06:39 PM
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 (http://msdn.microsoft.com/en-us/data/aa937730.aspx)
Office 2007 (Access/Excel/...) driver - Data Connectivity Components (http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en) [ACE]
SQL Server driver - Native Client (for 2008 and earlier) (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c#SNAC) (for 2005 and earlier (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075#SNAC))
(recommended for SQL Server 2005 and later, as it has extra features. For SQL Server 2000 you can just use MDAC)
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 (http://msdn.microsoft.com/en-us/data/aa937730.aspx)
Office 2007 (Access/Excel/...) driver - Data Connectivity Components (http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en) [ACE]
SQL Server driver - Native Client (for 2008 and earlier) (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c#SNAC) (for 2005 and earlier (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075#SNAC))
(recommended for SQL Server 2005 and later, as it has extra features. For SQL Server 2000 you can just use MDAC)