List of SQL Servers Available in a network

[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]

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

http://www.codeproject.com/cs/database/SubmitSQLInfoEnumerator.asp

 

[Willy Denoyette [MVP]]

http://www.codeproject.com/cs/database/SubmitSQLInfoEnumerator.asp

Waw .... removing SQLDMO dependency in favor of ODBC dependency!.

Willy.

 

[mdb]

Waw .... removing SQLDMO dependency in favor of ODBC dependency!.

Haha

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

 

[Willy Denoyette [MVP]]

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.

 

[mdb]

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!

 

[mdb]

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!