Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: "Catastrophic Failure" Error Message When You Use adPromptAlways to Connect to SQL Server 2000
Article ID: 314635 - View products that this article applies to.
This article was previously published under Q314635
When you use the adPromptAlways constant to open a connection to SQL Server 2000, the user receives the following error message:
This problem occurs when you use a trusted connection to SQL Server 2000.
'Run time error '-2147418113 (8000ffff)': Catastrophic Failure'.
NOTE: This problem does not occur with Microsoft SQL Server 7.0.
To work around this problem, do not use adPromptAlways, and pass the information in the connection string.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This bug was corrected in Microsoft Data Access Components (MDAC) 2.6 Service Pack 2 and MDAC 2.7. To download the latest version of MDAC, refer to the following Microsoft Web site:
Steps to Reproduce Behavior