MDAC Problem

[BOB]

Hello everyone,

I have a customer who is running a software that requires MDAC 2.7 or
greater. He is running winXP Pro SP2
Six months ago everything was working great (winXP SP1 then). Two weeks ago,
he upgraded to SP2 and now the program is not detecting MDAC. I ran
Microsoft's component checker and MDAC 2.8 is installed but when he runs the
software it can't find it. Where should I start with this issue? There is
the code the software uses to check the MDAC version.

Function GetAdoVersion() As String
' Returns which version of ADO is installed if true
' Otherwise returns Not Installed
Dim o As Object

On Error Resume Next
Set o = CreateObject("ADODB.Connection")

If Err.Number = 0 Then
GetAdoVersion = o.Version
Else
'ADO is not installed
GetAdoVersion = "Not Installed"
End If

Set o = Nothing
End Function

HELP Me

Rick

 

[Star Fleet Admiral Q]

Sounds like the software vendor coded his/her software to only work with a
specific version - you say it worked with 2.7 (under XP SP1) but now it
doesn't with 2.8 (under XP SP2). Oh, the code you are showing is simple
scripting used to get the version of MDAC, but it is passing this
information off to the application, which must have the MDAC hard coded,
most likely the programmer hasn't learned how to code "equal to or greater
than", but is specific to a version. You would not believe the number of
programs in my lifetime I've had to change due to this type of reasoning.
The only valid reason would be the programmer is using a function in the
current version, the next due out version is not going to support - this is
the case I've seen with many Java programs/applets.
Your best bet, either the customer goes back, or you get the vendor to
change the app - they may (the vendor) have a patch out for SP2 already -
have you checked with them, their web site (the vendor that is).

--

Star Fleet Admiral Q @ your Service!

http://www.google.com
Google is your "Friend"

 

[bob bonehead]

Thanks Star Fleet Admiral Q,

The code in the software basically says that if the MDAC version is equal to
or greater than 2.7 we will step on through but if it is less than 2.7, we
will install MDAC 2.8. The problem is that it is not detecting MDAC
Right now the software is working correctly on nine different machines,
seven of which are running SP2. The problem lies in the OS. Using the
function shown below, it says that MDAC is not installed but I know it's
there. This function does not change and it is run every time the program
runs so the problem is not in the software. I have used this function in a
stand alone app for testing purposes and on the other six machines running
SP2, I am returning MDAC version 2.8, so this happened somewhere in the SP2
upgrade of this particular machine.

Rick