Ness (7/19/2012)
Try creating a SystemDSN entry on the machine you are trying to connect from AdminTools > ODBC DataSource Administrator > System DSNThis can be a good initial test of connectivity
I believe that what the OP is saying is that a remote connection is working, it is the local connection that is not.