dotnet 2003 with sql express 2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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.
 
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
 
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).
 
I Installed the .net 2005
In this version there is no problem adding connection to server explorer.
 
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
 
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.
 
Back
Top