Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detecting SQL Servers
Message
From
11/02/1999 08:55:39
Ed Rauh
Trumbull, Connecticut, United States
 
 
To
11/02/1999 08:33:42
Bob Tracy
Independent Consultant
Driftwood, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Title:
Re: Detecting SQL Servers
Miscellaneous
Thread ID:
00186452
Message ID:
00186462
Views:
24
>Does anyone know how to detect the active SQL Servers in a domain? In SQL Server you can show the active servers in the dialog used for registering server groups so there must be an API call somewhere. TIA

You might look into using WNetOpenEnum() and WNetEnumResource() - I haven't tried finding SQL Server instances with it, so I don't know what would be involved in isaolating them in the list of all available shared resources on a given network.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform