Enumerating instances without DMO

[Bishman]

Can anyone suggest a method of enumerating instances of MSDE 2000 without
using DMO ?

Using C++, MFC, and ADO.

Thanks

[Simon Hayes]

See questions 12 and 13:

http://support.microsoft.com/default...&Product=sql2k

If you need to enumerate instances externally (ie without access to the
server's registry), then SQLDMO may still be the best option - see the
ListAvailableSQLServers method. Also see here:

http://www.sqldev.net/misc/ListSQLSvr.htm

Simon

[Bishman]

Simon,

Many thanks. I feel a bit foolish as I trawled through that document,
although it was a few years ago...

I have not got satisfactory results from 'ListAvailableSQLServers'. Function
returns OK but the resulting loop yields only 1 server, I have two
instances. Never mind, the registry is fine for my needs and a lot simpler.

Cheers

Jon.
"Simon Hayes" <sq*@hayes.ch> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

See questions 12 and 13:

http://support.microsoft.com/default...&Product=sql2k

If you need to enumerate instances externally (ie without access to the
server's registry), then SQLDMO may still be the best option - see the
ListAvailableSQLServers method. Also see here:

http://www.sqldev.net/misc/ListSQLSvr.htm

Simon