From ADO.NET 1.1 to SQL 2005 and SQL 2008

Dear Sirs.

I have Client Server Application
on Client Side i have .NET 1.1 WinForm Application
on Server Side i have SQL Server 2000

I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access

1)

I'd like to upgrade Server Side to SQL Server 2005 (I will copy same database with users to sql2005)

Should i update Clients to .NET 2.0 too ?
Do i need install Native Client Lib on Client ?

2)

when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?

Thank you in Advance.

Should i update Clients to .NET 2.0 too ?

You don′t need to, for better reliability and without any further test and turning on the whole testing machine, I would use the 1.1 Fw.

Do i need install Native Client Lib on Client ?

You don′t need to but can do this.

2)

when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?

Yes, thats the plan (Even if you use OLEDB providers) :-)

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I'm using SQL Data Provider in Name space System.Data.SqlClient

|||dito.|||What do you mean ? in word "dito" ?|||The same applies for SQLClient