BUG: After Installing IE 4.0, ADO May Raise Error 0x800a0bb9

ID: Q171223

The information in this article applies to:

SYMPTOMS

After installing Internet Explorer 4.0 (beta 2), ADODB code using a recordset may raise an error condition with an error code of 0x800A0BB9 or -2147439686. This error code may occur when performing operations that use ADODB.Recordset objects in conjunction with other ADODB objects as shown in the example below:

   dim cnnObj as new ADODB.Connection
   dim rstObj as new ADODB.Recordset
   dim strSource as string
   ...
   rstObj.Open strSource, cnnObj

This only occurs if the user has not already installed ADO 1.5.

CAUSE

Internet Explorer 4.0 beta installs Msador15.dll, which when registered puts two sets of PROGIDs in the registry, both of which point to the newer Recordset CLSID (the one for ADOR 1.0 Recordset and ADODB/ADOR 1.5 Recordset). Only the "ADOR.Recordset" PROGID should be entered in the registry.

ADO/R does not utilize the Connection, Command, Errors, or Parameter objects. Therefore ADODB 1.0 code using these objects fails if the Recordset object is not correctly registered.

This issue is a problem only for code that uses CreateObject("ADODB.Recordset")--including ASP's Server.CreateObject()--but is not a problem for compiled VB/C++ applications, which avoid the use of CreateObject() and instead use a TypeLib or other early-binding mechanism.

RESOLUTION

After installing Internet Explorer 4.0, the user can go to the following folder:

   \program files\common files\system\ado

Then you can re-register ADO's Recordset object correctly with the following command:

   regsvr32 msado10.dll

However, if the user already has Msado15.dll installed on their system, then there will not be any conflict as a result of the ADOR registration bug. You should not re-register Msado10.dll after ADO 1.5 has been installed on the machine.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This bug only affects users of Active Server Pages 1.0 who install Internet Explorer (4.0 Beta 2).

This bug does not affect users of Internet Information Server 4.0 because it correctly installs the rest of ADODB. It also does not affect anyone who doesn't use Active Server Pages 1.0.

Keywords          : kbADO150bug 
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: February 4, 1999