Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
List of SQL Servers
Message
De
21/04/2003 14:40:54
 
 
À
21/04/2003 13:58:08
Peter Wagner
Point Informática Ltda.
Limeira, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00779753
Message ID:
00779918
Vues:
26
I know this. I already have this. I want to get the list without using SQL-DMO.

>Dan,
>You can get a list of all SQL Servers in the network using SQL-DMO
>and you dont have to be conected to the server.
>
>This code returns all the SQL-Servers.
>
>LOCAL oSQLApp AS SQLDMO.APPLICATION
>oSQLApp = CREATEOBJECT('SQLDMO.Application')
>
>LOCAL oServers AS SQLDMO.SQLServers 		
>* lista os Servidores disponiveis
>oServers = oSQLApp.ListAvailableSQLServers
>FOR i = 1 TO oServers.COUNT
>	? ALLTRIM(oServers.ITEM(i)), i
>ENDFOR
>
>
>If you dont get an answer for servers in the network, you have to set Cliconfg in DOS prompt,
>so set the necessary options in "Client Network Utility", this gives you options to config how the client can "see" the server. It depends on network, firewall, etc...
>This way you can use SQL-DMO
>
>Peter
Thanks,
Dan Jurden
djurden@outlook.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform