Thursday, March 29, 2012

Enumerating instances without DMO

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

Using C++, MFC, and ADO.

ThanksSee questions 12 and 13:

http://support.microsoft.com/defaul...6&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|||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" <sql@.hayes.ch> wrote in message
news:1118213082.991451.13250@.f14g2000cwb.googlegro ups.com...
> See questions 12 and 13:
> http://support.microsoft.com/defaul...6&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
> Simonsql

No comments:

Post a Comment