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.

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

"Irakli Lomidze"  wrote in message 
news:9A3911F5-2294-4E00-92B8-9CE068730604@microsoft.com...

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