List of SQL Servers Available in a network

  • Thread starter Thread starter João Santa Bárbara
  • Start date Start date
J

João Santa Bárbara

Hi all
i need to do a search to all my network to find the SQL servers active, but
i don´t want to use SQLDMO. is there another way to do it ???

THKS

JSB
 
mdb said:
:) Haha

What do you want?? Its also dependent on having a network connected! :)

The problem with this is that OP doesn't mention why he doesn't want to use
SQLDMO, now using ODBC he needs to PInvoke 4 API's, while a simple PInvoke
of a single Win32 API "NetServerEnum" could be used to get all SQL servers
in the network without any dependency at all.


Willy.
 
The problem with this is that OP doesn't mention why he doesn't want
to use SQLDMO, now using ODBC he needs to PInvoke 4 API's, while a
simple PInvoke of a single Win32 API "NetServerEnum" could be used to
get all SQL servers in the network without any dependency at all.

Good information... I provided an answer - and the only one I knew at the
time - never said it was the best answer! :)
 
The problem with this is that OP doesn't mention why he doesn't want
to use SQLDMO, now using ODBC he needs to PInvoke 4 API's, while a
simple PInvoke of a single Win32 API "NetServerEnum" could be used to
get all SQL servers in the network without any dependency at all.

Good information... I provided an answer - and the only one I knew at the
time - never said it was the best answer! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top