Check MDAC version inVB

[JaeBrett]

I want to check the users MDAC version upon startup to ensure they are using a newer version. How can I check this, from within VB?

<-- JaeTech Solutions -->

 

[LostInCode]

use FSO and look under:
C:\Programs\Common Files\System\ado
There you will find the ADO files and the ones present will identify which MDAC was installed:

msado10.dll = MDAC < 1.5
msado15.dll = MDAC 1.5
msado20.tlb = MDAC 2.0
msado21.tlb = MDAC 2.1
msado25.tlb = MDAC 2.5
msado26.tlb = MDAC 2.6
etc.

 

[JaeBrett]

Perfecto!

<-- JaeTech Solutions -->

 

[Droops]

Hello,

Wouldn't it be safer to read the registry to get this information ?
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\FullInstallVer.
You would not be bothered if your customers use Non-english systems.

Take care,

Andrew.

 

[LostInCode]

>Non-english systems

You can get special folders names on any system with API.
Examples in this forum.

 

[SteveGlo]

I have installed MDAC 2.6 but can find no occurrence of msado26.tlb ? Component Checker and registry check confirms that I do have version 2.6 installed. As I am suffering a VB app deployment problem that I believe to be centred around MDAC version issues I'd be grateful if anyone can explain what the could be the explanation for the missing msado26.tlb.

 

[LostInCode]

That, what I posted, was incorrect.

Basically:

msado25.tlb = MDAC 2.6
msado26.tlb = MDAC 2.7
msado27.tlb = MDAC 2.8

One step diffeferent.
But, that is NOT always the case.

So, just check the version of the msado15.dll

 

[SteveGlo]

LostInCode

Thanks for sorting that out and replying so quickly