Easy way to test a connection to an OLEDB data source.
- Save an empty file to desktop with a UDL extension.
- Double-click to open and use the Data Link tool to test connectivity to the required source using the choice of providers.
Used this tool when troubleshooting a failed SCCM 1702 install. Logs indicated SQL native client error. Tested connection to SCCM DB using this tool using the server name (worked) and then FQDN (failed). Found a reg key to change this setting. Restarted the SCCM 1702 install and it worked!