VB Connection to SQL 2K via TCP/IP

[JeffCarlin]

We have a VB app that is deployed to about 10 sites, with about 60 users, all connected via T1. Now, a new site is coming online and they will not be connected on the T1. The only way I will be able to reach them is via TCP/IP. Does anyone have any experience with this? Thanks.

 

[sguslan]

You seem to be confusing E1 as class of communication line with TCP/IP which is a networking protocol. TCP/IP can run on any kind of communication lines, be it E1, SDLC/digital leased lines, or ethernet LAN. TCP/IP is 3 levels up in the hierarchy of a network stack with the 2 layers below it specific to the type of underlying physical network/communication infrastructure.

Configure SQL Network libraries to accept TCP/IP connections and that is all SQL needs. Now, TCP/IP server/client setup is important and affects the way you connect to the server, i.e. the presence of DNS server. So, try connecting using the TCP/IP domain name for the server and if that fails try connecting using the server TCP/IP address.

________________________________________________________________________________
If you do not like change, get out of the IT business...