Finding SQL-servers in a network

[Georg Kreyerhoff]

Hi,

We have an ODBC/Visual-C++-6 -bases application (currently working with both MS-Access and Postgres)
and want it to also cooperate with MS-SQL-server and MSDE. Since we don't want the
user to wade through the ugly ODBC-setup, we have our own dialogs (e.g. the usual
file dialog for MS-Access) and build the ODBC-connection string from the information provided
by them. Now, the MS-SQL-Driver dialog has the nice feature to browse the network for
available SQL-server instances and I like to have it, too. Is there some
function for retrieving a list of available SQL-servers anywhere?

Georg

[John Bell]

Re: Finding SQL-servers in a network

Hi

I think you are probably looking for SQLBrowseConnec t function

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odch06pr_16.asp

John


"Georg Kreyerhoff" <georg@kreyerho ff.de> wrote in message
news:3F535EE7.1 0105@kreyerhoff .de...[color=blue]
> Hi,
>
> We have an ODBC/Visual-C++-6 -bases application (currently working with[/color]
both MS-Access and Postgres)[color=blue]
> and want it to also cooperate with MS-SQL-server and MSDE. Since we don't[/color]
want the[color=blue]
> user to wade through the ugly ODBC-setup, we have our own dialogs (e.g.[/color]
the usual[color=blue]
> file dialog for MS-Access) and build the ODBC-connection string from the[/color]
information provided[color=blue]
> by them. Now, the MS-SQL-Driver dialog has the nice feature to browse the[/color]
network for[color=blue]
> available SQL-server instances and I like to have it, too. Is there some
> function for retrieving a list of available SQL-servers anywhere?
>
> Georg
>[/color]

[Georg Kreyerhoff]

Re: Finding SQL-servers in a network

John Bell wrote:[color=blue]
> Hi
>
> I think you are probably looking for SQLBrowseConnec t function
>
> http://msdn.microsoft.com/library/de...dch06pr_16.asp
>
> John
>
>[/color]
Thanks, works perfectly.

Georg