Intermittent Catastrophic Failure at conn.open on Prod Server

[AnandMishra]

I am getting intermittent "catastrophic failure" error (1x/day) at line# 1710. Prod WebServer has Win2K Adv Server with SP4. It has MDAC 2.71 RTM applied. Connection string has "Provider=oraoledb.oracle; bla bla" for Oracle 9i DB.

This custom ORADAC.dll registered outside COM+.

Any help will be great.


1660 'Open ADO Connection based on connection string from registry
1670 Set adoConnection = New ADODB.Connection
1680 Set registry = New TOMS2DAC.registryAccess
1690 'Detect alternate connection string from source attribute
1700 If Len(strConnString) = 0 Then
1710 adoConnection.Open registry.GetStringKeyValue("Database\TOMS2", "ConnectionString")
1720 Else
1730 adoConnection.Open registry.GetStringKeyValue("Database\TOMS2", strConnString)
1740 End If

Anand
anandm@entcomm.com