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 --HERE IS WHERE IT HAPPENS

set rs = conn.Execute sSQL

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

Have you tried the oledb provider for oracle ?

Not yet. We were exploring that option. How different it is from going through ODBC. Can you please provide sample code on how to do it...

Any help is appreciated. Thanks.

Going through oledb is faster than odbc. Use a dsnless connection and supply the connectionstring. Do you have visual basic ?

Yes. We do have Visual basic.

Can you please provide a sample of "connection string" for Oracle 9i OLE DB provider.
Oracle server - ORDER.US.COM
Username - trader
Password - trader

The simplest way is to add an ado data control to your form in visual basic. Go to the properties of the ado data control and select connection string - follow the prompts selecting the oledb oracle driver. After you have completed it, copy the connection string and paste it into your asp code.