John Cooper (5/22/2014)
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.
Haven't done a deep dive on it but that seems like a very nice trick. Thanks for posting it.
--Jeff Moden
Change is inevitable... Change for the better is not.