I would like to check the MDAC version on our SQL Server 2005 servers on
windows 2003. How can I do so ?
Hassan,
I have not try this in a long time but this must be the link
How to check for MDAC version
http://support.microsoft.com/kb/301202
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I would like to check the MDAC version on our SQL Server 2005 servers on
> windows 2003. How can I do so ?
>
|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>
|||Go to the Microsoft download site and look for CC_PKG.exe the MDAC Utility:
Component Checker 2.0
'"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>
Showing posts with label mdac. Show all posts
Showing posts with label mdac. Show all posts
Sunday, March 25, 2012
check MDAC version
I would like to check the MDAC version on our SQL Server 2005 servers on
windows 2003. How can I do so ?Hassan,
I have not try this in a long time but this must be the link
How to check for MDAC version
http://support.microsoft.com/kb/301202
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I would like to check the MDAC version on our SQL Server 2005 servers on
> windows 2003. How can I do so ?
>|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess
--
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>|||Go to the Microsoft download site and look for CC_PKG.exe the MDAC Utility:
Component Checker 2.0
'"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>
windows 2003. How can I do so ?Hassan,
I have not try this in a long time but this must be the link
How to check for MDAC version
http://support.microsoft.com/kb/301202
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I would like to check the MDAC version on our SQL Server 2005 servers on
> windows 2003. How can I do so ?
>|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess
--
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>|||Go to the Microsoft download site and look for CC_PKG.exe the MDAC Utility:
Component Checker 2.0
'"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>
check MDAC version
I would like to check the MDAC version on our SQL Server 2005 servers on
windows 2003. How can I do so ?Hassan,
I have not try this in a long time but this must be the link
How to check for MDAC version
http://support.microsoft.com/kb/301202
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I would like to check the MDAC version on our SQL Server 2005 servers on
> windows 2003. How can I do so ?
>|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Da
taAccess
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>|||Go to the Microsoft download site and look for CC_PKG.exe the MDAC Utility:
Component Checker 2.0
'"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>
windows 2003. How can I do so ?Hassan,
I have not try this in a long time but this must be the link
How to check for MDAC version
http://support.microsoft.com/kb/301202
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I would like to check the MDAC version on our SQL Server 2005 servers on
> windows 2003. How can I do so ?
>|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Da
taAccess
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>|||Go to the Microsoft download site and look for CC_PKG.exe the MDAC Utility:
Component Checker 2.0
'"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>
Friday, February 24, 2012
Chart lists different builds of SQL Server and MDAC needed
I want to find out which build of MDAC is required by different build of SQL
Server 2000 and 2005.
Also, are all the keywords listed in the link below supported by all the
MDAC used for SQL Server 2000 and 2005? Are the acceptable values for the
keywords same for both 32bit and 64bit driver? For example, is the name of
the network library for tcp and named pipes same for both 32bit and 64bit?
http://msdn2.microsoft.com/en-us/library/aa177865(SQL.80).aspx
Thanks.Hi,
I've done some research but I couldn't find any document that ties the
keywords to MDAC specifically. I'm using the internal MS databases so
it's probably quite safe to say that no such document(s) exist(s). I
believe that the keywords are listed per SQL Server version rather than
per MDAC version.
What I would suggest you do is to test your applications against the
different MDAC versions. Alternatively, instead of testing all your
applications, you could also build a dummy application that does nothing
more than use the different keywords/functions specifically for testing
against the multiple MDAC versions efficiently and quickly.
The following link gives you a SQL Server 2005 version of the document
you included in your posting -
http://msdn2.microsoft.com/en-us/library/ms130822.aspx.
As far as any difference in acceptable keyword values between 32 and 64
bit platforms are concerned, I do not believe there would be a
difference. From my perspective portability between platforms should be
a high priority for any developer so I don't see why MS would introduce
such a big headache for itself and its customers. Again testing is your
safest option here.
Regarding the question of which MDAC build is required by different
builds of SQL Server I cannot find any MDAC updates being released as
part of a SQL Server build. To me this means that builds are not
dependent on any specific MDAC version otherwise MS would have no option
but to include the MDAC update as part of the SQL Server update. So I
would say that MDAC requirements are placed at a version level rather
than a build level unless any KB article specifically indicates
otherwise. My research uncovered no such KB articles.
Jonathan
Peter wrote:
> I want to find out which build of MDAC is required by different build of S
QL
> Server 2000 and 2005.
> Also, are all the keywords listed in the link below supported by all the
> MDAC used for SQL Server 2000 and 2005? Are the acceptable values for the
> keywords same for both 32bit and 64bit driver? For example, is the name of
> the network library for tcp and named pipes same for both 32bit and 64bit?
> http://msdn2.microsoft.com/en-us/library/aa177865(SQL.80).aspx
>
> Thanks.
>
>
Server 2000 and 2005.
Also, are all the keywords listed in the link below supported by all the
MDAC used for SQL Server 2000 and 2005? Are the acceptable values for the
keywords same for both 32bit and 64bit driver? For example, is the name of
the network library for tcp and named pipes same for both 32bit and 64bit?
http://msdn2.microsoft.com/en-us/library/aa177865(SQL.80).aspx
Thanks.Hi,
I've done some research but I couldn't find any document that ties the
keywords to MDAC specifically. I'm using the internal MS databases so
it's probably quite safe to say that no such document(s) exist(s). I
believe that the keywords are listed per SQL Server version rather than
per MDAC version.
What I would suggest you do is to test your applications against the
different MDAC versions. Alternatively, instead of testing all your
applications, you could also build a dummy application that does nothing
more than use the different keywords/functions specifically for testing
against the multiple MDAC versions efficiently and quickly.
The following link gives you a SQL Server 2005 version of the document
you included in your posting -
http://msdn2.microsoft.com/en-us/library/ms130822.aspx.
As far as any difference in acceptable keyword values between 32 and 64
bit platforms are concerned, I do not believe there would be a
difference. From my perspective portability between platforms should be
a high priority for any developer so I don't see why MS would introduce
such a big headache for itself and its customers. Again testing is your
safest option here.
Regarding the question of which MDAC build is required by different
builds of SQL Server I cannot find any MDAC updates being released as
part of a SQL Server build. To me this means that builds are not
dependent on any specific MDAC version otherwise MS would have no option
but to include the MDAC update as part of the SQL Server update. So I
would say that MDAC requirements are placed at a version level rather
than a build level unless any KB article specifically indicates
otherwise. My research uncovered no such KB articles.
Jonathan
Peter wrote:
> I want to find out which build of MDAC is required by different build of S
QL
> Server 2000 and 2005.
> Also, are all the keywords listed in the link below supported by all the
> MDAC used for SQL Server 2000 and 2005? Are the acceptable values for the
> keywords same for both 32bit and 64bit driver? For example, is the name of
> the network library for tcp and named pipes same for both 32bit and 64bit?
> http://msdn2.microsoft.com/en-us/library/aa177865(SQL.80).aspx
>
> Thanks.
>
>
Subscribe to:
Comments (Atom)