The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
HI
I am receiving the following error, which has rendered the forum unavailable for approx 36 hours. The web host are saying there is nothing they can do and it's down to the scripting.
Provider error '8000ffff'
Catastrophic failure
/inc_header.asp, line 134
Line 134 is the Open database command. They claim that there are too many open threads on the database and they have not been closed down properly. So now nothing else can connect.
I have checked the DB through PHPMyAdmin and all seems ok. I threw together a quick mysql_close($db_handle) scriipt but guess this wont help as it's not going to tie into a thread that it didnt open itself?
Please help
I am receiving the following error, which has rendered the forum unavailable for approx 36 hours. The web host are saying there is nothing they can do and it's down to the scripting.
Provider error '8000ffff'
Catastrophic failure
/inc_header.asp, line 134
Line 134 is the Open database command. They claim that there are too many open threads on the database and they have not been closed down properly. So now nothing else can connect.
I have checked the DB through PHPMyAdmin and all seems ok. I threw together a quick mysql_close($db_handle) scriipt but guess this wont help as it's not going to tie into a thread that it didnt open itself?
Please help
Posted
That is a server issue. It may be related to the specific driver they are using or to other stuff. You can try a different driver, by specifying a different connection string, but even if that works, it's bound to be a temporary solution.
Situations like this, can easily be solved by the host. If they don't help, I suggest that you consider getting a different one.
Situations like this, can easily be solved by the host. If they don't help, I suggest that you consider getting a different one.
Posted
Originally posted by ruirib
That is a server issue. It may be related to the specific driver they are using or to other stuff. You can try a different driver, by specifying a different connection string, but even if that works, it's bound to be a temporary solution.
Situations like this, can easily be solved by the host. If they don't help, I suggest that you consider getting a different one.
Thanks as always, ruirib. I'll feed this back to them. Is this possibly a change in MySQL version, or just a driver update?
Posted
This has nothing to with the MySQL version. MySQL drivers are not the best code that was ever created and such situations crop up sometimes.
Trying a different driver is something you can try, by changing the connection string, but that may solve this or not. If the host resets IIS, this will go away, at least for a while.
Trying a different driver is something you can try, by changing the connection string, but that may solve this or not. If the host resets IIS, this will go away, at least for a while.
Posted
Originally posted by ruirib
This has nothing to with the MySQL version. MySQL drivers are not the best code that was ever created and such situations crop up sometimes.
Trying a different driver is something you can try, by changing the connection string, but that may solve this or not. If the host resets IIS, this will go away, at least for a while.
Thanks. The host have written a brief script to check the connection to the database and claim there is no issue.
What other driver options can I attempt in the connection string? I thought we had leave that at the MySQL 3.5.1 driver regardless. This has been functioning fine for me for 10 years so i'm baffled as to what has occured. I've asked the Host if they have updated any drivers lately, but expect they will deny anything.
Thanks again.
Posted
The host refusal to acknowledge the issue is astounding. Been there and an IIS reset will solve the issue.
You should also ask the host precisely that - how come it has worked for 10 years and now you claim this? And how come the site is not working and they can't do nothing about it?! What are you supposed to do?
There is a 5.1 version driver. Not sure if the host has it installed. Probably not. If not, you have to pressure them to solve the issue for you.
There is a 5.1 version driver. Not sure if the host has it installed. Probably not. If not, you have to pressure them to solve the issue for you.