Win2K server connecting to Oracle 9i through ODBC using Oracle ODBC driver (not Microsoft Oracle Driver). DSN is created in ODBC control panel. When multiple users access the page we once in a while get "Catastrophic Failure" message while connecting and then subsequent connection attempts hang with DLLHOST.exe occuping 100% CPU. ASP page has following code -

Dim conn as ADODB.Connection
Dim conn as ADODB.Recordset

set conn = CreateObject("ADODB.Connection")
conn.ConnectionTimout = 30
conn.CommandTimout = 30
conn.CursorLocation = adUseClient
conn.open sDSN, sUID, sPWD

set rs = conn.Execute sSQL

rs.Close
set rs = nothing
conn.Close
conn = nothing