Re: SqlConnection.ConnectionString
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2007 13:46:56 -0400
Dom wrote:
I'm trying to write an all-purpose program that will:
1. list all the servers on the network.
2. list all the databases on any one server once it is clicked.
3. list all the tables in a database once it is clicked.
4. list all the columns in a table once it is clicked.
The first step I can do with SqlDataSourceEnumerator. But I get only
the names of the servers, not the instance names.
My intention was to call SqlConnection.Open() on each server returned
by the Enumerator, but this fails, apparently because the enumerator
returns the name "CASSIUS" and not "CASSIUS\SQLEXPRESS".
There was no way for you to know it (except maybe by browsing through
some of the previous questions in this newsgroup before posting yours -
always a recommended practice) , but this is a classic ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may
be lucky enough to find a dotnet-knowledgeable person here who can
answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.adonet.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- SqlConnection.ConnectionString
- From: Dom
- SqlConnection.ConnectionString
- Prev by Date: SqlConnection.ConnectionString
- Next by Date: Re: Accessing Exchange Data with ADO
- Previous by thread: SqlConnection.ConnectionString
- Next by thread: ODBC Connection returns no Data
- Index(es):
Relevant Pages
|
|
