How to find sql servers on lan

Article View: borland.public.cppbuilder.database.ado

Article #293

Back to borland.public.cppbuilder.database.ado Previous Next

#293

From: Thomas Goodson
Date: Fri, 16 Jun 2006 21:07

14 lines
1530 bytes

I didn't get a response in sqlservers, so I thought I'd try here.

Ok, I've got an application that works fine, but as part of deployment, I
need to find all of the available MS-SQL / MSDE servers on the network and
present a list to the installer.  (the list part I can handle)  I'm using
ADO in the form of dbGo in BDS 2006 C++ mode.

I really don't want to use PromptDataSource since it offers the user WAY to
many ways to shoot themselves in the foot.  (also, the database won't have
been created yet).

So, how do I find the available SQL servers?

** Tom **

Technical Details

Message-ID: <44931de5@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.inode.at!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,13a074f07b8e690,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Thomas Goodson" <thomas_nospam.goodson@omega-link.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to find sql servers on lan
Date: Fri, 16 Jun 2006 17:07:50 -0400
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 69.209.102.157
Message-ID: <44931de5@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1150492133 69.209.102.157 (16 Jun 2006 14:08:53 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.inode.at!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail