Sunday, July 08, 2012

How to check 32 bit OLE DB providers installed on a 64 bit machine?

One method to check the OLE DB providers installed on your machine is to create an UDL file and run it. However, if you are running a 64 bit operating system, running the UDL file will list all the 64 bit OLE DB providers installed and not the 32 bit ones.

To enumerate and show the 32 bit OLE DB providers, perform the following steps:

1. Create a UDL file with the name test.udl under the path, C:\.

2. To list the 32-bit OLE DB providers installed on a 64 bit operating system, run the below command on Command Line.

C:\Windows\SysWOW64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll", OpenDSLFile C:\test.udl

NOTE: If we simply double click on the UDL file instead of running the above command on command line, it will list out 64 bit OLE DB providers by default.

» How to run 32-bit UDL file on a 64-bit Operating System | Chaitanya's Blogs -- SQL Developer findings

No comments:

Post a Comment

Do provide your constructive comment. I appreciate that.