ASP Errors

[Gary Williams]

Hi All,

My latest ASP/MySQL application is working fine, but on my local PC and one commercial hosting package (used for my development purposes), no errors are reported. However, on my main commercial hosting server, I get many errors, mainly covering two types of error:

1. The max_user_connections to the mysql database, and,
2. operation not allowed when object is closed.

My problem is that I can't get these errors reported on my local PC. How can I get the IIS Events Manager to see/record these error events? Also, is it possible to reduce the max_user_connections allowed on my local PC's mysql database?

Regards

Gary

[Old Pedant]

Well the "operation not allowed when object is closed" should be relatively easy to track down. That's purely the result of some simple codign error.

Put in plenty of Response.Write statements and you'll eventually track it down.

As for max_user_connections: Sure. From a command prompt (or, if needed, from your ASP code, I guess):

mysql> show variables like 'max_user_connections';
mysql> set global max_user_connections = 2;