How have a list with all the SQL server in my entire network?

[dicolas]

Hi,
I would like to automatically create an ODBC DSN.
But I don't know how to retrieve the available SQL server in my network (such as the list you can find into the ODBC Data Source Administrator.)

Thanks for your help.
Dicolas.

 

[Cocheez]

Hey there, when you install SQLDMO on your machine, usually installs with the desktop edition of SQL Server on a development machine, you get access to some new methods and properties through the Application object. Using both the Application object and SQLDMO in your application you should be able to gather the SQL servers that are network-visable. Here is the code I used.


Dim i As Integer
Dim oNL As NameList

Set oNL = Application.ListAvailableSQLServers
For i = 0 To oNL.Count
Debug.Print oNL.Item(i)
Next i


Work great for me.

MattU

 

[dicolas]

thank you very much.

Have a nice day. Mine is beginning fine.

Hi MattU