'How to deploy Provider SQLOLEDB.1 on windows 2008 R2 64-bit

In my VB6 application, I connect to the SQL Server 2008 R2 using Provider SQLOLEDB.1. This is not supporting on windows 2008 R2 64-bit. How to deploy "SQLOLEDB.1" provider on windows 2008 R2 64-bit.



Solution 1:[1]

Looks like downloading and registering Sqloledb.dll, might work.

See here: Installing the OLE DB Provider for SQL Server and the middle of this page, where the ASOLEDB9.msi packages are (32 and 64 bit versions). Those packages will install the sqloledb provider.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1