dotnet 2003 with sql express 2005

[Guest]

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

a> I have a problem connecting .net 2003 (framework 1.1) with
a> sql express 2005 (framework 2.0)
a> What is the problem:
a> definitions 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

 

[Guest]

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]

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?

a> I tryed to add connection to server explorer in visual studio,
a> When I press test connection its ok,
a> but when I press ok (to add connection) it gives an error.
a> I know that .net 2003 can connect sql 2005 in case they both work
a> with framework 1.1
a>
a> In my case .net works with 1.1 and sql express works with 2.0.
a>
a> "Michael Nemtsev" wrote:
a>---
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

 

[Guest]

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).

 

[Guest]

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

 

[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

a> I Installed the .net 2005 In this version there is no problem adding
a> connection to server explorer.
a>
a> "aaa" wrote:
a>---
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 Nietzsch

 

[Guest]

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.