Hi John, try to change the value for "max_connections" in the [mysqld] section of the MySQL-Configuration File, called "my.cnf" (or "my.ini") from the standard value:
[mysqld] ..... max_connections = 100 ..... TO [mysqld] ..... max_connections = 300 ..... MySQL should handle it easily :-). Also take a look in CF-Administrator for your Data Source configuration. Watch out, that you did NOT limit the connection under "Show Advanced Settings" -> "Limit Connections" for your Data Source. Best regards Knut ----- Original Message ----- From: John Barrett To: CF-Newbie Sent: Monday, August 18, 2008 9:42 AM Subject: database error? Hi, I got a strange error today about too many queries? I say it is strange as this as not happened to me ever before. The Error says, "Error Executing Database Query. Data Source rejected establishment of connection, message from server:"Too many connections" The error occurred in: /Users/cfuser/Sites/Testing/sendemail.cfm line9 7: SELECT* 8: FROM daily_tip 9:WHERE tipdate = #tipdate# 10:</cfquery> this is just the default cf error page. I got post the whole file here, but it is pretty large. My real question is how many connections am I allowed? I was trying to figure out how to get database results and send them to an email by default. I did figure this out, and when I was just about done I kept getting this error. Could this my an issue with MySQL, or is it a CF error. This was done on my Mac at home, and will test it later to see if the error is still happening. I came to school tonight to test more, but having lots of issues with CF on windows. I think that the machines here are too old, or something. Thanks so much, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3929 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
