Hi,
I have a problem with my site. My application can use either oracle or mssql database.
My problem is the following:
my application can connect to the database without problem. If I stop and restart the database, the connection is lost and there is no way reconnect to the database. I'm obliged to stop and restart the web server.
I'd like not to be forced to restart my web server when the database is restarted.
Can any one know how to correct this problem?
I connect to oracle with oci8 extension, and to mssql with mssql extension.
I use adodb as abstraction db layer.
I use IIS 5.1 or apache 1.3 as web server.
OS: win XP
Thanks.
database connection lost
Moderator: General Moderators
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Why do you need to restart the database server? And I think you can check for the existence of a database link identifier (usually returned through the *_connect() functions) and if that is not there, then reconnect. I would also suggest some error reporting from the database so it can tell you what error it is experiencing so you can troubleshoot.