OleDbEnum  

Home
Up
What's New
DTS
SQL-DMO
SQL-NS
XP's
SQL Agent
Events
FAQ
Links
About...

 

OleDbEnum.exe - Enumerate SQL Servers using OLE-DB

version: 1.0x001

last updated: 1 February  2003

platform: SQL Server 2000 running Windows NT 4.0 and higher

Description:

Enumerate SQL Server instances on the network using the OLE-DB CLSID_SQLOLEDB_ENUMERATOR.

 

This sample shows how to use the SQL enumerator, part of the SQL Server OLE-DB provider to retrieve instances of SQL Server available on the network.

 

The OLE-DB enumerator relies on the same UDP broadcast technique as the ODBC SQLBrowseConnect implementation. This means it will never be able to return a conclusive or complete list of SQL Server instances because:

  • Instances that are not up and running do not respond to the discovery broadcast. Only one instance has to be up on a machine, it can respond for all instances on a machine

  • Instances might respond after the timeout, which will exclude there response from the list

  • Instances might not be listening on the correct protocol, so will never receive the discovery broadcast

  • Network infrastructure, especially routers, might limit the effect/visibility of the broadcast, since most routers are configure not to relay broadcast request to the other side of the router.

NOTE: The OLE-DB implementation can not return any of the extended information, like SQLBrowseConnect can.

Installation:

Simply copy OleDbEnum.exe onto your machine.

Download OleDbEnum.zip

Download OleDbEnum-src.zip (Visual C++ 7.0 project)

Requirements:

MDAC 2.6 or higher, which is the MDAC version that is shipping with SQL Server 2000.

Planned functionality enhancements:

  • None
     

  • Other suggestions, ideas, please send email to ideas

***

Questions or problems regarding this web site should be directed to webmaster@sqldev.net.
Copyright © 1991-2003 SQLDev.Net. All rights reserved.
Last modified: 07/06/03.