Available "Initial Catalog" in given Data Source (sql)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Krys - 18 Feb 2007 22:38 GMT

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")?

Reply to this Message

RobinS - 19 Feb 2007 04:06 GMT

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

Robin S.
--------------------------------------------------

> 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")?

Reply to this Message

oscar.acostamontesde@googlemail.com - 19 Feb 2007 09:37 GMT

> The InitialCatalog is the name of the database you want to access in your
> SQLServer database, like "Northwind" or "pubs".
[quoted text clipped - 5 lines]
> > 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 ;)

Reply to this Message

RobinS - 19 Feb 2007 15:46 GMT

>> The InitialCatalog is the name of the database you want to access in
>> your
[quoted text clipped - 10 lines]
> 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.

Reply to this Message

Rad [Visual C# MVP] - 26 Feb 2007 18:28 GMT

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

Signature

Bits.Bytes
http://bytes.thinkersroom.com

Reply to this Message

Rate this thread:

Available "Initial Catalog" in given Data Source (sql)

Free Magazines