How to use the ListAvailableSqlServers in c#

Here is my code:

///////////////////////////////////////////////////////////////////////////
SQLDMO._Application SqlServer = new ApplicationClass();
try
{

SQLDMO.NameList servers = SqlServer.ListAvailableSQLServers();

for(int i=0;i<servers.Count;i++)
MessageBox.Show(servers.Item(i));

}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}

///////////////////////////////////////////////////////////////////////////
The compiler tell me : Queryinterface is failed of the SQLDMO.NameList

What shall I do ?

[Ansil MCAD]

hi
Use COM interop to call SQL-DMO. It can enumerate servers.

also check this article
http://www.csharphelp.com/archives2/archive342.html

regards
Ansil
Dimensions Technopark Trivandrum
an****@gmail.com

"ch**@163.com" wrote:

Here is my code:

///////////////////////////////////////////////////////////////////////////
SQLDMO._Application SqlServer = new ApplicationClass();
try
{

SQLDMO.NameList servers = SqlServer.ListAvailableSQLServers();

for(int i=0;i<servers.Count;i++)
MessageBox.Show(servers.Item(i));

}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}

///////////////////////////////////////////////////////////////////////////
The compiler tell me : Queryinterface is failed of the SQLDMO.NameList

What shall I do ?

[Willy Denoyette [MVP]]

Time to install the SQL client from the latest SP for SQL server 2000.

Willy.

<ch**@163.com> wrote in message
news:u9**************@TK2MSFTNGP11.phx.gbl...

Here is my code:

///////////////////////////////////////////////////////////////////////////
SQLDMO._Application SqlServer = new ApplicationClass();
try
{

SQLDMO.NameList servers = SqlServer.ListAvailableSQLServers();

for(int i=0;i<servers.Count;i++)
MessageBox.Show(servers.Item(i));

}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}

///////////////////////////////////////////////////////////////////////////
The compiler tell me : Queryinterface is failed of the SQLDMO.NameList

What shall I do ?

I have read your article about the SQL-DMO at your web site ,And I tried
your code in my program ,but the
same error occured ,Can you tell me why ?
Error :Queryinterface is failed of the SQLDMO.NameList

"Ansil MCAD" <An*******@discussions.microsoft.com> дÈëÏûÏ¢ÐÂÎÅ
:A0**********************************@microsoft.co m...

hi
Use COM interop to call SQL-DMO. It can enumerate servers.

also check this article
http://www.csharphelp.com/archives2/archive342.html

regards
Ansil
Dimensions Technopark Trivandrum
an****@gmail.com

"ch**@163.com" wrote:

Here is my code:

/////////////////////////////////////////////////////////////////////////// SQLDMO._Application SqlServer = new ApplicationClass();
try
{

SQLDMO.NameList servers = SqlServer.ListAvailableSQLServers();

for(int i=0;i<servers.Count;i++)
MessageBox.Show(servers.Item(i));

}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}

/////////////////////////////////////////////////////////////////////////// The compiler tell me : Queryinterface is failed of the SQLDMO.NameList

What shall I do ?

I have read your article about the SQL-DMO at your web site ,And I tried
your code in my program ,but the
same error occured ,Can you tell me why ?
Error :Queryinterface is failed of the SQLDMO.NameList

"Ansil MCAD" <An*******@discussions.microsoft.com> дÈëÏûÏ¢ÐÂÎÅ
:A0**********************************@microsoft.co m...

hi
Use COM interop to call SQL-DMO. It can enumerate servers.

also check this article
http://www.csharphelp.com/archives2/archive342.html

regards
Ansil
Dimensions Technopark Trivandrum
an****@gmail.com

"ch**@163.com" wrote:

Here is my code:

/////////////////////////////////////////////////////////////////////////// SQLDMO._Application SqlServer = new ApplicationClass();
try
{

SQLDMO.NameList servers = SqlServer.ListAvailableSQLServers();

for(int i=0;i<servers.Count;i++)
MessageBox.Show(servers.Item(i));

}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}

/////////////////////////////////////////////////////////////////////////// The compiler tell me : Queryinterface is failed of the SQLDMO.NameList

What shall I do ?

[Willy Denoyette [MVP]]

This is a known problem, solved a couple of years ago with a SP for SQL2000.

Willy.

<ch**@163.com> wrote in message
news:u$**************@TK2MSFTNGP11.phx.gbl...

I have read your article about the SQL-DMO at your web site ,And I tried
your code in my program ,but the
same error occured ,Can you tell me why ?
Error :Queryinterface is failed of the SQLDMO.NameList

"Ansil MCAD" <An*******@discussions.microsoft.com> дÈëÏûÏ¢ÐÂÎÅ
:A0**********************************@microsoft.co m...

hi
Use COM interop to call SQL-DMO. It can enumerate servers.

also check this article
http://www.csharphelp.com/archives2/archive342.html

regards
Ansil
Dimensions Technopark Trivandrum
an****@gmail.com

"ch**@163.com" wrote:

> Here is my code:
>
> /////////////////////////////////////////////////////////////////////////// > SQLDMO._Application SqlServer = new ApplicationClass();
> try
> {
>
> SQLDMO.NameList servers = SqlServer.ListAvailableSQLServers();
>
> for(int i=0;i<servers.Count;i++)
> MessageBox.Show(servers.Item(i));
>
> }
> catch(Exception e)
> {
> MessageBox.Show(e.ToString());
> }
>
>
>
> /////////////////////////////////////////////////////////////////////////// > The compiler tell me : Queryinterface is failed of the SQLDMO.NameList
>
> What shall I do ?
>
>
>
>