SQL Server ODBC system error code 126

Recently at a site which had Windows Server 2003 R2 64bit SP2, the following error message was received when attempting to create a new SQL Server ODBC data source:

The setup routines for the SQL Server ODBC driver could not be loaded due to system error code 126.

image1
image2
image3
The resolution in this case was to locate, right click on C:\WINDOWS\inf\mdac.inf and select Install.
image4
You may need to locate the media to complete the process.
image5

Your email address will not be published.