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?

Re: SQL Server 7 and ADO.NET by Sahil

Sahil
Thu Sep 30 00:13:49 CDT 2004

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" <larhondajohnson@yahoo.com> wrote in message
news:e6Y$iLqpEHA.3988@tk2msftngp13.phx.gbl...
>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?
>
>



Re: SQL Server 7 and ADO.NET by LaRhonda

LaRhonda
Thu Sep 30 07:25:30 CDT 2004

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.

"Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
news:ufEKGxqpEHA.3424@TK2MSFTNGP11.phx.gbl...
> 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" <larhondajohnson@yahoo.com> wrote in message
> news:e6Y$iLqpEHA.3988@tk2msftngp13.phx.gbl...
> >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?
> >
> >
>
>



Re: SQL Server 7 and ADO.NET by William

William
Thu Sep 30 12:21:49 CDT 2004

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" <larhondajohnson@yahoo.com> wrote in message
news:%23AsUZiupEHA.3524@TK2MSFTNGP15.phx.gbl...
> 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.
>
> "Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
> news:ufEKGxqpEHA.3424@TK2MSFTNGP11.phx.gbl...
>> 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" <larhondajohnson@yahoo.com> wrote in message
>> news:e6Y$iLqpEHA.3988@tk2msftngp13.phx.gbl...
>> >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?
>> >
>> >
>>
>>
>
>



Re: SQL Server 7 and ADO.NET by LaRhonda

LaRhonda
Fri Oct 01 14:27:11 CDT 2004


"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:edHT5HxpEHA.3712@TK2MSFTNGP15.phx.gbl...
> 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" <larhondajohnson@yahoo.com> wrote in message
> news:%23AsUZiupEHA.3524@TK2MSFTNGP15.phx.gbl...
> > 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.
> >
> > "Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
> > news:ufEKGxqpEHA.3424@TK2MSFTNGP11.phx.gbl...
> >> 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" <larhondajohnson@yahoo.com> wrote in message
> >> news:e6Y$iLqpEHA.3988@tk2msftngp13.phx.gbl...
> >> >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?
> >> >
> >> >
> >>
> >>
> >
> >
>
>



Re: SQL Server 7 and ADO.NET by LaRhonda

LaRhonda
Fri Oct 01 14:42:36 CDT 2004

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

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:edHT5HxpEHA.3712@TK2MSFTNGP15.phx.gbl...
> 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" <larhondajohnson@yahoo.com> wrote in message
> news:%23AsUZiupEHA.3524@TK2MSFTNGP15.phx.gbl...
> > 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.
> >
> > "Sahil Malik" <contactmethrumyblog@nospam.com> wrote in message
> > news:ufEKGxqpEHA.3424@TK2MSFTNGP11.phx.gbl...
> >> 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" <larhondajohnson@yahoo.com> wrote in message
> >> news:e6Y$iLqpEHA.3988@tk2msftngp13.phx.gbl...
> >> >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?
> >> >
> >> >
> >>
> >>
> >
> >
>
>