You need to know what is not working, the IP resoluion or is the IP number hard coded in the ODBC or program.

Try this, ping the server by name from...