MDAC 2.7 Question

Hey Guy's,
I have a Windows 2003 Server (Standard Edition)
It also has SQL Server 2000 with Service Pack 3.
I am using this for testing my companies software compatability with Windows
2003.
Our software installs MDAC to work properly at the moment 2.7, but when our
installer runs it says cannot install as MDAC won't install it only supports
versions of Windows up to 2000...Is there a version available for 2003 yet?
Thanks,
Chris.
-mcpAFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available for download (yet). Why not
re-write the install program so it check for MDAC version, if lower than the your supported
level, you give an option to install. If higher than the tested (supported) level, well. In this
case, you quite simply need to test the sw on a machine with MDAC 2.8 (a W2K3 machine).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chris" <-@.-.com> wrote in message news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> Hey Guy's,
> I have a Windows 2003 Server (Standard Edition)
> It also has SQL Server 2000 with Service Pack 3.
> I am using this for testing my companies software compatability with Windows
> 2003.
> Our software installs MDAC to work properly at the moment 2.7, but when our
> installer runs it says cannot install as MDAC won't install it only supports
> versions of Windows up to 2000...Is there a version available for 2003 yet?
> Thanks,
> Chris.
> -mcp
>
>|||Can we get the MDAC mappings associated with the SPs of Windows and SQL =Server ? I've been searching for sometime for a site with this =consolidated information ...
-- HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions http://www32.brinkster.com/sqlvinod
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:eAOegWuRDHA.1552@.TK2MSFTNGP12.phx.gbl...
> AFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available for =download (yet). Why not
> re-write the install program so it check for MDAC version, if lower =than the your supported
> level, you give an option to install. If higher than the tested =(supported) level, well. In this
> case, you quite simply need to test the sw on a machine with MDAC 2.8 =(a W2K3 machine).
> > -- > Tibor Karaszi, SQL Server MVP
> Archive at: =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "Chris" <-@.-.com> wrote in message =news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> > Hey Guy's,
> >
> > I have a Windows 2003 Server (Standard Edition)
> > It also has SQL Server 2000 with Service Pack 3.
> >
> > I am using this for testing my companies software compatability with =Windows
> > 2003.
> >
> > Our software installs MDAC to work properly at the moment 2.7, but =when our
> > installer runs it says cannot install as MDAC won't install it only =supports
> > versions of Windows up to 2000...Is there a version available for =2003 yet?
> >
> > Thanks,
> >
> > Chris.
> > -mcp
> >
> >
> >
> >|||I haven't searched for such site. Here's what I have checked/remember by heart:
W2K MDAC 2.5
W2K sp1 MDAC 2.5 sp1
W2K sp2 MDAC 2.5 sp2
SQL2K MDAC 2.6
XP MDAC 2.7
W2K3 MDAC 2.8
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Vinodk" <vinodk_sct@.hotmail.com> wrote in message
news:%23YDVQguRDHA.3700@.tk2msftngp13.phx.gbl...
Can we get the MDAC mappings associated with the SPs of Windows and SQL Server ? I've been
searching for sometime for a site with this consolidated information ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions
http://www32.brinkster.com/sqlvinod
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in message
news:eAOegWuRDHA.1552@.TK2MSFTNGP12.phx.gbl...
> AFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available for download (yet). Why not
> re-write the install program so it check for MDAC version, if lower than the your supported
> level, you give an option to install. If higher than the tested (supported) level, well. In
this
> case, you quite simply need to test the sw on a machine with MDAC 2.8 (a W2K3 machine).
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Chris" <-@.-.com> wrote in message news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> > Hey Guy's,
> >
> > I have a Windows 2003 Server (Standard Edition)
> > It also has SQL Server 2000 with Service Pack 3.
> >
> > I am using this for testing my companies software compatability with Windows
> > 2003.
> >
> > Our software installs MDAC to work properly at the moment 2.7, but when our
> > installer runs it says cannot install as MDAC won't install it only supports
> > versions of Windows up to 2000...Is there a version available for 2003 yet?
> >
> > Thanks,
> >
> > Chris.
> > -mcp
> >
> >
> >
>|||Cool Tibor ...
But I think you missed SQL SP3a ?
and thankx in advance ... :) ...
And just a twist to the whole thing is it possible to find the MDAC =version from ISQLW window? I know abt the version ... But this ... Hmmm =... I would be interested in knowing this also ... -- HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions http://www32.brinkster.com/sqlvinod
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:OB3mMmuRDHA.2236@.tk2msftngp13.phx.gbl...
> I haven't searched for such site. Here's what I have checked/remember =by heart:
> > W2K MDAC 2.5
> W2K sp1 MDAC 2.5 sp1
> W2K sp2 MDAC 2.5 sp2
> > SQL2K MDAC 2.6
> > XP MDAC 2.7
> W2K3 MDAC 2.8
> -- > Tibor Karaszi, SQL Server MVP
> Archive at: =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "Vinodk" <vinodk_sct@.hotmail.com> wrote in message
> news:%23YDVQguRDHA.3700@.tk2msftngp13.phx.gbl...
> Can we get the MDAC mappings associated with the SPs of Windows and =SQL Server ? I've been
> searching for sometime for a site with this consolidated information =...
> > -- > HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> SCT Software Solutions
> http://www32.brinkster.com/sqlvinod
> > > "Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message
> news:eAOegWuRDHA.1552@.TK2MSFTNGP12.phx.gbl...
> > AFAIK, W2K3 comes with MDAC 2.8. This doesn't seem to be available =for download (yet). Why not
> > re-write the install program so it check for MDAC version, if lower =than the your supported
> > level, you give an option to install. If higher than the tested =(supported) level, well. In
> this
> > case, you quite simply need to test the sw on a machine with MDAC =2.8 (a W2K3 machine).
> >
> > -- > > Tibor Karaszi, SQL Server MVP
> > Archive at: =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> >
> >
> > "Chris" <-@.-.com> wrote in message =news:ubRdgKuRDHA.1072@.TK2MSFTNGP10.phx.gbl...
> > > Hey Guy's,
> > >
> > > I have a Windows 2003 Server (Standard Edition)
> > > It also has SQL Server 2000 with Service Pack 3.
> > >
> > > I am using this for testing my companies software compatability =with Windows
> > > 2003.
> > >
> > > Our software installs MDAC to work properly at the moment 2.7, but =when our
> > > installer runs it says cannot install as MDAC won't install it =only supports
> > > versions of Windows up to 2000...Is there a version available for =2003 yet?
> > >
> > > Thanks,
> > >
> > > Chris.
> > > -mcp
> > >
> > >
> > >
> >
> >
> >|||>> And just a twist to the whole thing is it possible to find the MDAC
version from ISQLW window?
http://www.aspfaq.com/2057 says:
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'|||Thankx Aaron ... :) ...
-- HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions http://www32.brinkster.com/sqlvinod
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message =news:#F3B$3uRDHA.2228@.tk2msftngp13.phx.gbl...
> >> And just a twist to the whole thing is it possible to find the MDAC
> version from ISQLW window?
> > http://www.aspfaq.com/2057 says:
> > EXEC master..xp_regread
> N'HKEY_LOCAL_MACHINE',
> N'Software\Microsoft\DataAccess',
> N'Version'
> >