How to determinate the version Sql2005

[ad]

The user of my asp.net program use Sql2005 or Sql2005 express as database,
both are possible.

I have try both version of data base, I found:
If I use Sql2005 express, the Data Source in connection string will be
..\SQLEXPRESS, like:
Data Source=.\SQLEXPRESS;Initial Catalog=myDB;Integrated Security=True

But I use Sql2005 , the Data Source in connection string can be use
(local), like:
Data Source(local);Initial Catalog=myDB;Integrated Security=True

My questions are:

1.Is it possible use the some connection string with both version of
DataBase.

2. If question 1 is impossible, how to determinate the version of Sql2005?
I want to composite the connection string with program.

[Ashish Kaila]

Hello,
I think if you use the format <Server>\<SQLInstanceName> it will work on any
edition of sql server.
Thanks,
Ashish

"ad" <fl****@wfes.tcc.edu.tw> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

The user of my asp.net program use Sql2005 or Sql2005 express as database,
both are possible.

I have try both version of data base, I found:
If I use Sql2005 express, the Data Source in connection string will be
.\SQLEXPRESS, like:
Data Source=.\SQLEXPRESS;Initial Catalog=myDB;Integrated Security=True

But I use Sql2005 , the Data Source in connection string can be use
(local), like:
Data Source(local);Initial Catalog=myDB;Integrated Security=True

My questions are:

1.Is it possible use the some connection string with both version of
DataBase.

2. If question 1 is impossible, how to determinate the version of
Sql2005? I want to composite the connection string with program.

[ad]

If the usrs' computer have just one vesion of Sql2005,
can we omit <SQLInstanceName>
"Ashish Kaila" <as*********@nospam.com> ¼¶¼g©ó¶l¥ó·s»D:us**************@TK2MSFTNGP15.phx.g bl...

Hello,
I think if you use the format <Server>\<SQLInstanceName> it will work on
any edition of sql server.
Thanks,
Ashish

"ad" <fl****@wfes.tcc.edu.tw> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

The user of my asp.net program use Sql2005 or Sql2005 express as
database, both are possible.

I have try both version of data base, I found:
If I use Sql2005 express, the Data Source in connection string will be
.\SQLEXPRESS, like:
Data Source=.\SQLEXPRESS;Initial Catalog=myDB;Integrated Security=True

But I use Sql2005 , the Data Source in connection string can be use
(local), like:
Data Source(local);Initial Catalog=myDB;Integrated Security=True

My questions are:

1.Is it possible use the some connection string with both version of
DataBase.

2. If question 1 is impossible, how to determinate the version of
Sql2005? I want to composite the connection string with program.