sql server server name

  • Thread starter Thread starter Bernie Yaeger
  • Start date Start date
B

Bernie Yaeger

Is there a way - through the api - to get the name of a client's sql server
server name and then use that as input to the connection object, such that
even tho' my test server name is one thing, when the app is on my client's
machine (network server), the connection will be made without my having to
change all my connection strings each time for each client?

Thanks for any help.

Bernie Yaeger
 
Bernie:

Check out www.codeproject.com , I forwarded you the email with the article,
b/c I didn't have the link off the top of my head, but it's by Michael
Potter titled Finding SQL Servers on the Network.
It will list the names of all of the servers..

HTH,

Bill
 
Back
Top