- Download Microsoft Data Access Components (mdac) 2.8 For Windows Xp
- Microsoft Data Access Components Mdac 2.8 Sp1
- Microsoft Data Access
Microsoft Data Access Components (MDAC) 2.8 Software Development Kit The MDAC 2.8 SDK is for developers who are building applications using ADO, OLE DB, and ODBC. It contains updated documentation, headers, libs and typelibs for x86, IA64 and AMD64 platforms, as well as updated sample applications and developer tool. Download XlsToSql Free Trial » MDAC explained (ADO version 2.5, 2.6, 2.7, and 2.8) Microsoft Data Access Components (MDAC) include three technologies for accessing data: ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC). Download and install the Component Checker tool.To confirm your MDAC version, use Microsoft's Component Checker tool, as follows: Run the Component Checker, as instructed on the page linked above, and then check the MDAC version. Note: On Windows Server 2003, MDAC version 2.8 should be installed. For more information, see the MSDN Blog article.
I am having problems when connecting to my SQL server 2008 and think it might be a problem related to MDAC. Is there a download to re-install these?mdb
Remember, MDAC is client software that should not be installed on the server.
Your problem is more likely a protocol or firewall error.Can you give more info please?gbngbn
I agree with gbn; check that you are allowing remote connections on the SQL server, it is disabled by default in some versions; use the Configuration Manager on the server to verify TCP/IP is enabled.
The MDAC is an ODBC driver for client access. But you need it for ASP and ASP.Net database connections.
The MDAC 2.8 SP1 does not install in Windows 2008 Server because it was designed for a older version of Windows.
You might be able to enable access, I think that under IIS 6.0 32 bit drivers and programs are disabled by default. See this Microsoft Forum post for more info:http://forums.iis.net/p/1146917/1882658.aspx#1882658
You need to check your Application Pool settings for IIS and see if the enable 32 bit applications is set to true, if it is set to false change it to true and then restart the IIS service. The MDAC and ODBC drivers are 32 bit and you need to enable 32 bit app access in the application pools as in the 64 bit Windows 20008 Server RC1/RC2 versions it is set to false by default.
See if that solves your problem.
I tried even installing MS-Office, but still no database access. Not until I enabled 32 bit access in the app pool.
Use the MDAC checker first, it will tell you if there's a problem with your MDAC:Booji Boy
Download Microsoft Data Access Components (mdac) 2.8 For Windows XpBooji Boy
I ran into this recently, they renamed MDAC to WDAC in Server 2008 which really throws your search strings off. To fix WDAC you need to run system file checker 'sfc /scannow'
This release manifest applies to the Internet release of Microsoft Data Access Components (MDAC) 2.8 Service Pack 1, referred to as MDAC 2.8 SP1 (2.81.1117.6).
For more information about how to install, remove, upgrade, and downgrade MDAC releases, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms810805.aspxFor more information about downloading MDAC releases, visit the following MSDN Web site:
Release version number
MDAC 2.8 SP1 (2.81.1117.6), May 2005
This release provides the same version of MDAC that was released with Microsoft Windows XP Service Pack 2 (SP2) and Microsoft SQL Server 2000 Service Pack 4 (SP4).
Release ship vehicle
Data Access Technologies
MDAC 2.8 SP1 (2.81.1117.6) is available in the following languages:
Chinese (Traditional and Simplified)
Minimum supported configuration
Microsoft Windows 98 with the Y2K Update 2 and Internet Explorer 5.01
Microsoft Windows 98 Second Edition and Internet Explorer 5.01
Microsoft Windows Millennium Edition and Internet Explorer 5.01
Microsoft Windows NT 4 Service Pack 5 (SP5) or a later version, and Internet Explorer 5.01
Microsoft Windows 2000
Note The MDAC 2.8 SP1 stand-alone release is not supported on the Microsoft Windows XP operating system or on the Microsoft Windows Server 2003 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.
MDAC 2.8 SP1 (2.81.1117.6) is not a new feature release.
Frequently asked questions about MDAC 2.8
Q1: Where can I find specific Microsoft Knowledge Base articles for MDAC 2.8?
A1: You can search the Microsoft Knowledge base by using the Advanced Search option and by choosing the product Data Access Components 2.8.
Note Only search the Knowledge Base for specific technical information, not for bug-related issues. For bug-related issues, many articles describe either fixed bugs or known bugs in this version of the product.
Where can I find more information about MDAC setup? This includes dependencies, supported operating systems, and rollback.
A2: For more information about these topics, see the following MSDN Web site:
http://msdn2.microsoft.com/en-us/library/ms810805.aspxQ3: My application must have Microsoft Jet. However, Jet is no longer included with MDAC. Where can I find Jet?
A3: The Microsoft Jet components were removed from MDAC 2.6 and all subsequent releases.
My application must have the Microsoft Visual FoxPro ODBC Driver. However, the driver is no longer included with MDAC. Where can I find the Visual FoxPro ODBC Driver?
A4: The Visual FoxPro ODBC Driver is included with Microsoft Visual FoxPro, Microsoft Windows 2000, Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Office 2000, and MDAC 2.5. The driver is not included with MDAC 2.8.
Known issues for MDAC 2.8 SP1 (2.81.1117.6)
Security enhancements: Additional security enhancements were made in MDAC 2.8 SP1. Some of these enhancements cause small behavior changes. We recommend that you fully test this version of MDAC with your application in a test environment before you apply MDAC to a production environment.
Supportability enhancements: Several supportability enhancements were made in MDAC 2.8 SP1. These enhancements include improvements to Watson behavior and to tracing functionality. For more information about changes in MDAC 2.8 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
884930 List of bugs that are fixed in MDAC 2.8 Service Pack 1
SQL Server 7.0 Clustered Servers: Do not install MDAC 2.6 or later versions on any Microsoft SQL Server 7.0 clustered nodes. If you install MDAC 2.6 or later versions on any node in the cluster, directly or through the installation of another program, it may cause a failure of the SQL Server Agent or other SQL Server services. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
820754 MDAC 2.6 or later should not be installed on SQL Server 7.0 clusters
Windows rollback: On a computer that is running Windows 98 or Windows Millennium Edition, if you try to roll back your MDAC installation to an earlier version, the computer is left in a mixed state where your files are not all from the same version of MDAC. This behavior occurs because of a problem with the setup technology that is included with Windows 98 and Windows Millennium Edition. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
311720 MDAC rollback may fail on Windows 95, Windows 98, and Windows Millennium Edition
MDAC 2.8 SP1 MDAC_TYP.exe file and Windows Server 2003 or Windows XP: If you try to run the MDAC 2.8 SP1 MDAC_TYP.exe file on a computer that is running Windows XP or Windows Server 2003, installation fails, and you receive an error message. 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.
Significant fixes for MDAC 2.8 SP1 (2.81.1117.6)
Microsoft Data Access Components Mdac 2.8 Sp1
For more information about the significant fixes that are included in the MDAC 2.8 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
884930 List of bugs that are fixed in MDAC 2.8 Service Pack 1
Microsoft Data Access
File list for MDAC 2.8 (2.81.1117.6)
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
892854 Release strategy for Microsoft Data Access Components
820761 A list of significant fixes that are included in MDAC 2.8