While I check if I saved the DSN with Password, please find below a link to a video showing the various actionsFirst step:
View attachment 108084
Then
View attachment 108085
Then choose an existing DSN or create a new one which will prompt you for the server details. If you go New you can pick the driver to use:
View attachment 108086
Then you get to enter your detials
View attachment 108087
Hopefully from there you get a list of tables and views on your server, select one and create the link.
There is a box that says save password:
View attachment 108088
This should create a linked table and the the appropriate connection string.
Dropbox
www.dropbox.com