Yes I can ping the SQL machine from the clients and the response is good. When I tried using QA from the client, I got the following:
Unable to connect to server P4
ODBC: Msg 0, Level 16, State1
.... Timeout Expired
I just made sure it is using TCP and unchecked determine dynamically, so it is using 1433.
I still have the same error.
When I test a DSN on the machine with SQL, it is successful and the response is immediate.
Appreciate the help,