Thanks Jack !

After much trial and error I found the trick.

I set up a scheduled job that runs every 5 minutes that executes this statement:

exec sp_enum_oledb_providers

This is the magic statement executed when you click on properties and then click OK.