| View previous topic :: View next topic |
| Author |
Message |
Raigo
Guest
|
 Posted: Thu May 17, 2007 12:13 am Post subject: Checking Interbase server availability from IBX and ISAPI |
 |
|
Delphi 7 ISAPI-WebBroker application. connecting to remote Interbase
database over IBX.
problem is when database server is unavailable for network problems etc.
how to check from application it is there? Another problem is that if DB
server has been restarted the ISAPI application also needs restart.
is there a way to check DB server availability from code? how?
I have in WebModule.BeforeDispatch event
if IBDataBase1.Connected=false then IBDataBase1.Connected:=true;
but this won't help against DB server restart. |
|
| Back to top |
|
 |
Jason Southwell
Guest
|
| Posted: Mon May 21, 2007 2:25 pm Post subject: Re: Checking Interbase server availability from IBX and ISAP |
|
|
| Quote: | Delphi 7 ISAPI-WebBroker application. connecting to remote Interbase
database over IBX.
I have in WebModule.BeforeDispatch event
if IBDataBase1.Connected=false then IBDataBase1.Connected:=true;
but this won't help against DB server restart.
|
In the ADO components, I handle the OnAfterExecute event and check for an
error code. If I find the code that means disconnected, then I disconnect
the database component so that the next access will restart it.
Don't know how to do it in IBX though but there might be something similar. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
