ADODB library question

[RobertT687]

With search down, I'll resort to a (hopefully) simple question. What determines the version of the ADO library available on a workstation (NT or 2000) to include in references? I work in a very mixed OS environment. The version of ADO library on the NT stations ranges from the 2.5 version all the way down to 2.1. Is this a function of the MDAC version installed on the workstation? For NT, what's the highest ADO library version I should expect to see? What about 2K?

Thanks in advance.

 

[Tranman]

Robert,
There are many different apps that, when installed, also install the MDAC (and thus, the ADODB typelibrary). Office, any single Office App, Visual Studio, to name a few.
Even some OS service packs do it. Of course, you can install the MDAC by itself.

I think that the highest version I saw under NT was 2.7. If you are having problems with versions because you are using a feature that was not available in some prior version, you should be aware that you can access and drop and add references in code.

If you need a code snippet, write back and I'll send you one. I think that somewhere, buried in an Excel spreadsheet, I have some code that actually looks for the appropriate ADODB reference, and if it doesn't find it, fetches the dll from a server, registers it, and adds a reference.

Tranman