Perhaps I misunderstood. These instructions are for a DSN connection. I've never tried a DSN-less connection across the net.

Guy



>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.