Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-14 : 10:45:41
|
| Terry writes "How do I connect to my SQL Server 2000 from VB 6 over the internet? My main goal is to be able to upload data to our inhouse SQL Server from our client applications across the internet.ThanksTerry Balcom" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-14 : 11:34:53
|
| It's pretty easy: make sure you are using the TCP/IP network library, and specify the IP address of the client's SQL Server. You can register it in Enterprise Manager this way.If you encounter problems, run the SQL Client Network Utility and create an alias for the client's server. Indicate TCP/IP as the network, put in the IP address, and change the name to suit your needs. If the "auto-port detect" setting does not allow you to connect, find out from the client which port they use and put it in the alias settings. You can then use the alias when connecting with EM or Query Analyzer.If you STILL have trouble connecting, find out if you or the client have a firewall set up that blocks traffic, especially for the specific port number. |
 |
|
|
|
|
|
Internet Connection