PRB: Run-Time Error Message 430 with ADO Redistributed Application

• Microsoft Visual Basic Professional and Enterprise Editions for Windows, version 6.0
• Microsoft Data Access Components versions 2.0, 2.1

SYMPTOMS

When an ADO 2.1 application is redistributed, it produces the following run-time error on the user's computer:

Run-time Error 430
Class does not support automation or does not support expected interface.

CAUSE

The application references ADO 2.1 and redistributes ADO 2.0.

RESOLUTION

Install MDAC 2.1 or later on the user's machine and change the installation program to redistribute the correct version of MDAC.

STATUS

This behavior is by design.

MORE INFORMATION

The Recordset object interface changed between MDAC versions 2.0 and 2.1. Therefore, if the application opens a Connection or Command object, this should succeed.

The latest version of MDAC can be downloaded from:

http://www.microsoft.com/data

Additional query words:

Keywords : kbADO kbVBp600 kbGrpVBDB kbGrpMDAC kbDSupport
Version : WINDOWS:2.0,2.1,6.0
Platform : WINDOWS
Issue type : kbprb