SQL Server 7 and ADO.NET

[LaRhonda Johnson]

I am starting a .NET project and am wondering if anyone has experience with
using ADO.NET to access a SQL Server 7/NT server. If so, were there any
issues?

 

[Sahil Malik]

Why not SQL Server 2000? If licensing is an issue, have you checked out
MSDE?

- Sahil Malik
You can reach me thru my blog -
http://www.dotnetjunkies.com/weblog/sahilmalik

 

[LaRhonda Johnson]

Sahil,

Thank you for your response. I work for a large corporation that has
standard builds for our servers. We currently have an NT 4 DB server and our
DBA's are only supporting SQL Server 2000 builds now for Win2K and greater.
And of course given the hardware configuration of our DB server and our LAN
services folks require that we upgrade our existing hardware before
upgrading our OS. So we would have to purchase a new server to upgrade to
SQL Server 2000 and are trying to avoid that cost at this time. As for MSDE,
we have a very complex database using views, DTS, SQL jobs ect., and I got
the impression that MSDE did not offer all of the features as SQL Server
2000.

 

[William \(Bill\) Vaughn]

MSDE supports views and you can execute DTS and run SQL jobs against it.
However, the SqlClient provider in .NET can connect to SQL Server 7.0 and
later.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

 

[LaRhonda Johnson]

MSDE supports views and you can execute DTS and run SQL jobs against it.
However, the SqlClient provider in .NET can connect to SQL Server 7.0 and
later.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

 

[LaRhonda Johnson]

Bill thanks. So you do have experience with using Visual Basic.NET to access
SQL Server 7?