>HI Guys!
>
>Is there a possible way on how to get the computer name of the remote server you are connecting to via DSN?
>
>Thanks in advance
>
>Mike

If you can execute on remote server

SELECT serverproperty('MachineName'), serverproperty('ServerName')

than you can get the name of remote computer.