Re: List availalbe SQL Servers?


"Jouni Aro" <jouni.aro@xxxxxxxxx> ???????/???????? ? ???????? ?????????:
news:47eb5942$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Vitali Kalinin wrote:
I meant replace:
ProgIDToClassID('SQLOLEDB Enumerator')
with
ProgIDToClassID('SQLNCLI Enumerator').

OK, now I got it - and yes that makes it return the exact list I was
looking for (all local and available servers from the network)!

Thanks for yours feedback.

Do you have any links to other examples related to browsing the DB
information, in case I would like to find out which versions the servers
are and such? The docs at MSDN do not reveal anything very easily...

Probably there is better approach, but you can connect to Server and
than query for needed info using SERVERPROPERTY function.



.

Relevant Pages

  • Re: List availalbe SQL Servers?
    ... Vitali Kalinin wrote: ... ProgIDToClassID('SQLOLEDB Enumerator') ... now I got it - and yes that makes it return the exact list I was looking for (all local and available servers from the network)! ... than query for needed info using SERVERPROPERTY function. ...
    (borland.public.delphi.database.ado)
  • Re: How to find the databases on a server
    ... list all the servers on the network. ... list all the databases on any one server once it is clicked. ... the names of the servers, ... by the Enumerator, but this fails, apparently because the enumerator ...
    (microsoft.public.dotnet.framework.adonet)
  • How to find the databases on a server
    ... list all the servers on the network. ... list all the databases on any one server once it is clicked. ... the names of the servers, ... by the Enumerator, but this fails, apparently because the enumerator ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: List availalbe SQL Servers?
    ... ProgIDToClassID('SQLOLEDB Enumerator') ... in case I would like to find out which versions the servers ... then query fro needed info using SERVERPROPERTY function. ...
    (borland.public.delphi.database.ado)
  • SqlConnection.ConnectionString
    ... list all the servers on the network. ... list all the databases on any one server once it is clicked. ... the names of the servers, ... by the Enumerator, but this fails, apparently because the enumerator ...
    (microsoft.public.data.ado)