469,336 Members | 5,846 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

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.
Nov 17 '05 #1
2 1633
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.

Nov 17 '05 #2
ad
If the usrs' computer have just one vesion of Sql2005,
can we omit <SQLInstanceName>
"Ashish Kaila" <as*********@nospam.com> glsD: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.


Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by ad | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.