From ADO.NET 1.1 to SQL 2005 and SQL 2008

[Guest]

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.

 

[William Vaughn]

While there are some very competent women on this list (that you have
probably offended), I will attempt to answer:

Your client applications written for SQL Server 2000 (SS2K) should be able
to access SS2K5 without many issues. I expect most of your issues will
involve getting connected. The database you migrate to SS2K5 will run in
"compatibility" mode (8.0) until it is converted. Should you migrate to
ADO.NET 2.0? Well, there are a number of useful features in this
implementation, but unless you have some compelling need for those features
(or you are being paid by the hour), I suggest trying to get the old
applicaiton to work.

The SQL Native Client is important and it should be used to access SS2K5 but
using OLE DB to access SS (any version) is problematic. There are
performance issues along with a number of features that make programming
easier.

We have not seen a shipping version of SS2K8 but I expect you won't see many
issues--especially if you use the native SQLClient provider--but that would
require a re-write of your client application.

These issues are discussed in detail in my book.

--
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)