I did this very same setup however :

Scenario #1
1. I've setup SQL Server to listen on the default port 1433
2. I can ping from the client
3. ODBC does not connect using TCP/IP


Scenario #2
1. I've setup SQL Server to listen on the default port 1433
2. I can ping from the client
3. ODBC connects using TCP/IP
4. I cannot make a connection when I use a DSN less connection. I've replaced the server name with the ip address of the SQL Server in the connection string i published in my earlier threads.



In all the cases however where I cannot ping ODBC/My DSN less connection will not connect.