How to use the ListAvailableSqlServers in c#

Hi, try

Mostrar la cita

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

and look this link http://www.csharphelp.com/archives2...ve342.html

regards


José Miguel Torres
jtorres_diaz~~ARROBA~~terra.es
http://jmtorres.blogspot.com
escribió en el mensaje
news:#zpIf$
Mostrar la cita

Here is my code:

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

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());
}

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

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

What shall I do ?

Now the question is ListAvailableSqlServers make for the error!
Even if I tried your code
{
SQLDMO.Application App= new ApplicationClass();
SQLDMO.NameList servers = App.ListAvailableSQLServers();
}
The same error appeared!!!

God help me!


"Jos?Miguel Torres" <jtorres_diaz~~ARROBA~~terra.es> дÈëÏûÏ¢ÐÂÎÅ
:#
Mostrar la cita

Hi, try

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

and look this link http://www.csharphelp.com/archives2...ve342.html

regards


Jos?Miguel Torres
jtorres_diaz~~ARROBA~~terra.es
http://jmtorres.blogspot.com
escribi?en el mensaje
news:#zpIf$
> Here is my code:
>
>

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

> 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());
> }
>
>
>
>

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

> The compiler tell me : Queryinterface is failed of the SQLDMO.NameList
>
> What shall I do ?
>
>
>
>
>

Well, Are you using VS .NET 2002 or 2003? And SQL Server 2000 with any SP? I
know a bug in VS .NET 2002 COM interops if you don't have SP3 in your SQL
Server...


escribió en el mensaje
news:u#
Mostrar la cita

Now the question is ListAvailableSqlServers make for the error!
Even if I tried your code
{
SQLDMO.Application App= new ApplicationClass();
SQLDMO.NameList servers = App.ListAvailableSQLServers();
}
The same error appeared!!!

God help me!


"Jos?Miguel Torres" <jtorres_diaz~~ARROBA~~terra.es> дÈëÏûÏ¢ÐÂÎÅ
:#
> Hi, try
>
> > for(int i=0;i<servers.Count;i++)
> > MessageBox.Show(servers.Item(i).ToString());
>
> and look this link http://www.csharphelp.com/archives2...ve342.html
>
> regards
>
>
> Jos?Miguel Torres
> jtorres_diaz~~ARROBA~~terra.es
> http://jmtorres.blogspot.com
> escribi?en el mensaje
> news:#zpIf$
> > Here is my code:
> >
> >
>

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

> > 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());
> > }
> >
> >
> >
> >
>

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

> > The compiler tell me : Queryinterface is failed of the SQLDMO.NameList
> >
> > What shall I do ?
> >
> >
> >
> >
> >
>
>

I use Vs.net 2003 and My SqlServer have sp3


"Jos?Miguel Torres" <jtorres_diaz~~ARROBA~~terra.es> дÈëÏûÏ¢ÐÂÎÅ
:#
Mostrar la cita

Well, Are you using VS .NET 2002 or 2003? And SQL Server 2000 with any SP?

I
Mostrar la cita

know a bug in VS .NET 2002 COM interops if you don't have SP3 in your SQL
Server...


escribi?en el mensaje
news:u#
> Now the question is ListAvailableSqlServers make for the error!
> Even if I tried your code
> {
> SQLDMO.Application App= new ApplicationClass();
> SQLDMO.NameList servers = App.ListAvailableSQLServers();
> }
> The same error appeared!!!
>
> God help me!
>
>
> "Jos?Miguel Torres" <jtorres_diaz~~ARROBA~~terra.es> дÈëÏûÏ¢ÐÂÎÅ
> :#
> > Hi, try
> >
> > > for(int i=0;i<servers.Count;i++)
> > > MessageBox.Show(servers.Item(i).ToString());
> >
> > and look this link http://www.csharphelp.com/archives2...ve342.html
> >
> > regards
> >
> >
> > Jos?Miguel Torres
> > jtorres_diaz~~ARROBA~~terra.es
> > http://jmtorres.blogspot.com
> > escribi?en el mensaje
> > news:#zpIf$
> > > Here is my code:
> > >
> > >
> >
>

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

> > > 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());
> > > }
> > >
> > >
> > >
> > >
> >
>

///////////////////////////////////////////////////////////////////////////
Mostrar la cita

> > > The compiler tell me : Queryinterface is failed of the

SQLDMO.NameList
Mostrar la cita

> > >
> > > What shall I do ?
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>

Try with this code:

using System;
using System.Reflection;

internal class RetrieveSqlServerListApp {

public static void Main() {
// Invoke the ListAvailableSQLServers() method for a
SQLDMO.Application instance
Type oSqlDmoAppType = Type.GetTypeFromProgID("SQLDMO.Application");
object oSqlDmoApp = Activator.CreateInstance(oSqlDmoAppType);

object oSqlDmoListNames oSqlDmoAppType.InvokeMember("ListAvailableSQLServers",
BindingFlags.InvokeMethod,
null, oSqlDmoApp, new object[] {});

// Retrieve the number of available servers
Type oSqlDmoListNamesType = oSqlDmoListNames.GetType();

int nNumElementos = (int)
oSqlDmoListNamesType.InvokeMember("Count",
BindingFlags.GetProperty,
null, oSqlDmoListNames, new object[] {});

// Retrieve each SQL Server name
for (int i = 1; i <= nNumElementos; i++) {
object oSqlServer = oSqlDmoListNamesType.InvokeMember("Item",
BindingFlags.InvokeMethod,
null, oSqlDmoListNames, new object[] {i});

Console.WriteLine(oSqlServer.ToString());
}
}

}



Saludos
Pedro Luna, [MVP VB.NET]
Gye, Ecu