List of Sqlservers on LAN

[Reza Alirezaei]

How can I have a list of all sql servers avaiable on our LAN populated in a
DropDownList exacly like what we have when we want to specify Datasource in
ADO.Net or wherever?

Thanks

[Zoury]

Hi reza!

you need to call the NetServerEnum API
http://www.codeproject.com/cs/combob...erdropdown.asp

--
Best Regards
Yanick Lefebvre

[Trebek]

Hello,

Easiest thing to do IMHO is to make a ref to the SQLDMO.dll and call the
method that follows :

SQLDMO.Applicat ion app = new SQLDMO.Applicat ionClass();

SQLDMO.NameList lst = app.ListAvailab leSQLServers();

IEnumerator ie = lst.GetEnumerat or();

while (ie.MoveNext())

{

Debug.WriteLine (ie.Current.ToS tring());

}

HTH,

Alex


"Reza Alirezaei" <an*******@disc ussions.microso ft.com> wrote in message
news:ut******** ******@TK2MSFTN GP09.phx.gbl...

How can I have a list of all sql servers avaiable on our LAN populated in a DropDownList exacly like what we have when we want to specify Datasource in ADO.Net or wherever?

Thanks

[Reza Alirezaei]

that works fine,,,how can I get a list of databases available on the
specified server on a separate Combobox?

"Trebek" <al********@int heformofaquesti on.com> wrote in message
news:40******** *************** @nnrp.fuse.net. ..

Hello,

Easiest thing to do IMHO is to make a ref to the SQLDMO.dll and call the
method that follows :

SQLDMO.Applicat ion app = new SQLDMO.Applicat ionClass();

SQLDMO.NameList lst = app.ListAvailab leSQLServers();

IEnumerator ie = lst.GetEnumerat or();

while (ie.MoveNext())

{

Debug.WriteLine (ie.Current.ToS tring());

}

HTH,

Alex


"Reza Alirezaei" <an*******@disc ussions.microso ft.com> wrote in message
news:ut******** ******@TK2MSFTN GP09.phx.gbl...

How can I have a list of all sql servers avaiable on our LAN populated

in a

DropDownList exacly like what we have when we want to specify Datasource

in

ADO.Net or wherever?

Thanks

[James Morton]

it returns a collection called a NameList, just use foreach.

private SQLDMO.NameList sqlServers;

sqlDMOApp = new SQLDMO.Applicat ion();

sqlServers = sqlDMOApp.ListA vailableSQLServ ers();

foreach (string server in sqlServers)

{

comboBox1.Items .Add(server);

}

"Reza Alirezaei" <an*******@disc ussions.microso ft.com> wrote in message
news:eH******** ******@TK2MSFTN GP09.phx.gbl...

that works fine,,,how can I get a list of databases available on the
specified server on a separate Combobox?

"Trebek" <al********@int heformofaquesti on.com> wrote in message
news:40******** *************** @nnrp.fuse.net. ..

Hello,

Easiest thing to do IMHO is to make a ref to the SQLDMO.dll and call the
method that follows :

SQLDMO.Applicat ion app = new SQLDMO.Applicat ionClass();

SQLDMO.NameList lst = app.ListAvailab leSQLServers();

IEnumerator ie = lst.GetEnumerat or();

while (ie.MoveNext())

{

Debug.WriteLine (ie.Current.ToS tring());

}

HTH,

Alex


"Reza Alirezaei" <an*******@disc ussions.microso ft.com> wrote in message
news:ut******** ******@TK2MSFTN GP09.phx.gbl...

How can I have a list of all sql servers avaiable on our LAN populated in

a

DropDownList exacly like what we have when we want to specify

Datasource in

ADO.Net or wherever?

Thanks

[Zoury]

look up the sp_databases stored procedure..

//**
using System.Data;
using System.Data.Sql Client;

private void ListDatabases(s tring serverName)
{
SqlConnection cn = new SqlConnection(" Integrated Security=SSPI;P ersist
Security Info=False;User ID=sa;Initial Catalog=te;Data Source=" + serverName
+ ";");

try
{
cn.Open();
SqlDataReader dr = (new SqlCommand("sp_ databases",
cn)).ExecuteRea der();
}
catch
{
if (cn.State == ConnectionState .Open) {cn.Close();}
return;
}

Console.WriteLi ne("List of [" + serverName + "] SQL Server" );
while (dr.Read())
{
Console.WriteLi ne(dr["DATABASE_N AME"] as string);
}

cn.Close();
}
//***

--
Best Regards
Yanick Lefebvre
"Reza Alirezaei" <an*******@disc ussions.microso ft.com> a écrit dans le
message de news:eH******** ******@TK2MSFTN GP09.phx.gbl...

that works fine,,,how can I get a list of databases available on the
specified server on a separate Combobox?

"Trebek" <al********@int heformofaquesti on.com> wrote in message
news:40******** *************** @nnrp.fuse.net. ..

Hello,

Easiest thing to do IMHO is to make a ref to the SQLDMO.dll and call the
method that follows :

SQLDMO.Applicat ion app = new SQLDMO.Applicat ionClass();

SQLDMO.NameList lst = app.ListAvailab leSQLServers();

IEnumerator ie = lst.GetEnumerat or();

while (ie.MoveNext())

{

Debug.WriteLine (ie.Current.ToS tring());

}

HTH,

Alex


"Reza Alirezaei" <an*******@disc ussions.microso ft.com> wrote in message
news:ut******** ******@TK2MSFTN GP09.phx.gbl...

How can I have a list of all sql servers avaiable on our LAN populated in

a

DropDownList exacly like what we have when we want to specify

Datasource in

ADO.Net or wherever?

Thanks

[James Morton]

doh, didnt see "databases" .

Zoury has it right, also if you want to get more detailed information you
can just hit the sysdatabases table in the master databases, pretty much all
sp_databases is doing.

select * from master.dbo.sysd atabases

Your real problem is that your choice is based off the server selection they
make and the security context your going to connect as. You can either make
them select the server, then enter security info, then pass them as
variables to the sqlconnection string, OR embed trusted or a sql login that
you know has rights to the servers (kinda dangerous).

"Zoury" <ya************ *@hotmail.com> wrote in message
news:u#******** ******@tk2msftn gp13.phx.gbl...

look up the sp_databases stored procedure..

//**
using System.Data;
using System.Data.Sql Client;

private void ListDatabases(s tring serverName)
{
SqlConnection cn = new SqlConnection(" Integrated Security=SSPI;P ersist
Security Info=False;User ID=sa;Initial Catalog=te;Data Source=" + serverName + ";");

try
{
cn.Open();
SqlDataReader dr = (new SqlCommand("sp_ databases",
cn)).ExecuteRea der();
}
catch
{
if (cn.State == ConnectionState .Open) {cn.Close();}
return;
}

Console.WriteLi ne("List of [" + serverName + "] SQL Server" );
while (dr.Read())
{
Console.WriteLi ne(dr["DATABASE_N AME"] as string);
}

cn.Close();
}
//***

--
Best Regards
Yanick Lefebvre
"Reza Alirezaei" <an*******@disc ussions.microso ft.com> a écrit dans le
message de news:eH******** ******@TK2MSFTN GP09.phx.gbl...

that works fine,,,how can I get a list of databases available on the
specified server on a separate Combobox?

"Trebek" <al********@int heformofaquesti on.com> wrote in message
news:40******** *************** @nnrp.fuse.net. ..

Hello,

Easiest thing to do IMHO is to make a ref to the SQLDMO.dll and call the method that follows :

SQLDMO.Applicat ion app = new SQLDMO.Applicat ionClass();

SQLDMO.NameList lst = app.ListAvailab leSQLServers();

IEnumerator ie = lst.GetEnumerat or();

while (ie.MoveNext())

{

Debug.WriteLine (ie.Current.ToS tring());

}

HTH,

Alex


"Reza Alirezaei" <an*******@disc ussions.microso ft.com> wrote in message news:ut******** ******@TK2MSFTN GP09.phx.gbl...
> How can I have a list of all sql servers avaiable on our LAN

populated

in

a
> DropDownList exacly like what we have when we want to specify

Datasource in
> ADO.Net or wherever?
>
> Thanks
>
>