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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Specifying instance name for remote server?

Author  Topic 

krisbg
Starting Member

5 Posts

Posted - 2003-11-19 : 03:38:21
Can I specify which instance name to use when connecting to a remote SQL Server through ODBC using IP address and port number? What would be the connection string?
Thanks in advance!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-11-19 : 12:20:16
Connection information would be like this:

XXX.XXX.XX.XXX, XXXX

But why would you want to do that? Create an alias on the client machine instead. The alias can be created using Client Network Utility, ODBC screens, or manual registry modifications.

Tara
Go to Top of Page
   

- Advertisement -