Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List of SQL Servers
Message
From
21/04/2003 14:40:54
 
 
To
21/04/2003 13:58:08
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00779753
Message ID:
00779918
Views:
27
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
Previous
Reply
Map
View

Click here to load this message in the networking platform