Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SqlDisconnect fails permanantly when database goesdown

Status
Not open for further replies.

sakalk

Programmer
Dec 20, 2005
1
SE
Hi,
I connect to Oracle using SQLBase - SqlConnect, then at the end of application call SqlDisconnect. It all works fine but if the database goes down suddenly or my network connection has failed then the SqlDisconnect comes back with error. And there is no way out. Even when the database comes back the handle is invalid. So is there a way to recover it ? I mean sort of forcefully close this handle? Unless I close it I cannot open another too! Any comments appreciated.

Thanks
SaKa
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top