Introduction
Installing MDAC (Microsoft Data Access Components) on Windows 10 is a crucial step for running Visual Basic 6 (VB6) applications. MDAC is a set of libraries that provides data access and connectivity to various databases, including Microsoft Access, SQL Server, and Oracle. In this article, we will guide you through the process of installing MDAC on Windows 10, ensuring a smooth and successful installation.
Prerequisites
Before installing MDAC, make sure you have the following:
- Windows 10: MDAC is not compatible with Windows 10 by default. However, you can install it using a compatibility mode or by installing the MDAC 2.8 package.
- Visual Basic 6 (VB6): You need to have VB6 installed on your system to use MDAC.
- Administrative privileges: You need to have administrative privileges to install MDAC.
Why Install MDAC?
MDAC provides several benefits, including:
- Data access: MDAC allows you to access various databases, including Microsoft Access, SQL Server, and Oracle.
- Data connectivity: MDAC provides connectivity to various data sources, enabling you to retrieve and manipulate data.
- Improved performance: MDAC optimizes data access and connectivity, resulting in improved performance.
Installing MDAC on Windows 10
To install MDAC on Windows 10, follow these steps:
Method 1: Installing MDAC 2.8
- Download MDAC 2.8: Download the MDAC 2.8 package from the Microsoft website.
- Extract the files: Extract the files from the downloaded package to a folder on your system.
- Run the setup: Run the setup file (mdac_typ.exe) to start the installation process.
- Follow the prompts: Follow the prompts to complete the installation process.
Method 2: Installing MDAC using Compatibility Mode
- Download the MDAC installer: Download the MDAC installer from the Microsoft website.
- Run the installer in compatibility mode: Right-click the installer and select «Properties.» Then, click the «Compatibility» tab and select «Run this program in compatibility mode for» and choose «Windows XP (Service Pack 3)» or «Windows 7.»
- Follow the prompts: Follow the prompts to complete the installation process.
Method 3: Installing MDAC using the Windows 10 Store
- Search for MDAC: Search for «MDAC» in the Windows 10 Store.
- Install MDAC: Install MDAC from the Windows 10 Store.
- Follow the prompts: Follow the prompts to complete the installation process.
Troubleshooting
If you encounter any issues during the installation process, try the following:
- Check the system requirements: Ensure that your system meets the minimum requirements for MDAC installation.
- Run the installer as an administrator: Run the installer as an administrator to ensure that you have the necessary privileges.
- Disable any antivirus software: Disable any antivirus software that may be interfering with the installation.
Conclusion
Installing MDAC on Windows 10 is a crucial step for running Visual Basic 6 (VB6) applications. By following the steps outlined in this article, you can successfully install MDAC on your system. Remember to troubleshoot any issues that may arise during the installation process. With MDAC installed, you can enjoy improved data access and connectivity, as well as enhanced performance.
Additional Resources
For more information on MDAC and its installation, refer to the following resources:
- Microsoft MDAC documentation: Visit the Microsoft website for detailed documentation on MDAC.
- VB6 tutorials: Visit the Michael Rigo website for comprehensive VB6 tutorials.
- Windows 10 support: Visit the Microsoft website for Windows 10 support and troubleshooting resources.
MDAC Installation on Windows 10: Frequently Asked Questions
=============================================================
Introduction
Installing MDAC (Microsoft Data Access Components) on Windows 10 can be a complex process, and you may have questions about the installation, compatibility, and troubleshooting. In this article, we will address some of the most frequently asked questions about MDAC installation on Windows 10.
Q: What is MDAC, and why do I need it?
A: MDAC is a set of libraries that provides data access and connectivity to various databases, including Microsoft Access, SQL Server, and Oracle. You need MDAC to run Visual Basic 6 (VB6) applications, which rely on MDAC for data access and connectivity.
Q: Is MDAC compatible with Windows 10?
A: MDAC is not compatible with Windows 10 by default. However, you can install it using a compatibility mode or by installing the MDAC 2.8 package.
Q: How do I install MDAC on Windows 10?
A: There are three methods to install MDAC on Windows 10:
- Method 1: Installing MDAC 2.8: Download the MDAC 2.8 package from the Microsoft website, extract the files, and run the setup file (mdac_typ.exe) to start the installation process.
- Method 2: Installing MDAC using Compatibility Mode: Download the MDAC installer, run it in compatibility mode for Windows XP (Service Pack 3) or Windows 7, and follow the prompts to complete the installation process.
- Method 3: Installing MDAC using the Windows 10 Store: Search for «MDAC» in the Windows 10 Store, install MDAC, and follow the prompts to complete the installation process.
Q: What are the system requirements for MDAC installation?
A: The system requirements for MDAC installation are:
- Windows 10: MDAC is not compatible with Windows 10 by default. However, you can install it using a compatibility mode or by installing the MDAC 2.8 package.
- Administrative privileges: You need to have administrative privileges to install MDAC.
- Free disk space: You need at least 100 MB of free disk space to install MDAC.
Q: How do I troubleshoot MDAC installation issues?
A: If you encounter any issues during the installation process, try the following:
- Check the system requirements: Ensure that your system meets the minimum requirements for MDAC installation.
- Run the installer as an administrator: Run the installer as an administrator to ensure that you have the necessary privileges.
- Disable any antivirus software: Disable any antivirus software that may be interfering with the installation.
Q: Can I uninstall MDAC after installation?
A: Yes, you can uninstall MDAC after installation. To uninstall MDAC, follow these steps:
- Go to the Control Panel: Go to the Control Panel and click on «Programs and Features.»
- Select MDAC: Select MDAC from the list of installed programs.
- Click Uninstall: Click the «Uninstall» button to uninstall MDAC.
: Are there any alternatives to MDAC?
A: Yes, there are alternatives to MDAC, including:
- ODBC (Open Database Connectivity): ODBC is a standard API for accessing databases.
- OLE DB (Object Linking and Embedding Database): OLE DB is a standard API for accessing databases.
- ADO (ActiveX Data Objects): ADO is a set of libraries that provides data access and connectivity to various databases.
Conclusion
Installing MDAC on Windows 10 can be a complex process, and you may have questions about the installation, compatibility, and troubleshooting. In this article, we have addressed some of the most frequently asked questions about MDAC installation on Windows 10. By following the steps outlined in this article, you can successfully install MDAC on your system and enjoy improved data access and connectivity.
Additional Resources
For more information on MDAC and its installation, refer to the following resources:
- Microsoft MDAC documentation: Visit the Microsoft website for detailed documentation on MDAC.
- VB6 tutorials: Visit the Michael Rigo website for comprehensive VB6 tutorials.
- Windows 10 support: Visit the Microsoft website for Windows 10 support and troubleshooting resources.
How do I install MDAC on Windows 10?
You can not install MDAC on Windows 10. However, you probably dont need it. Click Start and type “ODBC” and that will bring up Setup ODBC Data Sources . There are 32 and 64 bit versions, you should probably use the 32 bit version.
What is MDAC driver?
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 tools.
How do I install Microsoft Data Access Components?
Installing MDAC
- Point your browser to the Microsoft Web site.
- Navigate to and select the MDAC type that conforms with the type specified in System Requirements and Supported Platforms.
- After the program has downloaded, locate the file mdac_typ.exe and click it.
- Follow the prompts to complete the MDAC installation.
What version of MDAC is installed?
The most reliable way to determine which version of MDAC is installed is to compare the version number of each MDAC DLL file to a list of the DLL files that are shipped with each MDAC version. The Component Checker can help you to do this.
What is the full form of MDAC?
Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store.
What is Windows DAC?
Microsoft Dynamic Access Control (DAC) is a data governance tool in Windows Server 2012 that lets administrators control access settings. DAC uses centralized policies to let administrators review who has access to individual files. Files can be manually or automatically classified.
Is MDAC obsolete?
Later Microsoft released upgrades to MDAC as web-based redistributable packages. The current version is 2.8 service pack 1, but the product has had many different versions and many of its components have been deprecated and replaced by newer Microsoft technologies. MDAC is now known as Windows DAC in Windows Vista.
How do I know if MDAC is installed?
How do I know what version of Windows DAC I have?
Check the version information stored in the registry
- On the Start menu, click Run.
- In the Open text box, type regedit and then click OK; this starts Registry Editor.
- In the Navigation pane, drill down to the following path:
- In the Details pane, look in the Name column for FullInstallVer and Version .
What is DAC used for in Windows 10?
Domain-based Dynamic Access Control enables administrators to apply access-control permissions and restrictions based on well-defined rules that can include the sensitivity of the resources, the job or role of the user, and the configuration of the device that is used to access these resources.
How is DAC implemented in Windows?
DAC uses enhanced security descriptors introduced in Windows Server 2008 R2 and Windows 7 to allow conditional expressions in user and device claims and resource properties. This allows a file resource, for example, to be limited to members of the sales department who reside in Canada.
What is Microsoft data access components (MDAC)?
Microsoft Data Access Components 2.8 SP1 contains core Data Access components such as the Microsoft SQL Server OLE DB provider and ODBC driver. This redistributable installer for the MDAC 2.8 SP1 release installs the same Data Access components as Microsoft Windows XP SP2.
What is MDAC and do I need to install it?
Microsoft Data Access Components (MDAC) is a component of Windows created by Microsoft which is used for database access. In order to operate, TaskMerlin requires MDAC Version 2.6 or later to be installed on your machine. If you are using Windows 8, Windows 7, Windows Vista or Windows XP (Service Pack 2), MDAC will already be installed.
Does MDAC work on Windows XP SP2 or later?
Since MDAC in Windows XP SP2 or later is newer than the version (MDAC 2.8 SP1) in the last MDAC redistribution program, mdac_typ.exe no longer installs MDAC on Windows XP SP2 and later version. For more information about MDAC history and supportability please visit Data Access Technologies Road Map
How do I update the MDAC version installed with Windows XP?
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.
- Install Mdac 2.7 On Windows 10
- Install Mdac 2.8 Windows 10
- Install Mdac Windows 10 64
Apr 16, 2018 This article describes two different ways to check which version of Microsoft Data Access Components (MDAC) is installed on a system: Use the Component Checker tool. Check the version information that is stored in the registry. Install and Use the Component Checker Tool. Windows® Server 2003 SP1 Platform SDK Web Install The Platform SDK for Microsoft® Windows® Server 2003 SP1 contains the information and tools you need to develop Windows-based applications. You can use this SDK to develop both 32- and 64-bit applications.
From Microsoft:
Microsoft Data Access Components (MDAC) 2.8 contains core Data Access components such as the Microsoft SQL Server OLE DB provider and ODBC driver. This redistributable installer for the MDAC 2.8 release installs the same Data Access components as Microsoft Windows Server 2003.
What do you need to know about free software?
From Microsoft:
Microsoft Data Access Components (MDAC) 2.8 contains core Data Access components such as the Microsoft SQL Server OLE DB provider and ODBC driver. This redistributable installer for the MDAC 2.8 release installs the same Data Access components as Microsoft Windows Server 2003.
There are many problems that can be caused by MDAC installation issues ranging from missing entry points to crashes to mysterious behavior.
1.1.1 Downloading the MDAC Component Checker
The MDAC Component Checker is the main tool for verifying MDAC installation. It can be downloaded from the MDAC Downloads page:
Once downloaded, unzip into a new directory. e.g. c:comcheck.
1.1.2 Running Component Checker
The first time you run the MDAC Component Checker, allow it to determine the version of MDAC on the machine. It will either report a single version of MDAC, a mixture of MDAC versions, or it will be unable to determine the version on the computer. In the latter two cases, work with the customer to determine what version they want and help them install. Obviously, the newer the version, the better.
Once the Component Checker determines a specific MDAC version, run it a second time and select that version explicitly. It will then produce a variance report showing which DLL and registry entries match that version and which do not.
1.1.3 Running Component Checker Remotely
The MDAC Component Checker can be run remotely under certain circumstances and not under others.
Environment Status
Citrix/Terminal Services – user session Will not run
Citrix/Terminal Services – remote administration Will run
Citrix/Terminal Services – main console in install mode Will run
Microsoft Office Live Meeting, PC Anywhere,
or other remote control software Will run, subject to limitations above
1.1.4 Running Component Checker when the Common Files directory is not on C:
Some systems have a profile set up where the Program Files and Common Files directories have been redirected to another drive, such as L:, in order to save disk space on the C: drive. The MDAC Component Checker will not work in this scenario. You can see this by typing SET at the MS/DOS Command Prompt. e.g.
CommonProgramFiles=C:Program FilesCommon Files
ProgramFiles=C:Program Files
According to the Microsoft, while it is okay to redirect the Program Files directory to another drive, it is not okay to redirect the Common Files. You can modify the following Registry entry via REGEDIT:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersion!CommonFilesDir
Change this back to c:program filescommon files and re-run the MDAC Component Checker. You do not have to restart the computer.
1.1.5 What Mismatches are Okay
The MDAC Component Checker’s variance report will include a list of expected DLL versions and actual DLL versions found on the system. Some mismatches are okay and others are not.
In general, a mismatch is okay if the major and minor version numbers match and the build number is newer than the expected value. This indicates the system has a patch. The MDAC Component Checker is not aware of patched DLLs and will list them as a mismatch.
For example, MSDASQL.DLL in MDAC 2.8 RTM has a version of 2.80.1022.0. One patched version is 2.80.1054.0. Once you have identified a DLL as being patched, you need to verify whether all other DLLs in the patch have been applied also. You’re the DLL name and version number into the internal Knowledge Base. This will bring up and article about the hot fix. For this example, the following article contains the description of the affected files.
823109 FIX: An access violation may occur when a program calls the UpdateBatch method of an ADO Recordset object by using the OLE DB Provider for ODBC in Data Access Components
The MSINTERNAL section shows only one DLL is affected by this patch. If more than one DLL was affected, you need to make sure that all DLLs listed show up as being patched in the Component Checker’s variance report.
A second case where DLL mismatches are okay is with the Windows XP MDAC 2.81 check. This check includes some DLLs that do not ship with MDAC, such as MSXML3 and some Microsoft Jet DLLs. Mismatches in these DLLs are okay.
1.1.6 When Mismatches are NOT Okay
In any other case than listed in the previous section, mismatches are not okay. i.e. older DLLs and DLLs where the major or minor version numbers do not match or where patches have not been consistently applied.
The MDAC Component Checker is not totally exhaustive. Occasionally other DLLs that MDAC may depend on could be causing an issue. The MPS Reports for MDAC will gather a list of all DLLs in SYSTEM32 and in the MDAC directories so we can see other DLL versions.
Download the MPS Reports from:
818742 Overview of the Microsoft Configuration Capture Utility (MPS_REPORTS)
The data obtained would be used in advanced DLL-Hell analysis, such as identifying duplicate MDAC DLLs.
1.3 Process Explorer or FILEMON
Atari ballance game free download. 1.3.1 Downloading Process Explorer and PROCESS MONITOR
These are two tools that can be downloaded from http://www.microsoft.com/technet/sysinternals/default.mspx. They can be used to see what DLLs are actually being loaded by an application and from where. Unzip the files and copy to a directory where they can be run. There is no installation process. To remove, just delete the files.
1.3.2 Using Process Explorer and PROCESS MONITOR
These tools can be used to determine whether MDAC DLLs are being loaded from the expected directories and give a clue whether there could be duplicate MDAC DLLs on the machine that need to be removed. This type of problem will generally not show up with the MDAC Component Checker.
1 Fixing MDAC
MDAC versions prior to MDAC 2.5 are not supported at all. Applications compiled against earlier versions of MDAC may not run on current versions as there were some breaking interface changes between MDAC 2.1 and MDAC 2.5; the applications will have to be recompiled to use the newer libraries.
1.1.1 SQL Native Client installation
SQL Native Client installations comes as a separate installation and not as part of MDAC.
1.1.2 Installing via SMS
Installing via SMS is supported by the SMS team.
MDAC install has a number of requirements that must be met for a successful installation. Many of these are the same as for successfully running the MDAC Component Checker.
- For Citrix/Terminal Server machines, it is best to run via Add/Remove Programs. You can also run from a remote Administrative console or via the main console while in Install mode.
- You have to be an Administrator on the machine.
- Turn off antivirus applications.
- Shut down applications and services that may be using MDAC components, such as SQL Server, SQL Reporting Services, etc., and any 3rd-party services.
- If the Common Files directory is redirected to another drive than C:, change the registry before installing, as indicated in the MDAC Component Checker section related to this.
- For persistent problems, install MDAC while booted into SAFE mode.
- After the installation, reboot and log back in as an Administrator to complete the install.
1.3 Install Issues
Make sure you install via the guidelines specified above. The MDAC installer makes a log file called DASETUP.LOG. If installing a hot fix, then get DAHOTFIX.LOG. Both files are located in the Windows directory. They can be used for advanced analysis.
1.4 Repair via Upgrade
Repair via Upgrade is the safest and best way to fix MDAC problems. Install a newer version of MDAC than you have on the system, run MDAC_TYPE.EXE to install, and then reboot. Login as an Administrator.
If no newer version exists for your system, then you will have to Reinstall MDAC if it is supported version, or repair the operating system or roll back an OS patch if the version you want to achieve is supported.
Instead of installing a new version of MDAC, especially of it is an OS version, you can often install a hot fix. MDAC hot fixes are cumulative. You can search the Knowledge Base for these articles. e.g.
841758 FIX: Hotfixes are available for MDAC 2.5 Service Pack 3
836799 FIX: Hotfixes are available for MDAC 2.7 Service Pack 1
839801 FIX: Hotfixes are available for MDAC 2.8
884103 How to obtain the latest MDAC 2.8 service pack *** includes SP1, SP2
1.5 Reinstall and Rollback
1.5.1 Standalone MDAC versions
On Windows NT4 and Win9x, we cannot roll back MDAC if MDAC 2.8 is installed. For earlier versions of MDAC, they can be rolled back with an old version of the MDAC Component Checker (v1.0) that is not available for download any more. In general, we should avoid trying to roll back MDAC on these machines and try to roll forward. NT4 and Win9x do not use ExceptionComponents and file versions are used as in most standard install programs.
On Windows 2000, you can install any arbitrary MDAC version, even if older than the current version, by following the steps below. Since MDAC is an operating system component, its installation is governed by ExceptionComponents registry keys. By deleting these keys, you can reinstall the same MDAC version or an older MDAC version. For newer versions, you do not have to delete these keys. They are located under the following registry key:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionSetupExceptionComponents
The keys have GUID names and a FriendlyName value. Any ExceptionComponent key with a FriendlyName containing the words MDAC, SQL, OLEDB, ODBC, MSXML, WEBDATA, etc. should be deleted. Most keys are MDAC keys. Generally, the only non-MDAC keys commonly seen are for Internet Explorer, DirectX, and Media Player.
If in doubt, delete the key, since accidentally leaving an MDAC key will prevent the installation from proceeding correctly.
1.5.2 OS MDAC versions
To reinstall or roll back of supported versions of MDAC requires an OS repair or OS Service Pack rollback.
1.5.3 Examples
Example 1
You have Windows 2000 SP3 and MDAC 2.53 (2.5 SP3). You want MDAC 2.52. This version comes with Windows 2000 SP2. You’ll have to roll back the OS to Windows 2000 SP2 in order to get that version of MDAC.
Example 2
You have Windows 2000 SP4 and MDAC 2.8. You want MDAC 2.71. Follow the reinstall steps in the previous section.
Example 3
You have Windows 2000 SP4 and MDAC 2.8. You want MDAC 2.53. Then you’ll have to repair/reinstall Windows 2000 SP4 in order to get this MDAC version.
Example 4
You have Windows 2003 RTM and MDAC 2.8. You want MDAC 2.81. This is not available. If you want MDAC 2.82, you have to install Windows 2003 SP1.
If someone tries to install MDAC on a Citrix or Terminal Services machine and is not in Install mode, then the MDAC files will be scattered across shared and private directories. The General Install Requirements section includes instructions on how to properly install MDAC on a Terminal Services machine.
In some installs, no drivers will show in the ODBC administrator. This is due to missing registry keys under HKLMSOFTWAREODBC. The easy fix for this is to export this sub-tree from a good machine that has the same Windows directory name and then import onto the broken machine.
On some systems, only the Administrator or a member of the Administrators group has access to the ODBC registry keys. To fix, use REGEDIT to set the permissions to give Everyone READ access (at a minimum) to HKLMSOFTWAREODBC and force this to propagate to sub keys.
Run the MDAC Repair tool to reregister all MDAC DLLs. Needs Microsoft PSS support.l
.NET Applications do not follow the COM load order. As such, the wrong MDAC DLLs can be loaded if there are duplicates on the system. Use FILEMON from http://www.sysinternals.com or DependencyWalker from http://www.dependencywalker.com to determine where the files are being loaded from and are they the right files. If there are duplicates, delete them and try running the application again. If it’s a web application, restart IIS (Start Run IISRESET).
1.6 Windows 64-Bit
64-bit versions of Windows have 2 versions of MDAC installed – the usual 32-bit version plus a 64-bit version. When you run MDAC tools, such as UDL files or the ODBC Administrator, these are 64-bit utilities and only use the 64-bit DLLs. Many drivers and providers will appear to be missing because they only exist in the 32-bit version of MDAC, which cannot be used by 64-bit applications.
We have a Windows 64-bit machine you can run via:
mstsc /v ncsql64amd2
Use your domain login.
1.6.1 Do we need 32-bit or 64-bit Drivers and Providers
Run the application and open Task Manager. If the application has *32 after the name, then it is a 32-bit application and will use the 32-bit MDAC and MDAC drivers and providers. If the application does not have anything after the name, then it is a 64-bit application and will use the 64-bit version of MDAC and the 64-bit drivers and providers.
1.6.2 Running 32-bit ODBC Administrator
You can run the 32-bit version of the ODBC Administrator from the following path:
c:windowssyswow64odbcad32.exe
The 64-bit version is in the system32 directory. This sounds backwards but was a conscious decision on the development teams to put the mainstream (i.e. 64-bit) files in system32 and the emulated or 32-bit files in the syswow64 directory. This stands for SYStem Windows [32] On Windows 64.
1.6.3 Examining the 32-bit Registry keys
Install Mdac 2.7 On Windows 10
REGEDIT will show the 32-bit registry keys under HKLMSOFTWAREWow6432Node. For example, the 32-bit ODBC tree is:
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBC
1.6.4 Running a 32-bit Test Script
You can test 32-bit vs. 64-bit functionality by running the following VBScript applet:
dim cn, rs
set cn = createobject(‘adodb.connection’)
cn.open ‘provider=sqloledb;server=localhost;integrated security=sspi;database=northwind’
msgbox ‘connected’
set rs = createobject(‘adodb.recordset’)
rs.cursorlocation=3
rs.open ‘SELECT * FROM Table1’, cn
msgbox ‘recordset has ‘ & rs.recordcount & ‘ rows.’
rs.close
cn.close
You will need to fix-up the connection string and the SELECT statement.
To run as a 32-bit application, use the following command-line:
C:WINDOWSSysWOW64wscript.exe c:test.vbs
To run as a 64-bit application, use the following command-line:
C:WINDOWSSYSTEM32wscript.exe c:test.vbs
or
Introduction 2. Steps to follow in order to run Huperterminal in Windows 10 3. HyperTerminal is a program that you can use to connect to other computers, telnet sites, bulletin board systems (BBS), online services, and host computers.HyperTerminal connections are made using a modem, a modem cable (used to emulate modem communication) or an Ethernet connection. Free hyperterminal download. Jul 08, 2017 I use to have HyperTerminal in Windows 7 but where can I find it in Windows 10? Any alternative if I can’t??
wscript.exe c:test.vbs
1.6.5 Running a 32-bit Data Link Properties (UDL) dialog
Install Mdac 2.8 Windows 10
Unfortunately, you cannot just run the 32-bit version of RunDLL32.exe to get the 32-bit UDL dialog. You have to set up a file extension. The instructions below associate the UDL32 extension with the 32-bit version of this dialog.
1. In Windows Explorer, use Tools Folder Options File Types to make a new file association.
2. Click New.
3. In the Create New Extension dialog, type UDL32 for the Extension and click OK. This will add the file extension to the Folder Options dialog.
4. Select the new extension and click Advanced.
5. For a name, type Microsoft Data Link 32.
6. Click New.. to add a new action.
7. Type open as the Action name.
8. For the Application used to perform action, enter:
c:windowssyswow64Rundll32.exe C:PROGRA~2COMMON~1SystemOLEDB~1oledb32.dll,OpenDSLFile %1
Install Mdac Windows 10 64
Note: You may have to alter the WINDOWS directory path. %windir% does not work as a generic path prefix. In addition, using long file names does not appear to work either. You can use DIR C: /X to confirm the Program Files (x86) folder has the short name of PROGRA~2. If not, you will have to alter this part of the path also.
9. Select DDE and then click OK.
10. Click OK on the Edit File Type dialog.
11. Click Close on the Folder Options dialog.
12. Right-click the desktop and create a new text document called test.udl32. A modified UDL icon will appear. Double-click the file and the Data Link Properties dialog will be displayed. You can verify this is running the 32-bit version of RUNDLL32 by checking in the Task Manager. In addition, you should see the familiar 32-bit OLE DB Providers for Jet, Oracle, MSDATASHAPE, etc.
-
Sep 8th, 2017, 06:28 PM
#1
Thread Starter
Frenzied Member
[RESOLVED] Win 10 MDAC problem
I attempted to install a program that required MDAC on a Win 10 machine. I normally don’t supply the MDAC install program (MDAC_TYP.EXE), because all previous versions already had it installed. Win 10 does not appear to come with it installed, so I included it in the install program. However, it hung on the MDAC install. When I ran my install program the second time, everything installed correctly. When I examined what got installed, it was WDAC 6.3.9600.16384. So I concluded that WDAC was included with Win 10, but not installed.
Can anyone confirm that WDAC is not installed on a new Win 10 installation? It normally can be found in the registry at:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccessJ.A. Coutts
-
Sep 8th, 2017, 06:33 PM
#2
Re: Win 10 MDAC problem
My Win10 v1703 has a DataAccess entry with a RootBinder subitem which has 2 subitems: ldap & winnt. Nothing I’m looking at references «WDAC». However, under the DataAccess item are two data entries indicating «Full21Install» and «FullInstallVer» (6.3.9600.16384). Hope that helps, but maybe makes it more foggy?
-
Sep 8th, 2017, 06:43 PM
#3
Re: Win 10 MDAC problem
Windows DAC (not «WDAC») is a set of preinstalled protected Windows components. There is no reason to try to install over the top of them with creaky ancient versions.
If you attempt to, File Protection will fend off your attempt. If you succeed in this it will detect it and replace the junk with correct versions afterward.
I have never had any need or reason to attempt this on any version of Windows since Windows 2000 SP 4 or so and probably earlier. Even Windows 95 with IE 4.x installed includes the MDAC/DAC components.
-
Sep 8th, 2017, 10:01 PM
#4
Thread Starter
Frenzied Member
Re: Win 10 MDAC problem
If a newer version of MDAC is already installed on a system, the installer should not attempt an install over top of the existing. What appears to have happened is that Win 10 recognized that a newer version existed but was not installed, and installed the version that it already had.
I found the following on superuser.com which seems to verify that:
«You can not install MDAC on Windows 10. However, you probably dont need it. Click Start and type «ODBC» and that will bring up Setup ODBC Data Sources. There are 32 and 64 bit versions, you should probably use the 32 bit version.»J.A. Coutts
Addendum: Not installing everything seems to be something that Win 10 does. Even though the drivers were installed, I still had to activate WiFi & Bluetooth, and there was no help offered.
Last edited by couttsj; Sep 8th, 2017 at 11:08 PM.
-
Sep 8th, 2017, 10:09 PM
#5
Re: Win 10 MDAC problem
I’ve installed data related programs on Windows 10 machines several times already and had no issues.
The last time I ran into an MDAC issue was because it was included in my installer and that was I think Windows 2000.
I have omitted it from all installs since then and I not had any related issue on any version of Windows including 10 and various server versions.Edit: Now that I think about I am pretty sure that all of the windows 10 machines I have installed on also have SQL Server Express installed on them so I do not know if that would be why I have not saw an issue or not.
Last edited by DataMiser; Sep 8th, 2017 at 10:12 PM.
-
Oct 24th, 2019, 09:30 AM
#6
New Member
Re: [RESOLVED] Win 10 MDAC problem
Thank you. I have limited Windows experience and wondered if you want to remote my machine and change to MDAC 2.8 on my Windows 10. I’m willing to pay for it. What do you think?
Windows 10: How to uninstall and re-install MDAC on windows 10?
Discus and support How to uninstall and re-install MDAC on windows 10? in Windows 10 Installation and Upgrade to solve the problem; Receiving the error to check if MDAC 2.1 or later is properly installed—was advised to uninstall and reinstall —is there a tutorial on how to do…
Discussion in ‘Windows 10 Installation and Upgrade’ started by BillWilliams70806, Aug 26, 2021.
-
How to uninstall and re-install MDAC on windows 10?
Receiving the error to check if MDAC 2.1 or later is properly installed—was advised to uninstall and reinstall —is there a tutorial on how to do so?thank youBillWilliams70806
-
MDAC installation on windows
Hi,
I am new to the community and would like to ask a question about Microsoft Data Access Components.
I am currently working on some software that requires a dll that’s present as part of ADO package of MDAC (specifically msjro.dll). My question is whether or not it is safe to assume that the MDAC components will be installed on all Windows operating systems
or is it my applications responsibility to ensure that the component is installed properly.If it’s not installed by default, how could I ensure that msjro.dll is reditributed appropriately?
can it be freely redistributed if necessary, I couldn’t find an End User License Agreement for MDAC componenets
— Avanish
-
windows xp installation and dual core am
could someone please list the steps they follow to install windows with a dual core processor and windows xp service pack to. I’m reletively new to amd dual core and i feel i’m missing a step. All help will be appreciated. thanx
-
How to uninstall and re-install MDAC on windows 10?
Ask for help for my MDAC problem after upgrade from Windows 10 Home OEM edition to Windows 10 Pro edition !!
After upgrading my windows 10 Home OEM edition to Windows 10 Pro version 1803, I have encountered that one of my application that running in 32 bit had the problem with the MDAC that did not have problem before the upgrade.
I keep on receiving message «The .NET Framework Data Providers require Microsoft Data Access Components(MDAC). Please install Microsoft Data Access Components(MDAC) version 2.6 or later». (my current MDAC is Windows DAC version 6.3.9600.16384)
I’ve tried installing with MDAC version 2.8 SP1 but still not solving the problem.
Is there any suggestion to solve this issue ?
How to uninstall and re-install MDAC on windows 10?
-
How to uninstall and re-install MDAC on windows 10? — Similar Threads — uninstall install MDAC
-
How to get MDAC installed and working correctly for Windows 11 Pro ?
in Windows 10 Gaming
How to get MDAC installed and working correctly for Windows 11 Pro ?: Hi Folks Hope you can steer me to solving a MS-Windows 11 Pro problemI installed a program that is no longer made and the company they sold the software no longer exists but I need this program functional I installed it and then when running if fails with popup that MDAC V… -
How to get MDAC installed and working correctly for Windows 11 Pro ?
in Windows 10 Software and Apps
How to get MDAC installed and working correctly for Windows 11 Pro ?: Hi Folks Hope you can steer me to solving a MS-Windows 11 Pro problemI installed a program that is no longer made and the company they sold the software no longer exists but I need this program functional I installed it and then when running if fails with popup that MDAC V… -
How to re-install Windows 10?
in Windows 10 Software and Apps
How to re-install Windows 10?: I want to get rid of the manfuc Windows 10 and install a clean Windows 10 from Windows.I re-installed Windows 10 from Windows media creation tool, yet when its on, I can still see the manaf trash pre-installed apps such as Disney and SKype app.I want a clean version…. -
How to re-install Windows 10?
in Windows 10 Installation and Upgrade
How to re-install Windows 10?: I want to get rid of the manfuc Windows 10 and install a clean Windows 10 from Windows.I re-installed Windows 10 from Windows media creation tool, yet when its on, I can still see the manaf trash pre-installed apps such as Disney and SKype app.I want a clean version…. -
MDAC
in Windows 10 Drivers and Hardware
MDAC: Im a complete noob at computers i need help but when i run a program it keeps saying I need to install MDAC 2.6 or later, but i already did..I went on to the microsoft and downloaded the MDAC 2.8 SP1 , nothing happened , this still comes out
This is the details…
-
Uninstall and Re-Install of iTunes on Windows 10
in Windows 10 Installation and Upgrade
Uninstall and Re-Install of iTunes on Windows 10: I have had iTunes as a standalone program on my Windows 10 laptop for some years. Unfortunately it had malfunctioned so I used the Programs and Features to uninstall it.Having loaded the iTunes App from the Microsoft Store I am now receiving the message that the previous…
-
Uninstall and re-install
in Windows 10 Network and Sharing
Uninstall and re-install: I keep getting the following message when I boot up. The file ‘C:Program Files x86\driver support\svc/install.log … I guess I’ve got to uninstall that file and then reinstall it. Don’t know how to and don’t even know where to find the file……Help?……Mick… -
Windows uninstall and re-install
in Windows 10 Installation and Upgrade
Windows uninstall and re-install: Hi, my daughter bought a lenovo 120S-11iap ideapad with only 32GB of eMMC memory.I have tried to upgrade the internal memory with an SSD hard drive but found that there is no M2 socket to connect it to, despite what it says in the Lenovo manual. I took this up with Lenovo…
-
Re-Install after Uninstall
in Windows 10 Installation and Upgrade
Re-Install after Uninstall: After installing Win 10 I found 2 apps that would not execute under Win 10. I uninstalled Win 10 using the provided re-install Win 7. I have solved the problem with the apps and I would like to re-install Win 10. How do I receive the invitation to install Win 10 again, or is…
Users found this page by searching for:
-
MDAC 2.0 Windows 10 problem