Problem checking connection to your Database?

I recently learned this trick using Universal Data Link files

There are many methods out there, sometimes could be confusing

For windows users I stumbled upon this neat trick:

– Create a new file with the extension “*.UDL”
– Open the file and enter data:

1. Enter the server IP (Sometimes machine names create problems)
2. Add database username and password
3. Select DB name from the list (should show all the DBs hosted on the machine with IP from step 1)
4. Press Test Connection

and Wala.. you can get your answer

P.S.
Your Spring Boots app might not be connecting to your DB because of using the machine name instead of the IP as well..

For more details:
https://fileinfo.com/extension/udl

#QsDaily #database