INFO: ADO 2.1 Ships with an ADO 2.0 Type Library

• ActiveX Data Objects (ADO), version 2.1

SUMMARY

The version of Microsoft ActiveX Data Objects (ADO), listed in the Applies To section, ships with an ADO 2.0 Type Library file.

MORE INFORMATION

The name of the type library file is Msado20.tlb and by default the file is located in the \\Program Files\Common Files\System\ADO subdirectory.

If a project that originally used ADO 2.0 is opened after ADO 2.1 has been installed, you will see that the project references the ADO 2.0 Type Library and not the ADO Dynamic Link Library.

In other words, the project reference still shows "Microsoft ActiveX Data Objects 2.0". However, the file this reference is pointing to will be the ADO 2.0 Type Library, Msado20.tlb, and not the ADO Dynamic Link Library, Msado15.dll.

This behavior differs from prior versions of Microsoft ActiveX Data Objects. Prior versions did not ship with type libraries for previous versions. Therefore, projects created with the earlier versions automatically started using the newer interfaces of Microsoft ActiveX Data Objects installed although the project's references continued to point to the Microsoft ActiveX Data Objects Dynamic Link Library, Msado15.dll.

To switch to the new ADO 2.1 interfaces, clear the project reference for "Microsoft ActiveX Data Objects 2.0", Msado20.tlb. Next, select the reference for "Microsoft ActiveX Data Objects 2.1", Msado15.dll.

REFERENCES

For additional information, please see the following article in the Microsoft Knowledge Base:

Q201580 INFO: ADO 2.0 and ADO 2.1 Binary Compatibility

Additional query words: kbDSupport kbdse

Keywords : kbADO210 kbDatabase kbMDAC
Version : WINDOWS:2.1
Platform : WINDOWS
Issue type : kbinfo