Hi, I appear to have an unstable connection to our MySQL database. Sometimes it works and others it fails and need resetting (causing us significant downtime). My technical support person has thought it is because we are exceeding the maximum number of connections to the MySQL database but I'm not so sure. He increased it to 2000 connections but it's gone down again.
A little history. We have recently changed to a new hosting company (see other thread on this board). We took a little while to get set up but then it was working fine and members were happy with the faster forums. However, now it keeps failing because of "too many connections" (the error message is on other thread). Now, before I change the DNS of our domain, all I have done is modified the forum/default.asp file on my old host so that it does a "meta redirect" to the forum folder on the new hosting company. This seems to work fine and takes users to the new forum. So, currently the DNS still points to the old site (not sure if this is an issue?). The new forum has worked fine until these recent connection issues.
I also notice that we are using "localhost" as the server name. Is this a potential problem? I think the database may be on a different server. Should I put the IP address instead?
strSQLServerName = "localhost" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "####" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "####" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "####"
Thanks
Topic Options
Post Options
Thanks(0)
