Hi all,
I run MDAC Component Check on my SQL Server 2000. None
of the versions of MDAC passed the tests. The closest one
is 2.7 SP1 (2.71.9030.9) with only One error on
msjtes40.dll file
msjtes40.dll,Error,Field 'FileVersion' mismatch:
Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
Expression
Does this mean that I have to install 2.71 Service
Pack 1 Refresh: mdac_typ.exe ?
What files contain in this mdac_typ.exe? Would
installing this file help on Memory Leak?
Thank you sooooo much!!!
P.S.: I think I install 2.7 SP1 via Windows Update. I
didn't apply SQL Sever 2000 SP3 at all.
AnnieThat file almost always checks different, so don't worry.
normally if the version number is higher compared to the closest match it is
OK.
This normally happens because you installed some software with an newer DLL.
( I am assuming msjtes40.dll is installed by MS Office, since I always see
it being different at work.)
Tim S
"Annie" <piyomeme@.yahoo.com> wrote in message
news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
> Hi all,
> I run MDAC Component Check on my SQL Server 2000. None
> of the versions of MDAC passed the tests. The closest one
> is 2.7 SP1 (2.71.9030.9) with only One error on
> msjtes40.dll file
> msjtes40.dll,Error,Field 'FileVersion' mismatch:
> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
> Expression
> Does this mean that I have to install 2.71 Service
> Pack 1 Refresh: mdac_typ.exe ?
> What files contain in this mdac_typ.exe? Would
> installing this file help on Memory Leak?
> Thank you sooooo much!!!
> P.S.: I think I install 2.7 SP1 via Windows Update. I
> didn't apply SQL Sever 2000 SP3 at all.
> Annie
>|||Thank you, Tim.
I don't have MS Office installed on Server, but it could
be something else.
That was helpful. Thank you~
Annie
>--Original Message--
>That file almost always checks different, so don't worry.
>normally if the version number is higher compared to the
closest match it is
>OK.
>This normally happens because you installed some software
with an newer DLL.
>( I am assuming msjtes40.dll is installed by MS Office,
since I always see
>it being different at work.)
>Tim S
>
>"Annie" <piyomeme@.yahoo.com> wrote in message
>news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
>> Hi all,
>> I run MDAC Component Check on my SQL Server 2000.
None
>> of the versions of MDAC passed the tests. The closest
one
>> is 2.7 SP1 (2.71.9030.9) with only One error on
>> msjtes40.dll file
>> msjtes40.dll,Error,Field 'FileVersion' mismatch:
>> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
>> Expression
>> Does this mean that I have to install 2.71 Service
>> Pack 1 Refresh: mdac_typ.exe ?
>> What files contain in this mdac_typ.exe? Would
>> installing this file help on Memory Leak?
>> Thank you sooooo much!!!
>> P.S.: I think I install 2.7 SP1 via Windows Update. I
>> didn't apply SQL Sever 2000 SP3 at all.
>> Annie
>
>.
>
Showing posts with label mdac. Show all posts
Showing posts with label mdac. Show all posts
Friday, March 30, 2012
Mdac Xp 2000
My Development machine is Win XP Pro.
I have MDAC 2.7, Visual Studio 6.0 SP3 Installed.
I am running into some issues where a vb program i wrote runs perfectly fine (Using ADO) when connecting to sql server but only runs fine on half of the windows 2000 machines i tested on.
Anyone have any suggestions? even stranger is that the versions of the odbc driver on the 2000 box are newer than the versions on my xp box with MDAC 2.7 SP1 installed.
All machines have DSN's set up exactly the same. I even tested with a DSN'less connection just to be sure (same result).Refer to event viewer logs for any kind of information in this regard.
I have MDAC 2.7, Visual Studio 6.0 SP3 Installed.
I am running into some issues where a vb program i wrote runs perfectly fine (Using ADO) when connecting to sql server but only runs fine on half of the windows 2000 machines i tested on.
Anyone have any suggestions? even stranger is that the versions of the odbc driver on the 2000 box are newer than the versions on my xp box with MDAC 2.7 SP1 installed.
All machines have DSN's set up exactly the same. I even tested with a DSN'less connection just to be sure (same result).Refer to event viewer logs for any kind of information in this regard.
MDAC won't play
Trying to set up a harware testing machine. OS is 98SE, the test software (Sandra MAX 3) won't install as it "requires MDAC 2.5 or greater".
Tried install ing MDAC 2.8, it just sits there doing nothing in an open window. Same result with MDAC 2.7.
Tried installing Component Checker, nothing at all happens!
MDAC 2.8 installed fine on another 98SE just last week. Anything else? Um ... both machines are running NAV 2005.
So I'm a bit stuck for ideas. Anyone have any advice, please?
Ray
Did you clean the environment of the failed installation of your test software (Sandra MAX 3)? That app may have done something behind that blocks MDAC installation. Can you also contact the vendor of the test software see if they know any solution?
Thanks,
Xinwei
|||I understand what you're saying "Xinwei Hong - MSFT" and thanks for the considered reply.
Checked & hand-cleaned the registry of all references to the test software. Retried CC & MDAC 2.8 - same result:- no joy. I don't know if it's any help but there was an MDAC critical update found in Add/Remove programs - so I deleted it ... as I apparently don't have any version of MDAC if I understand the CC non-response correctly.
Would contact vendor of test software but I'd guess they would reply something like "Why are you asking us for a solution to a Microsoft install problem?".
Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?
|||This is more like a setup issue. Moving to Sql setup.
Can anybody give the customer a hint why MDAC installation fails and how to diagonise it?
|||Nearly 3 weeks now, no replies ...
"Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?"
Ray
|||... is there some sort of log I can check to see why the MDAC install fails.
Anything?
Ta, Ray
|||You can try to install MDAC 2.1, then 2.5 and then 2.8.
Hope may help!
Infosteo
MDAC won't play
Trying to set up a harware testing machine. OS is 98SE, the test software (Sandra MAX 3) won't install as it "requires MDAC 2.5 or greater".
Tried install ing MDAC 2.8, it just sits there doing nothing in an open window. Same result with MDAC 2.7.
Tried installing Component Checker, nothing at all happens!
MDAC 2.8 installed fine on another 98SE just last week. Anything else? Um ... both machines are running NAV 2005.
So I'm a bit stuck for ideas. Anyone have any advice, please?
Ray
Did you clean the environment of the failed installation of your test software (Sandra MAX 3)? That app may have done something behind that blocks MDAC installation. Can you also contact the vendor of the test software see if they know any solution?
Thanks,
Xinwei
|||I understand what you're saying "Xinwei Hong - MSFT" and thanks for the considered reply.
Checked & hand-cleaned the registry of all references to the test software. Retried CC & MDAC 2.8 - same result:- no joy. I don't know if it's any help but there was an MDAC critical update found in Add/Remove programs - so I deleted it ... as I apparently don't have any version of MDAC if I understand the CC non-response correctly.
Would contact vendor of test software but I'd guess they would reply something like "Why are you asking us for a solution to a Microsoft install problem?".
Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?
|||This is more like a setup issue. Moving to Sql setup.
Can anybody give the customer a hint why MDAC installation fails and how to diagonise it?
|||Nearly 3 weeks now, no replies ...
"Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?"
Ray
|||... is there some sort of log I can check to see why the MDAC install fails.
Anything?
Ta, Ray
|||You can try to install MDAC 2.1, then 2.5 and then 2.8.
Hope may help!
Infosteo
sqlMDAC Version....
How to find out MDAC version on a given computer ?
Albert> Is it required to stay completely current with MDAC new
> releases?
Required by what, who? Really depends on your requirements...
Personally, since each new version has potential fixes and security patches,
so I try to stay as up-to-date as possible.
Of course, don't deploy to production until you test it in a similar
environment.
Albert> Is it required to stay completely current with MDAC new
> releases?
Required by what, who? Really depends on your requirements...
Personally, since each new version has potential fixes and security patches,
so I try to stay as up-to-date as possible.
Of course, don't deploy to production until you test it in a similar
environment.
MDAC version error
Hi,
I have a problem to install SQL Server 2000 Development Edition onto my
Windows 2000 professional P.,I have a check of my MDAC version using the
Component Checker, it tells that the version of my MDAC is 2.53.6202.0 which
should be 2.53.6200.0.
Does anybody know why this happened and how to solve it?
Thanks in advance
FrankThe Component Checker you are using likely had not been updated for the
security patch you have installed. If you get a newer version of the
Component Checker
(http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataacces
s.asp) it should report 2.53.6202.
Shawn Aebi
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
I have a problem to install SQL Server 2000 Development Edition onto my
Windows 2000 professional P.,I have a check of my MDAC version using the
Component Checker, it tells that the version of my MDAC is 2.53.6202.0 which
should be 2.53.6200.0.
Does anybody know why this happened and how to solve it?
Thanks in advance
FrankThe Component Checker you are using likely had not been updated for the
security patch you have installed. If you get a newer version of the
Component Checker
(http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataacces
s.asp) it should report 2.53.6202.
Shawn Aebi
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
MDAC Version ?
How can I find out the version of MDAC ?
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
MDAC Version ?
How can I find out the version of MDAC ?
TIA
Try
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA
|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
TIA
Try
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA
|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
MDAC Version ?
How can I find out the version of MDAC ?
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIAsql
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIAsql
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> http://www.aspfaq.com/2057
>
on[vbcol=seagreen]
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8[vbcol=seagreen]
> on
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> http://www.aspfaq.com/2057
>
on[vbcol=seagreen]
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8[vbcol=seagreen]
> on
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
MDAC Version
How do I determine the MDAC version SQL Server 2000 is using?
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/...en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/...en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
Mdac version
Hi,
How do I check the version of Mdac in sql box?
Thankshttp://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||use a tool from MS called ComChecker...
http://www.microsoft.com/downloads/...&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>
How do I check the version of Mdac in sql box?
Thankshttp://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||use a tool from MS called ComChecker...
http://www.microsoft.com/downloads/...&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>
MDAC Version
How do I determine the MDAC version SQL Server 2000 is using?
Thank You,
Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>
|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/d...n&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
sql
Thank You,
Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>
|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/d...n&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
sql
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
MDAC version
Hi!
How to know which version of MDAC I currently use?
Thanks.
Dmitry| Hi!
|
| How to know which version of MDAC I currently use?
|
| Thanks.
|
| Dmitry
--
Hi Dmitry,
Please refer to this Technet article:
HOW TO: Check for MDAC version
http://support.microsoft.com/?id=301202
Hope this helps,
--
Eric Cárdenas
SQL Server support|||There is an MDAC version checker that can be got from MS web site
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:%23hzhvc7vDHA.2000@.TK2MSFTNGP11.phx.gbl...
> Hi!
> How to know which version of MDAC I currently use?
> Thanks.
> Dmitry
>
How to know which version of MDAC I currently use?
Thanks.
Dmitry| Hi!
|
| How to know which version of MDAC I currently use?
|
| Thanks.
|
| Dmitry
--
Hi Dmitry,
Please refer to this Technet article:
HOW TO: Check for MDAC version
http://support.microsoft.com/?id=301202
Hope this helps,
--
Eric Cárdenas
SQL Server support|||There is an MDAC version checker that can be got from MS web site
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:%23hzhvc7vDHA.2000@.TK2MSFTNGP11.phx.gbl...
> Hi!
> How to know which version of MDAC I currently use?
> Thanks.
> Dmitry
>
MDAC Version
How do I determine the MDAC version SQL Server 2000 is using?
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > How can I find out what version of MDAC is installed on a Machine.
> http://www.aspfaq.com/2057
> > And would there be any problem with me installing both MDAC 2.7 and 2.8
on
> > the same machine
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > How can I find out what version of MDAC is installed on a Machine.
> >
> > http://www.aspfaq.com/2057
> >
> > > And would there be any problem with me installing both MDAC 2.7 and
2.8
> on
> > > the same machine
> >
> > Installing 2.8 should upgrade 2.7 to 2.8.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Thanks Aaron
> >
> > But i was reading that MDAC 2.8 does not have the JET drivers and my
> > application needs them as well as the MS SQL drivers.
> >
> >
> > So do i install both?
> >
> > Ian
> >
> >
> >
> >
> > "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> > news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > > How can I find out what version of MDAC is installed on a Machine.
> > >
> > > http://www.aspfaq.com/2057
> > >
> > > > And would there be any problem with me installing both MDAC 2.7 and
> 2.8
> > on
> > > > the same machine
> > >
> > > Installing 2.8 should upgrade 2.7 to 2.8.
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> >
> >
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > How can I find out what version of MDAC is installed on a Machine.
> http://www.aspfaq.com/2057
> > And would there be any problem with me installing both MDAC 2.7 and 2.8
on
> > the same machine
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > How can I find out what version of MDAC is installed on a Machine.
> >
> > http://www.aspfaq.com/2057
> >
> > > And would there be any problem with me installing both MDAC 2.7 and
2.8
> on
> > > the same machine
> >
> > Installing 2.8 should upgrade 2.7 to 2.8.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Thanks Aaron
> >
> > But i was reading that MDAC 2.8 does not have the JET drivers and my
> > application needs them as well as the MS SQL drivers.
> >
> >
> > So do i install both?
> >
> > Ian
> >
> >
> >
> >
> > "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> > news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > > How can I find out what version of MDAC is installed on a Machine.
> > >
> > > http://www.aspfaq.com/2057
> > >
> > > > And would there be any problem with me installing both MDAC 2.7 and
> 2.8
> > on
> > > > the same machine
> > >
> > > Installing 2.8 should upgrade 2.7 to 2.8.
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> >
> >
>
Mdac version
Hi,
How do I check the version of Mdac in sql box?
Thanksuse a tool from MS called ComChecker...
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||http://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
--
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I check the version of Mdac in sql box?
>> Thanks
>sql
How do I check the version of Mdac in sql box?
Thanksuse a tool from MS called ComChecker...
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||http://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
--
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I check the version of Mdac in sql box?
>> Thanks
>sql
MDAC upgrade problem CompCheck reports 2.5 instead of 2.8
I am running SQL server on a Windows 2000 server with sp4 installed. After installing SQL service pack 4 on the machine my applications began complaining that MDAC was version 2.5 sure enough CompChecker reports version 2.5. I have tried to install the latest version of MDAC (2.8) on the machine but no matter what I do CompChecker reports 2.5.
I've tried reinstalling the SQL service pack I had no luck with that. Any help with this issue would be greatly appreciated.
WHen was the Windows service pack4 was applied, is it after SQL SP4 or before?
Check this KBA http://support.microsoft.com/kb/823939 for informaiton, ifyou need then you have to install MDAC 2.8 seperately.
|||The service pack was applied before the upgrade.|||I don't know if this helps but I think the issue is with the Windows File Protection. If I attempt to rename one of the dlls the server will automatically replace the file on the server with the 2.5 version. Is there some way to overcome this?|||Did you try to install the MDAC 2.8 separately like Satya proposed ? The file cannot be changed as the Windows FileProtextion is enabled for them (as you already noticed). if you already tried to install the MDAC 2.8, did you get an error or did the install run through ? Did you restart the system afterwards ?HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
I finally figured this out. It turns out that there were certain registry settings that were incorrectly set when SP4 was applied to SQL Server 2000. I don't want to get into the exact registry settings that need to be changed but that is where the answer lies.
Thanks to all for your assistance.
Subscribe to:
Posts (Atom)