Re: Is there any way to know oracle connection is invalid when some one is trying to shutdown oracle service

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 03 Mar 2008 08:50:25 -0800
Message-ID: <1204563024.867965@bubbleator.drizzle.com>


vijay wrote:
> Platform : VC++ 2005
> Datababse : Oracle, SQLServer, MS Access
> OS : XP, Window 2003
>
> Hi,
>
> I have developed an application which uses OleDb to open connection.
> Once
> connection is open program cache this connection for further use. Some
> time
> connection become invalid. To validate connection I am using
> DBPROP_CONNECTIONSTATUS property. During shutdown of oracle service
> sql query fails whenever DBPROP_CONNECTIONSTATUS returns valid
> connection. Is there any way to know oracle connection is invalid when
> some one is trying to shutdown oracle service?
>
> Thanks in advance.
>
> Vijay Singh
> EDISPHERE
Take your question to Microsoft or the appropriate forum at http://otn.oracle.com. It has nothing to do with the Oracle database server.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Mar 03 2008 - 10:50:25 CST

Original text of this message