XL2000: "Catastrophic Failure" Error Running Samples.xls Macro (228633)

SYMPTOMS

When you run the Microsoft Visual Basic for Applications sample macro, RetrieveISAMdata() in the Sample.xls workbook that ships with Microsoft Excel and Microsoft Office, the following error message appears:

Run-time error '2147418113(8000ffff)':

Catastrophic failure

If you click Debug, the macro stops on the statement

.Open strConn

for the object:

With conn

CAUSE

This problem occurs when you run the RetrieveISAMdata() sample under the following conditions:

You run Microsoft Excel on Windows Terminal Server.

-and-
You are using Microsoft Data Access Components (MDAC) version 2.1, which ships with Office 2000.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

When you install either Microsoft Excel or Microsoft Office, the Setup program installs the sample workbook to the following folder:

C:\Program Files\Microsoft Office\Samples

NOTE: This location may be different depending on where you installed the Office program.

If you are running Microsoft Excel on Microsoft Windows Terminal Server, and you open the Samples.xls workbook, the error message appears when you click the ADO-ActiveX Data Objects worksheet, click Goto Retrieve ISAM Data Example Sample Code and then run the RetrieveISAMdata() sample macro.