Re: after network drop i get ora-03114 not connected to oracle
- From: Geir Sanne <GeirSanne@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 22 Jan 2007 05:38:01 -0800
ok.. ill try.
odp.net only supports .net 1.0. can i use that with .net 2.0/3.0
application ?
"Miha Markic [MVP C#]" wrote:
Hi Geir,.
I guess this is a connection pool feature. Try clearing connection pool and
re-create connection when this happens (you would have to recreate it
anyway).
Both SqlConnection and OracleConnection have static ClearPool method while
OleDbConnection seems missing it (try with ReleaseObjectPool instead).
Why don't you use Oracle managed provider in first place?
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Geir Sanne" <GeirSanne@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A9029AAB-7132-46BD-9666-B28981121D08@xxxxxxxxxxxxxxxx
hi!!!
im calling a stored procedure in oracle every time i get a message on a
serialport.
using (OleDbConnection conn = new
OleDbConnection(connectionString))
{
OleDbCommand cmd = new OleDbCommand(".....", conn);
conn.Open();
cmd.CommandTimeout = 10;
cmd.ExecuteNonQuery();
}
this works fine and when network drops/fails i get a timeout.
the problem occurs when the network is back up.
the conn.open() runs fine, but when cmd.ExecuteNonQuery(); i get ora-03114
not connected to oracle. this error i get until i restart my program.
is this a ado.net problem or a oracle problem ?
- Follow-Ups:
- Re: after network drop i get ora-03114 not connected to oracle
- From: Miha Markic [MVP C#]
- Re: after network drop i get ora-03114 not connected to oracle
- References:
- Re: after network drop i get ora-03114 not connected to oracle
- From: Miha Markic [MVP C#]
- Re: after network drop i get ora-03114 not connected to oracle
- Prev by Date: Re: after network drop i get ora-03114 not connected to oracle
- Next by Date: Re: DateTime Filter Expression
- Previous by thread: Re: after network drop i get ora-03114 not connected to oracle
- Next by thread: Re: after network drop i get ora-03114 not connected to oracle
- Index(es):
Relevant Pages
|
