SQL Server 2005 and ADO.NET 1.1?

[Guest]

Is possible to connect to SQL 2005 from ADO.NET 1.1? I need to migrate our
system from SQL Server 2000 to SQL 2005 duo license politics in our client
company. I need to know if is possible to connect to SQL Server 2005 using
..NET Framework 1.1 (ADO.NET) or i need to migrate our application to newer
version of .NET. I will be happy if it is possible becouse there is no budget
for next programming.

Thanx

Stepan

 

[Marina]

Yes, it should work fine.

Wouldn't it be faster to test it, then to post here? It should take all of 1
minute to write a little test program to see if it works, and even less time
to just change the connection information for your software to connect to a
SQL 2005 server.

 

[Guest]

Thank you for your reply. I wrote little test, but our project is very huge
with some specialities like extended procedures and Im not sure for 100% if
it will works properly. I made migration using attaching mdf files and
alllooks fine. From morning Im testing application with the SQL 2005. I hope
It will works.

Thanx for your response

Stepan

 

[Cowboy \(Gregory A. Beamer\)]

1. Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools
2. Open Sql Server 2005 Network Configuration >> Protocols for SQL2005

3. By default, only Shared Memory is turned on. You will likely need named
pipes for a local server and TCP/IP for remote

4. If you are accessing remotely, you need to turn on SQL Server Browser, as
well (under SQL Server 2005 Services)

5. Restart SQL Server 2005

You should now be able to access from non 2.0 systems.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************