Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

vijay

unread,
Mar 3, 2008, 5:20:30 AM3/3/08
to
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

DA Morgan

unread,
Mar 3, 2008, 11:50:25 AM3/3/08
to

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
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

0 new messages