In SQL connection string i have to provide Initial Catalog and Data
Source. How can i read available initial catalogues when i know only the
given Data Source (for example "(local)\SQLEXPRESS")?

The InitialCatalog is the name of the database you want to access in your
SQLServer database, like "Northwind" or "pubs".

Robin S.
--------------------------------------------------
"Krys" <(E-Mail Removed)> wrote in message newsp.tnyuicq0kno4s0@krys...
> In SQL connection string i have to provide Initial Catalog and Data
> Source. How can i read available initial catalogues when i know only the
> given Data Source (for example "(local)\SQLEXPRESS")?

On Feb 19, 5:06 am, "RobinS" <Rob...@NoSpam.yah.none> wrote:
> The InitialCatalog is the name of the database you want to access in your
> SQLServer database, like "Northwind" or "pubs".
>
> Robin S.
> --------------------------------------------------
>
> "Krys" <i...@is.fake> wrote in messagenewsp.tnyuicq0kno4s0@krys...
> > In SQL connection string i have to provide Initial Catalog and Data
> > Source. How can i read available initial catalogues when i know only the
> > given Data Source (for example "(local)\SQLEXPRESS")?

Try with a query:
SELECT * FROM sys.databases

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Feb 19, 5:06 am, "RobinS" <Rob...@NoSpam.yah.none> wrote:
>> The InitialCatalog is the name of the database you want to access in
>> your
>> SQLServer database, like "Northwind" or "pubs".
>>
>> Robin S.
>> --------------------------------------------------
>>
>> "Krys" <i...@is.fake> wrote in messagenewsp.tnyuicq0kno4s0@krys...
>> > In SQL connection string i have to provide Initial Catalog and Data
>> > Source. How can i read available initial catalogues when i know only
>> > the
>> > given Data Source (for example "(local)\SQLEXPRESS")?
>
> Try with a query:
> SELECT * FROM sys.databases
>
What if you leave out the InitialCatalog phrase in the connection string?

Have you checked out http://www.connectionstrings.com to see if there's any
info that will help you there?

Robin S.

On Sun, 18 Feb 2007 23:38:26 +0100, Krys wrote:

> In SQL connection string i have to provide Initial Catalog and Data
> Source. How can i read available initial catalogues when i know only the
> given Data Source (for example "(local)\SQLEXPRESS")?

If i'm not wrong if you don't specify an initial calalog SQL server will
connect to the default database of the user specified in the connection
string
--
Bits.Bytes
http://bytes.thinkersroom.com