-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: rajusavadi
Message 5 in Discussion
Any other solution, use of API calls or registry
keys. Is that possible.?
Using SQLDemo we can display list of servers on the
network. But I dont want to give option for user to select any server n
connect, has to automatically connect to local server. For local we
can mention local, it works fine , if ther is no Installed instances of Sql,
suppose if ther is any, we got find the Installed Instances (for eg NETSDK) ,
use the same to connect.
Thanks n Regards
Gururaj Savadi
----- Original Message -----
From:
BDOTNET
To: BDOTNET
Sent: Tuesday, April 20, 2004 3:27
PM
Subject: Re: How to find SQL Server Name
installed
New Message on BDOTNET
How to
find SQL Server Name installed
Reply
Recommend
Message 4 in
Discussion
From: SriSamp
You cannot. To use the earlier queries, you need to be
connected to some server. If this server by itself is not known,
one option is for you to use the SQLDMO library and provide
the user the list of SQL Servers on the network and then ask
the user to select one. Post this, you can substitute this in
your connection string and then talk to that server.
Here is an article that I wrote on the same:
http://www32.brinkster.com/srisamp/sqlArticles/article_15.htm
HTH,
Srinivas Sampath
MVP - SQL Server
http://www32.brinkster.com/srisamp
View other groups in this
category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
