I have a problem connecting to a remote sever using ODBC.One box is windows server 2000 with sql sever 2000 on and the other is windows server 2003 with sql 2000.
Now the problem is when i connect to the second box using ODBC from query analyzer of first box it works well, but when i use the same query through a application(SQR) in peoplesoft it's not working.It neither gives any error the process just get's stuck and i have to kill the process.

I have no idea of how to deal with this.......................
Any help on this would be great...