VB Forum / Database Access / March 2007

Hi All,

I have created a VB.Net application that used classic ADO to access the
oracle database. I have mentained a persistant connection in it. When i start
the application and it works fine. All of a sudden i start receiving the
following error messages countineoully as my appllication polls the database
afetr some specified amount odf time.

"Error : No. :3709 :The requested operation requires an OLE DB Session
object, which is not supported by the current provider., Source

"Error : No. :3709 :Te connection cannot be used to perform this operation.
It is either closed or invalid in this context., Source :ADODB.Command-- "

Here one thing I would like to point that I have never called Close method
on conenction object. That is called only when I am shutting down the app.

In this case I have to shut down my application in order to overcome this.
When I start the application again it starts working fine and then suddenly
same thing happens. I have searched a lot on net but this has become a
headache for me.

Could anyone help me out.

Sunil Pandita
Software Engineer
(OTS Solutions Pvt. Ltd. )