🚀 go-pugleaf

void GetServers(TStrings*Lista)
{
   LPSQLDMOAPPLICATION pDMOApp = NULL;
	LPSQLDMONAMELIST pNameList = NULL;
   Lista->Clear();
   try{
		if SUCCEEDED(CoInitialize (NULL)){
   	  // Crear SQLDMOApplication.
		  if SUCCEEDED(CoCreateInstance(CLSID_SQLDMOApplication,
                                     NULL,
                                     CLSCTX_INPROC_SERVER,
                                     IID_IWSQLDMOApplication,
                                     (LPVOID*)&pDMOApp))
       {
         // Consultar lista de servidores
		    if SUCCEEDED(pDMOApp->ListAvailableSQLServers(&pNameList)){
			    long lCount=0;
			    BSTR strName=NULL;
			    //Numero de servidores
			    pNameList->GetCount(&lCount);

			    for(long i=0; i < lCount; i++){
				    //Nombre del servidor
				    pNameList->GetItemByOrd(i, &strName);
				    Lista->Add(strName);
			    }
		    }
		    if (pDMOApp){
			    pNameList = NULL;
			    pDMOApp->Release();
			    pDMOApp = NULL;
		    }
       }
     }
   }
   catch(...){
   }
}


You need this header files
#include <initguid.h>
#include <sqldmoid.h>
#include <sqldmo.h>

This I'm not sure.
#include <utilcls.h>


Thomas Goodson escribi�:
> I didn't get a response in sqlservers, so I thought I'd try here.
> 
> Ok, I've got an application that works fine, but as part of deployment, I
> need to find all of the available MS-SQL / MSDE servers on the network and
> present a list to the installer.  (the list part I can handle)  I'm using
> ADO in the form of dbGo in BDS 2006 C++ mode.
> 
> I really don't want to use PromptDataSource since it offers the user WAY to
> many ways to shoot themselves in the foot.  (also, the database won't have
> been created yet).
> 
> So, how do I find the available SQL servers?
> 
> ** Tom **
> 
> 
>