Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Posts
    4

    Unanswered: Catastophic failure while opening ADO connection to Oracle

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you tried the oledb provider for oracle ?

  3. #3
    Join Date
    Dec 2002
    Posts
    4
    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Going through oledb is faster than odbc. Use a dsnless connection and supply the connectionstring. Do you have visual basic ?

  5. #5
    Join Date
    Dec 2002
    Posts
    4
    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

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •