MDAC 2.1 / MDAC 2.53

HI,
SQL Server 7.0 (sp4)
Production machine : SQL Server 7.0 (sp4) Entreprise Edition on NT
--> MDAC 2.1,2 sp2
Test machine : SQL Server 7.0 (sp4) Standard Edition on Windows
2000 --> MDAC 2.53
I would like my Test machine be like my Production Machine.
In others words, I would like to change from MDAC 2.53 to MDAC 2.1.2 sp2 on
my Test machine.
Is it possible ? If yes, how can I do that ? (with Mdac_typ.exe ?)
Thank you
DannyDanny,
MDAC is a system component on Windows 2000 and XP and 2003. You cannot
removed it and I am sure that you cannot downgrade it from 2.5. MDAC 2.5 has
problems with DTS when connecting to MDAC 2.1. So you are better off
upgrading your server level to be the same as the workstation.
Chris Wood
Alberta Department of Energy
CANADA
"Danny Presse" <dpresse@.congresmtl.com> wrote in message
news:uwczaaWTDHA.2280@.TK2MSFTNGP12.phx.gbl...
> HI,
> SQL Server 7.0 (sp4)
> Production machine : SQL Server 7.0 (sp4) Entreprise Edition on NT
> --> MDAC 2.1,2 sp2
> Test machine : SQL Server 7.0 (sp4) Standard Edition on Windows
> 2000 --> MDAC 2.53
> I would like my Test machine be like my Production Machine.
> In others words, I would like to change from MDAC 2.53 to MDAC 2.1.2 sp2
on
> my Test machine.
> Is it possible ? If yes, how can I do that ? (with Mdac_typ.exe ?)
> Thank you
> Danny
>