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]

Hi

I think you are probably looking for SQLBrowseConnect function

http://msdn.microsoft.com/library/de...dch06pr_16.asp

John
"Georg Kreyerhoff" <ge***@kreyerhoff.de> wrote in message
news:3F************@kreyerhoff.de...

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

[Georg Kreyerhoff]

John Bell wrote:

Hi

I think you are probably looking for SQLBrowseConnect function

http://msdn.microsoft.com/library/de...dch06pr_16.asp

John

Thanks, works perfectly.

Georg