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
نوشته شده در
Well, if they don't do something, this won't be solved. A script doesn't mean anything. If it is php, for example, shouldn't have a problem at all connecting to the database. It's even possible that even if they use asp and do it through another driver or on a site using another app pool, that all will be well.
This is their fault. If they don't solve it, I think your only option is to ditch them.
This is their fault. If they don't solve it, I think your only option is to ditch them.
نوشته شده در
You might double-check your line number, that error message is often caused by email code errors too.
Also often if a site updates the mysql version they will also update the mysql drivers version. I'd verify with your host what the mysql ODBC drivers version is that's installed.
Also often if a site updates the mysql version they will also update the mysql drivers version. I'd verify with your host what the mysql ODBC drivers version is that's installed.
نوشته شده در
Originally posted by Doug G
You might double-check your line number, that error message is often caused by email code errors too.
Also often if a site updates the mysql version they will also update the mysql drivers version. I'd verify with your host what the mysql ODBC drivers version is that's installed.
Thanks, Doug
The line number is definately just the open command. I have a number of mods installed which may have changed the line number from the standard install.
I'll see if they will reveal the driver version.
Thanks all.
نوشته شده در
The host have returned to me with the following:
The driver version of Mysql is "PDO Driver for MySQL, client library version 5.0.51a".
Also, there is a bunch of information for their servers held here:
http://win.streamlinetrial.co.uk/phpinfo.php
It shows info on the MySQL and ODBC as well as a bunch of server variables, not not quite sure what I should look for to identify any incompatabilities or elements to go back to them with.
Any help very much appreciated
The driver version of Mysql is "PDO Driver for MySQL, client library version 5.0.51a".
Also, there is a bunch of information for their servers held here:
http://win.streamlinetrial.co.uk/phpinfo.php
It shows info on the MySQL and ODBC as well as a bunch of server variables, not not quite sure what I should look for to identify any incompatabilities or elements to go back to them with.
Any help very much appreciated
نوشته شده در
Well, no surprises there. That's info for php and you are not using php. PDO means PHP data objcts is of absolutely no use to access a MySQL database using ASP.
نوشته شده در
Just to close this one off... the forum is back working again. Apparently, the issue was due to being on a busy "application pool". The host now moved to a less-busy pool and all is well again!
Thanks to all for all the help and support
Thanks to all for all the help and support
نوشته شده در
I am glad it's sorted. It was a server issue, all along, as I said. Too bad it took them so long to sort.
نوشته شده در
Ditto, I'm glad you got things working.