Skip to main content

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

Comments

Popular Posts

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
Shut down FortiClient from the system tray.
Run net stop fortishield on command prompt.
Run msconfig.
On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.Run services.msc on command prompt to open up show all available services.Look for FortiClient Service Scheduler. Switch Startup type to Manual.Restart your computer. FortiClient should not be running automatically the next time round. Hope it helps.

Ho Ching named 5th most powerful and is mistaken as first lady by Forbes

Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world. Ho Ching is mistaken as Singapore's first lady! OMG!

I wonder how can Forbes makes such a blunder. For a complete list, refer to here.

Google Suggestion "where is" - Najib, Rosmah - Malaysia GE17

The 14th Malaysian general election held on 9 May 2018 had concluded with the incumbent Barison Nasional (BN) voted out and Najib losing his Prime Minister position. Taking over the government is the opposition party with Dr Tun Mahathir Mohamad, a former Prime Minister of Malaysia, being sworn in as the 7th Prime Minister. Dr Mahathir is now 92 years old.

So where exactly is Najib and his wife Rosmah? Even Google is showing the below when I type "where is". I bet many people are now searching for this.