Re: List availalbe SQL Servers?

Vitali Kalinin wrote:
"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.

Least I could do :)

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.

OK, thanks, I will try that if it becomes required!
.

Relevant Pages

  • Re: List availalbe SQL Servers?
    ... ProgIDToClassID('SQLOLEDB Enumerator') ... in case I would like to find out which versions the servers ... than query for needed info using SERVERPROPERTY function. ...
    (borland.public.delphi.database.ado)
  • Re: List availalbe SQL Servers?
    ... Vitali Kalinin wrote: ... ProgIDToClassID('SQLOLEDB Enumerator') ... looking for (all local and available servers from the network)! ... 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? ...
    (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)