Re: Is there any way to know oracle connection is invalid when some one is trying to shutdown oracle service
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.orgReceived on Mon Mar 03 2008 - 10:50:25 CST
