NT, SQL 2000

[shoppe@gmail.com]

Hello:

We currently have the following configuration. Our web and vb apps are
sitting on a WinNT box (MDAC 2.5). We have SQL 7 which is also on
WinNT box.

We are migrating to SQL 2000, which will be on a Windows 2000 machine.
Our web and vb apps will not be migrated and will stay on the WinNT
machine.

Does anyone foresee any issues with this upgrade? Do we need to update
the WinNt box to MDAC 2.6?

Thank you.

[Erland Sommarskog]

Re: NT, SQL 2000

(shoppe@gmail.c om) writes:[color=blue]
> We currently have the following configuration. Our web and vb apps are
> sitting on a WinNT box (MDAC 2.5). We have SQL 7 which is also on
> WinNT box.
>
> We are migrating to SQL 2000, which will be on a Windows 2000 machine.
> Our web and vb apps will not be migrated and will stay on the WinNT
> machine.
>
> Does anyone foresee any issues with this upgrade? Do we need to update
> the WinNt box to MDAC 2.6?[/color]

If you want to use new features in SQL 2000 such as the bigint datatype,
named instances, yes.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp