database connection lost

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kalamou
Forum Newbie
Posts: 1
Joined: Mon Aug 28, 2006 11:14 am

database connection lost

Post by kalamou »

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.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

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.
Post Reply