Re: after network drop i get ora-03114 not connected to oracle
- From: "Miha Markic [MVP C#]" <miha at rthand com>
- Date: Mon, 22 Jan 2007 15:06:32 +0100
I am sure tha odp.net supports 2.0/3.0, too (3.0 is just 2.0 with additions).
At least you have MS' Oracle managed provider for .net 2.0 out of the box.
--
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:386FCDC7-5A78-4D74-9EC0-911FEFCDF342@xxxxxxxxxxxxxxxx
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: Geir Sanne
- 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
- From: Geir Sanne
- Re: after network drop i get ora-03114 not connected to oracle
- Prev by Date: Re: DateTime Filter Expression
- Next by Date: Re: Login failed for user '(null)'. Reason: Not associated with a
- 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
|
