[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 770
  • Last Modified:

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

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.
0
sbornstein2
Asked:
sbornstein2
  • 2
1 Solution
 
sbornstein2Author Commented:
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.".  
0
 
nauman_ahmedCommented:
The following will help:

XML & ASP.NET Error:"The underlying connection was closed: Unable to connect to the remote server"
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/Q_20983544.html

need help desperately. The underlying connection was closed:
http://www.mcse.ms/message2194780.html

underlying connection was closed:unable to connect to remote server exception message
http://forums.devx.com/showthread.php?t=150295

-Nauman.
0
 
sbornstein2Author Commented:
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.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now