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

Click here to load this message in the networking platform