windwos API to list mssql servers in network

Question

windwos API to list mssql servers in network

deenadayalan

Say Hey Kid

Points: 670
More actions
May 9, 2006 at 7:27 am

#68219

hi all,
I found that osql /L would give the list of mssql server instances in the network, but i need a windows API or ODBC method to get it to implement in an application rather than a command mode utility.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246873 More actions · Answer 1

What is your question?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

deenadayalan Say Hey Kid Points: 670 More actions · Answer 2

If i need to find all mssql server instances installed in a network,

I could get this by typing osql /L.

But i would like to list the names of different mssql server instances

programatically to implement in an application using WinAPI

Phil Parkin SSC Guru Points: 246873 More actions · Answer 3

Not sure. Could you do something like

osql /L > sqlservers.txt

to redirect the output to a file called sqlservers.txt and then use that in your app?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

deenadayalan Say Hey Kid Points: 670 More actions · Answer 4

Fine, Thanx

But then I would appreciate if i could get direct ways

-deena

Gary Harpin Valued Member Points: 57 More actions · Answer 5

There is an article on “The Code Project” that may be of use.

Enumerate SQL Server using SQL DMO

By Rashid Thadha

Get a list of SQL Servers to which you can connect.

http://www.codeproject.com/database/serverenum.asp

Nick Subocz SSC Veteran Points: 256 More actions · Answer 6

Hi,

I've got some Delphi code that'll get a list of SQL Servers on your network if you want it.

deenadayalan Say Hey Kid Points: 670 More actions · Answer 7

Thanks for everyone those who have replied

I trying to work thro' SQLBrowseConnect of ODBC.

regards

deena

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 8

Don't think that this list will be authoritative in all cases on all networks. There are lots of reasons why all of the SQL Servers on a network potentially will not show up with "OSQL -L". Here's a few for starters:

routing
network segmentation
switched network
firewalls
IPsec
policy
domains
trust

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Greg Jennings SSC Enthusiast Points: 175 More actions · Answer 9

Have you tried SQL-DMO? What is your development environment?

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 10

Whether you use a Windows API, ODBC or SQL DMO the information in my previous post still stands.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

deenadayalan Say Hey Kid Points: 670 More actions · Answer 11

hi

I am using ODBC to connect the db with VC++

I have not tried SQL DMO. Do I able to list the servers without connecting to the server in local machine.

thanx

deena

Greg Jennings SSC Enthusiast Points: 175 More actions · Answer 12

Here is sample VB code to display all available SQL servers:

Dim i As Integer

For i = 1 To SQLDMO.ListAvailableSQLServers.Count

MsgBox SQLDMO.ListAvailableSQLServers(i)

Next i