dotnet 2003 with sql express 2005

[aaa]

I have a problem connecting .net 2003 (framework 1.1) with
sql express 2005 (framework 2.0)
What is the problem:
definitions or compatibility?

[Michael Nemtsev]

Hello aaa,

What kind of problems?
Which connection provided did you try? SQL Native connection, SQLServer or
just OLEDB?

I've used VS 2003 + SQL Express 2005 numbers of time

aI have a problem connecting .net 2003 (framework 1.1) with
asql express 2005 (framework 2.0)
aWhat is the problem:
adefinitions or compatibility?

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[aaa]

I tryed to add connection to server explorer in visual studio,
When I press test connection its ok,
but when I press ok (to add connection) it gives an error.

I know that .net 2003 can connect sql 2005 in case they both work with
framework 1.1

In my case .net works with 1.1 and sql express works with 2.0.


"Michael Nemtsev" wrote:

Hello aaa,

What kind of problems?
Which connection provided did you try? SQL Native connection, SQLServer or
just OLEDB?

I've used VS 2003 + SQL Express 2005 numbers of time

aI have a problem connecting .net 2003 (framework 1.1) with
asql express 2005 (framework 2.0)
aWhat is the problem:
adefinitions or compatibility?

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Michael Nemtsev]

Hello aaa,

try this
Server name: (local)\SQLExpress
Security: Windows integrated
Attach DB file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf
(or any available)

then press OK and everything ok

If smth wrong could you specify error description?

aI tryed to add connection to server explorer in visual studio,
aWhen I press test connection its ok,
abut when I press ok (to add connection) it gives an error.
aI know that .net 2003 can connect sql 2005 in case they both work
awith framework 1.1
a>
aIn my case .net works with 1.1 and sql express works with 2.0.
a>
a"Michael Nemtsev" wrote:
a>

>Hello aaa,

What kind of problems?
Which connection provided did you try? SQL Native connection,
SQLServer or
just OLEDB?
I've used VS 2003 + SQL Express 2005 numbers of time

aI have a problem connecting .net 2003 (framework 1.1) with
asql express 2005 (framework 2.0)
aWhat is the problem:
adefinitions or compatibility?
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its opponents
do not cease to be insipid." (c) Friedrich Nietzsche

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[aaa]

Thank you for your answer.

However it didn't solve the problem because now it gives the error:
unable to open the physical file...
Test connection also gives this error unlike the previous way of connecting.
(so connection can not be added to server explorer).
"Michael Nemtsev" wrote:

Hello aaa,

try this
Server name: (local)\SQLExpress
Security: Windows integrated
Attach DB file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf
(or any available)

then press OK and everything ok

If smth wrong could you specify error description?

aI tryed to add connection to server explorer in visual studio,
aWhen I press test connection its ok,
abut when I press ok (to add connection) it gives an error.
aI know that .net 2003 can connect sql 2005 in case they both work
awith framework 1.1
a>
aIn my case .net works with 1.1 and sql express works with 2.0.
a>
a"Michael Nemtsev" wrote:
a>

Hello aaa,

What kind of problems?
Which connection provided did you try? SQL Native connection,
SQLServer or
just OLEDB?
I've used VS 2003 + SQL Express 2005 numbers of time

aI have a problem connecting .net 2003 (framework 1.1) with
asql express 2005 (framework 2.0)
aWhat is the problem:
adefinitions or compatibility?
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its opponents
do not cease to be insipid." (c) Friedrich Nietzsche

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[aaa]

I Installed the .net 2005
In this version there is no problem adding connection to server explorer.

"aaa" wrote:

Thank you for your answer.

However it didn't solve the problem because now it gives the error:
unable to open the physical file...
Test connection also gives this error unlike the previous way of connecting.
(so connection can not be added to server explorer).
"Michael Nemtsev" wrote:

Hello aaa,

try this
Server name: (local)\SQLExpress
Security: Windows integrated
Attach DB file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf
(or any available)

then press OK and everything ok

If smth wrong could you specify error description?

aI tryed to add connection to server explorer in visual studio,
aWhen I press test connection its ok,
abut when I press ok (to add connection) it gives an error.
aI know that .net 2003 can connect sql 2005 in case they both work
awith framework 1.1
a>
aIn my case .net works with 1.1 and sql express works with 2.0.
a>
a"Michael Nemtsev" wrote:
a>

>Hello aaa,
>>
>What kind of problems?
>Which connection provided did you try? SQL Native connection,
>SQLServer or
>just OLEDB?
>I've used VS 2003 + SQL Express 2005 numbers of time
>>
>aI have a problem connecting .net 2003 (framework 1.1) with
>asql express 2005 (framework 2.0)
>aWhat is the problem:
>adefinitions or compatibility?
>---
>WBR,
>Michael Nemtsev :: blog: http://spaces.msn.com/laflour
>"At times one remains faithful to a cause only because its opponents
>do not cease to be insipid." (c) Friedrich Nietzsche
>>

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Michael Nemtsev]

Hello aaa,

Smth wrong with you machine/studio/sqlserver, coz as I said I have no problems
with using SQL2005 via VS 2003

aI Installed the .net 2005 In this version there is no problem adding
aconnection to server explorer.
a>
a"aaa" wrote:
a>

>Thank you for your answer.

However it didn't solve the problem because now it gives the error:
unable to open the physical file...
Test connection also gives this error unlike the previous way of
connecting.
(so connection can not be added to server explorer).
"Michael Nemtsev" wrote:

>>Hello aaa,

try this
Server name: (local)\SQLExpress
Security: Windows integrated
Attach DB file: C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.md f
(or any available)
then press OK and everything ok

If smth wrong could you specify error description?

aI tryed to add connection to server explorer in visual studio,
aWhen I press test connection its ok,
abut when I press ok (to add connection) it gives an error.
aI know that .net 2003 can connect sql 2005 in case they both work
awith framework 1.1
a>
aIn my case .net works with 1.1 and sql express works with 2.0.
a>
a"Michael Nemtsev" wrote:
a>
Hello aaa,
>
What kind of problems?
Which connection provided did you try? SQL Native connection,
SQLServer or
just OLEDB?
I've used VS 2003 + SQL Express 2005 numbers of time
aI have a problem connecting .net 2003 (framework 1.1) with
asql express 2005 (framework 2.0)
aWhat is the problem:
adefinitions or compatibility?
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its
opponents
do not cease to be insipid." (c) Friedrich Nietzsche
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its opponents
do not cease to be insipid." (c) Friedrich Nietzsche

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[aaa]

I know that 2003 works with sql 2005, but I don't know what is the problem.
Maybe its because I have a learning version not professional (I'm not sure).
I dont think the problem is with sql server because it works with dot.net
2005.

"Michael Nemtsev" wrote:

Hello aaa,

Smth wrong with you machine/studio/sqlserver, coz as I said I have no problems
with using SQL2005 via VS 2003

aI Installed the .net 2005 In this version there is no problem adding
aconnection to server explorer.
a>
a"aaa" wrote:
a>

Thank you for your answer.

However it didn't solve the problem because now it gives the error:
unable to open the physical file...
Test connection also gives this error unlike the previous way of
connecting.
(so connection can not be added to server explorer).
"Michael Nemtsev" wrote:

Hello aaa,

try this
Server name: (local)\SQLExpress
Security: Windows integrated
Attach DB file: C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.m df
(or any available)
then press OK and everything ok

If smth wrong could you specify error description?

aI tryed to add connection to server explorer in visual studio,
aWhen I press test connection its ok,
abut when I press ok (to add connection) it gives an error.
aI know that .net 2003 can connect sql 2005 in case they both work
awith framework 1.1
a>
aIn my case .net works with 1.1 and sql express works with 2.0.
a>
a"Michael Nemtsev" wrote:
a>
Hello aaa,

What kind of problems?
Which connection provided did you try? SQL Native connection,
SQLServer or
just OLEDB?
I've used VS 2003 + SQL Express 2005 numbers of time
aI have a problem connecting .net 2003 (framework 1.1) with
asql express 2005 (framework 2.0)
aWhat is the problem:
adefinitions or compatibility?
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its
opponents
do not cease to be insipid." (c) Friedrich Nietzsche
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour
"At times one remains faithful to a cause only because its opponents
do not cease to be insipid." (c) Friedrich Nietzsche

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche