Devart Forums

Hi,

I'm testing version 4.0.14 of Oradirect.dll Mobile .NET 2, but I'm have a connection problem with the database.
After having opened and closed the connection a few times the following error appears:

TestConnessione.exe
ObjectDisposedException
System.Net.Sockets.NetworkStream

at System.Net.Sockets.NetworkStream.Write()
at CoreLab.Oracle.j.z()
at CoreLab.Oracle.q.b()
at CoreLab.Oracle.a0.b()
at CoreLab.Oracle.d.b()
at CoreLab.Oracle.j.c()
at CoreLab.Oracle.u.d()
at CoreLab.Oracle.at..ctor()
at CoreLab.Oracle.ad.e()
at CoreLab.Common.DbConnectionFactory.k()
at CoreLab.Common.DbConnectionPoolGroup.i()
at CoreLab.Common.DbConnectionPool.a()
at CoreLab.Common.DbConnectionPool.GetObject()
at CoreLab.Common.DbConnectionFactory.j()
at CoreLab.Common.DbConnectionClosed.Open()
at CoreLab.Common.DbConnectionBase.Open()
at CoreLab.Oracle.OracleConnection.Open()
at TestConnessione.Form1.Connetti_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Button.OnClick()
at System.Windows.Forms.ButtonBase.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at TestConnessione.Form1.Main()


If I reboot the Oracle LISTENER the problem disappears but then after a few connecting attempts the problem reappears.
For the test I'm using .Net 2 (2005), Oracle 8.1.7.0 on Linux Slackware 8.1 and a Pocket PC with Windows mobile 2003.

When exactly the error occurs? on Open() or on Close()?
Could you please send me a small test project to reproduce the problem?
Use e-mail address provided in the Readme file.

I sent an e-mail to info at crlab dot com with a small project.

However the error occurs on Open() after a few attempts.
I tried to set the pooling parameter to false, but the problem doesn't disappear.

Thanks

I will investigate your project when it arrives.

We cannot reproduce the problem on our Oracle servers. Seemingly there is an exception during your connect, and OraDirect .NET treats it wrong way. This leads to the error you get. We are going to fix this in the next build to provide you with appropriate error message in such situations.

Thank you!
When do you think will be released the new build?
I'd have to test it before purchase.

Hopefully, in two weeks.

You were right!
It was an Oracle error in connection.
Our DBA has solved the problem.
Thanks

Well done.

hey Dmail...could you tell me how the DBA solved the problem?looks like i am having simmilar problems and could not get over it