Avoiding "Catastrophic Failure" Message

Because of a problem that affects Microsoft Data Access Components (MDAC) 2.6 and all editions of SQL Server 2000, if you use the adPromptAlways constant to open a trusted connection to SQL Server 2000, the user receives the following error message:

   'Run time error '-2147418113 (8000ffff)': Catastrophic Failure'.

In Microsoft article "FIX: 'Catastrophic Failure' Error Message When You Use adPromptAlways to Connect to SQL Server 2000," the company says to not use adPromptAlways, and to pass the information in the connection string instead. This problem doesn't occur with SQL Server 7.0 and is corrected in MDAC 2.6 Service Pack 2 (SP2) and MDAC 2.7.

http://support.microsoft.com/default.aspx?scid=kb;en-us;314635&Product=sql