Fatal error: Too many connections

I haven't seen this for a while.

I have an ecommerce site with ecart 5 (php. mysql) and I uploaded the files to my testing server today.
After a short amount of testing, i got the error above

I have been building the site a testing locally with no issues.

all of my recordsets use a standard connections file, and all are 'freed' after the closing html tag.

I suspect the problem may lay with my hosting provider, but are there any tests/checks I can do, or steps I can take to help alleviate the problem ?
thanks

Try adding this piece of code to the page you are getting the error:

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
if (mysql_errno() == 1203) {
// 1203 == ER_TOO_MANY_USER_CONNECTIONS (mysqld_error.h)
header("Location: http://your.site.com/alternate_page.php");
exit;
}
?>

i got that code from this page:

too-many-connections.html

It is definitely something that you would have to resolve with your hosting provider. Unless there is a loop that is trying to connect to the database every time which i don't think it is the case here.

I have also heard some people report overcoming this error message by avoiding persistent connections in their connection files by using 'mysql_connect' rather than 'mysql_pconnect'.

thanks for the replies.

my testing area is on a shared server, and I suspect that access the the sql server is shared with lots of other users, so the problem may not be mine, but due to other traffic.

(If anyone can enlighten/contradict this, I would like to know)

It seems to be OK now, but when you are delivering something to a client, it doesn't exactly enhance your reputation if your site goes down!!