sql server server name

[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

 

[William Ryan]

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