Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Mon, 03 Mar 2008 08:50:25 -0800 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Is there any way to know oracle connection is invalid when some one is trying to shutdown oracle service References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1204563024.867965@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@dsl-216-162-218-178.drizzle.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 32 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.server:442060 X-Received-Date: Mon, 03 Mar 2008 11:50:25 EST (text.usenetserver.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@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org