Home » Categories » CHARTrunner » CR Data Source

GN: MDAC Information

Revision Date: 2010-11-29

Both CHARTrunner and SQCpack use Microsoft Data Access Components (MDAC) in order to access database data. 

Microsoft includes MDAC as part of the operating system in Windows ME and higher. Versions of Windows prior to Windows ME (e.g. 95, 98, and NT) may have a version of MDAC that was installed in conjunction with another software application.

CHARTrunner will work with MDAC 2.1 or higher. In some cases, such as using Parameter Queries with SQL Server, MDAC 2.6 or higher is recommended.

SQCpack will work with MDAC 2.5 or higher.

When installing MDAC you should take care to install the version that is localized for your country or language.

It is recommended that you get your MDAC distribution from Microsoft. The various MDAC versions are available from Microsoft at
http://msdn2.microsoft.com/en-us/data/aa937730.aspx.

In general it is not possible to uninstall MDAC once it has been installed.

How to determine your version of MDAC:

At PQ we have found that getting the version of the msado15.dll file in the following location tends to give a quick indication of what version of MDAC is installed. To determine the file's version, right-click on it in Windows Explorer and select Properties > Version:

C:Program FilesCommon FilesSystemADOmsado15.dll

Alternatively, you can download the MDAC Component Checker utility to do a more thorough analysis of which MDAC components are found on your computer.

Summary of the MDAC versions:

IMPORTANT NOTE: The following versions of the Microsoft Data Access Components (MDAC) are not supported on SQL Server 7.0 or 6.5 clustered installations. Please do NOT install any of these releases of MDAC on such servers; doing so will break your cluster.

MDAC 2.5 RTM (2.50.4403.12) - The first release of 2.5. The same version of MDAC that comes with Windows ME and 2000. Installs on Windows 95/98, and NT 4.0.

MDAC 2.5 SP1 (2.51.5303.5) - 2.5 Service Pack 1. The same version of MDAC that comes with Windows 2000 Service Pack 1. Installs on Windows 95/98, and NT 4.0.

MDAC 2.5 SP2 (2.52.6019.2) - 2.5 Service Pack 2. The same version of MDAC that comes with Windows 2000 Service Pack 2. Installs on Windows 95/98, and NT 4.0. This is the version of MDAC that is included with current versions of SQCpack and CHARTrunner.

MDAC 2.5 SP3 (2.53.6300.0) - 2.5 Service Pack 3. The same version of MDAC that comes with Windows 2000 Service Pack 3. Installs on Windows 95/98, and NT 4.0.

Starting with MDAC 2.6 the Microsoft Jet database engine is no longer included in the MDAC distribution.  However, both SQCpack and CHARTrunner require that the Jet 4.0 database engine be installed.  Click here for information on how to download the latest version of the Jet 4.0 database engine.

MDAC 2.6 RTM (2.60.6526.3) - The first release of 2.6. The same version of MDAC that comes with Microsoft SQL Server 2000. Installs on Windows 95/98, ME, NT 4.0 (SP5 or greater) and Windows 2000.

MDAC 2.6 SP1 (2.61.7326.6) - 2.6 Service Pack 1. The same version of MDAC that comes with Microsoft SQL Server 2000 Service Pack 1. Installs on Windows 95/98, ME, NT 4.0 (SP5 or greater) and Windows 2000.

MDAC 2.6 SP2 (2.62.7400.0) - 2.6 Service Pack 2. The same version of MDAC that comes with Microsoft SQL Server 2000 Service Pack 2. Installs on Windows 95/98, ME, NT 4.0 (SP5 or greater), Windows 2000 and Windows XP.

MDAC 2.7 RTM (2.70.7713.2) - The first release of 2.7. The same version of MDAC that comes with Windows XP. Installs on Windows 98, ME, NT 4.0 (SP5 or greater), and Windows 2000.

MDAC 2.7 SP1 (2.71.9030.9) - 2.7 Service Pack 1. The same version of MDAC that comes with Windows XP Service Pack 1. Installs on Windows 98, ME, NT 4.0 (SP5 or greater), and Windows 2000.

MDAC 2.7 SP2 (2.71.9040.2) - 2.7 Service Pack 1a. This is substantially the same version of MDAC that comes with Windows XP Service Pack 1, except with updated versions of these files (dbnetlib.dll, msdart.dll, odbcbcp.dll, oledb32.dll, sqloledb.dll, sqlsrv32.dll, and sqlunirl.dll). Installs on Windows 98, ME, NT 4.0 (SP5 or greater), and Windows 2000.

MDAC 2.8 RTM (2.80.1022.3) - The first release of 2.8. The same version of MDAC that comes with Windows Server 2003. Installs on Windows 98, ME, NT 4.0 (SP5 or greater), Windows 2000 and Windows XP.

MDAC 2.8 SP1 (2.81.1117.6) - 2.8 Service Pack 1. The same version of MDAC that comes with Windows XP SP2, SP3 and SQL Server 2000 SP4. Installs on Windows 98 with the Y2K Update 2 and Internet Explorer 5.01 or higher, Windows 98 Second Edition and Internet Explorer 5.01 or higher, Microsoft Windows Millennium Edition and Internet Explorer 5.01 or higher, Microsoft Windows NT 4 Service Pack 5 (SP5) or a later version and Internet Explorer 5.01 or higher, or Microsoft Windows 2000. The MDAC 2.8 SP1 stand-alone release is not supported on Microsoft Windows XP, Microsoft Windows Server 2003 and higher versions of the operating system. To update the MDAC version that is installed together with Windows XP or with Windows Server 2003, you must use operating system service packs or Windows Update. NOTE: If you find that you need to reinstall MDAC 2.8 SP1 on Windows XP SP2 or SP3, PQ Systems has found that the following non-Microsoft-supported method seems to work.

-------------------------------------------------------------------------------
   How to repair a copy of MDAC 2.8 SP1 on Windows XP with SP2 installed.
-------------------------------------------------------------------------------

Right-click on C:WindowsInfmdac.inf and choose "Install".

When prompted for the XP SP2 media, point to the i386 folder in one of these places:

   1. The i386 folder on the XP SP2 CDROM. If you are unlucky enough to have a CDROM
      that has XPSP2.EXE in the root of the CDROM, and no i386 folder, then you will
      have to create an i386 folder using a command like this,

         XPSP2.EXE /X:C:XpSp2

      Then point to C:XpSp2i386.

   2. The i386 folder on a slipstreamed XP SP2 installation CDROM.

When prompted for the XP installation media, point to the i386 folder in one of these places:

   1. C:WindowsServicepackFilesi386 (it may not like this location, if not, go to the next one)

   2. The i386 folder on (or from) your XP installation CDROM.

This reinstalls and repairs MDAC 2.8 on XP SP2.
-------------------------------------------------------------------------------
   How to repair a copy of MDAC 2.8 SP1 on Windows XP with SP3 installed.
-------------------------------------------------------------------------------

Right-click on C:WindowsInfmdac.inf and choose "Install".

When prompted for the XP SP3 media, point to the i386 folder in one of these places:

   1. The i386 folder on the XP SP3 CDROM. If you are unlucky enough to have a CDROM
      that has XPSP3.EXE in the root of the CDROM, and no i386 folder, then you will
      have to create an i386 folder using a command like this,

         XPSP3.EXE /X:C:XpSp3

      Then point to C:XpSp3i386.

   2. The i386 folder on a slipstreamed XP SP3 installation CDROM.

When prompted for the XP installation media, point to the i386 folder in one of these places:

   1. C:WindowsServicepackFilesi386 (it may not like this location, if not, go to the next one)

   2. The i386 folder on (or from) your XP installation CDROM.

This reinstalls and repairs MDAC 2.8 on XP SP3.
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: Using a Password Protected Microsoft Access Database
Viewed 2443 times since Fri, Nov 9, 2007
Query to fetch the Last N rows of data from a table or view
Viewed 4451 times since Thu, May 28, 2009
CR: Simultaneous Use of CHARTrunner and Excel with a Workbook
Viewed 2693 times since Fri, Nov 9, 2007
CR: Charting from a Paradox password protected database
Viewed 1756 times since Fri, Nov 9, 2007
CR: Tips for Using Microsoft Access as a Data Source
Viewed 1684 times since Fri, Nov 9, 2007
CR: FoxPro and MDAC Information
Viewed 1919 times since Fri, Nov 9, 2007
CR: Oracle Data Source
Viewed 9937 times since Fri, Nov 9, 2007
CR: Charting from IndustrialSQL Server
Viewed 2500 times since Fri, Nov 9, 2007
CR: Charting from a FoxPro Data Source
Viewed 2062 times since Fri, Nov 9, 2007
CR: Using Oracle Stored Procedures
Viewed 5076 times since Fri, Nov 9, 2007