How to check a database connection connection works on the Database Server or thru any Remote Server?

How to check a database connection connection works on the Database Server or thru any Remote Server?

Or

How to check if any OLE DB provider is installed on the Database server or Remote Server or any machine?

The easiest way to find out what kind of database connection provider exists on any Database or thru any Remote server is as follows:

1. Create a new text file on the Database server
2. Rename the file "New Text Document.txt" as "Test.udl". (Just rename the text file extension as "*.udl")
3. Double click the file. It should open the Data Link properties. Specify the required information to test your connection works or not.

4. Also you can check the "Provider" tab and which list all of the OLE DB provider that is installed on the given Server like "OLE DB", "SQL Native", etc.

Reference Link:

https://blogs.msdn.microsoft.com/steverac/2010/12/13/test-remote-sql-connectivity-easily/