ASP.Net/C# - Oracle Procs - The underlying connection was closed: An unexpected error occurred on a receive.

Posted on 2006-03-30
Last Modified: 2012-08-14
Hello all.  I am getting an error when an oracle proc I have tries to define an output cursor it errors out and then says in my error log "The underlying connection was closed: An unexpected error occurred on a receive.".  It seems like this might have to do with keep alives or something.  This is hitting a web service.  Any ideas all what I can try.
Question by:sbornstein2

    Author Comment

    It bombs on this definition of my output cursor:

                      oracleParams[19] = new Technicolor.Exhibitor.TrackingDAL.OracleWS.OracleParameter();
                      oracleParams[19].ParameterName = "p_retval";
                      oracleParams[19].Direction = OracleWS.ParameterDirection.Output;
                      oracleParams[19].OracleType = OracleWS.OracleType.Number;

    On the direction line.  I then get the error The underlying connection was closed: An unexpected error occurred on a receive.".  
    LVL 25

    Accepted Solution

    The following will help:

    XML & ASP.NET Error:"The underlying connection was closed: Unable to connect to the remote server"

    need help desperately. The underlying connection was closed:

    underlying connection was closed:unable to connect to remote server exception message


    Author Comment

    well the issue is it seems 90% of the time the calls work fine.  Then depending on the resultset returning it drops if it is a large resultset.  The proc itself though returns on the Web Server box very quick.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Training Course: Java/J2EE and SOA

    This course will cover both core and advanced Java concepts like Database connectivity, Threads, Exception Handling, Collections, JSP, Servlets, XMLHandling, and more. You'll also learn various Java frameworks like Hibernate and Spring.

    I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
    Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now