ADO failing on XP - untangling MDAC and Jet DLLs

My ADO based app is working fine on hundreds of PCs, all except one.

In the program unit, before the application is run, I check that an
ADOConnection object can be created and that Jet 4.0 is correctly
registered. If this fails then the rest of the app is not going to work so I
raise an exception and quit. I added this basic check on app startup because
on older PCs with corrupted MDAC installations (or no Jet 4.0) the app would
freeze while loading the data module. Not pretty, an error message is far
nicer and then I can get the user to install MDAC etc.

On this one PC this check fails, implying that there is a problem with the
installation of MDAC or Jet 4.0 DLLs. However the PC has XP installed, and I
have never encountered this kind of issue with XP. I got the user to
download and install MDAC 2.8 and Jet SP8 from the MS site, but the problem
remains.

Tried to run the MS component checker (that is meant to check MADC
installations) but it simply crashed. So
I asked the user for DLL version numbers only to find they have multiple
copies of files with different version numbers
e.g.
msado15.dll 2.80.1022.0 & 2.81.1117.0,
msjet40.dll 4.0.4431.4, 4.0.7328.0 & 4.0.8618.0.
(I didn't ask about others, it is a long list)

Not sure what to make of this, surely there should only be one version
present? Some of these files come with XP SP2, yet the system info says XP
Pro (2002), no mention of service packs. Could the problem we down to a
corrupted SP2 installation, or am I barking up the wrong tree?

I really don't know how to sort this out, I had hoped that the downloads
would untangle any conflicts or corruptions but they haven't. What can I try
next?

Dave


.

Relevant Pages

  • Re: ADO failing on XP - untangling MDAC and Jet DLLs
    ... If this fails then the rest of the app is not going to work so I ... >on older PCs with corrupted MDAC installations (or no Jet 4.0) the app would ... >nicer and then I can get the user to install MDAC etc. ...
    (borland.public.delphi.database.ado)
  • Re: store tables to server while installing app, how
    ... > is much more powerful (you can modify end-user dialogs) and has ... > installations in just about any way you want. ... > installation CD which works for standalone installations (ie app ... With a bit of tweaking, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Java <-> MFC?
    ... > small new feature of my app, ... Sun Java ... The JDK installations use similar pointers, but you probably won't want to use ... You /may/ be able to prevent the JVM killing the calling app by setting an exit ...
    (comp.lang.java.programmer)
  • Re: QRe: Legacy Access 2 VB 4 app, Word 11 merge on XP Pro SP2 client
    ... had been upgraded from Jet 2/2.5 to Jet 3.5/3.51. ... (Standard Windows installations ... native Word formats, so no ODBC connection would be used from ... a file (either the dat file or the destination file). ...
    (microsoft.public.access.conversion)
  • Re: MFC MDI app hangs randomly on some machines, but not others (most are OK). Typical causes?
    ... Perhaps put a special 'hidden' test in your app to ... Common h/w device driver issue. ... In testing, clean installations of all ... > DLL versioning has been checked and shown to be OK in many ...
    (microsoft.public.vc.mfc)