MySQL 5 and ColdFusion MX 7 (New Problem)

Now I removed MySQL 5 and ran regClean to clean the registries. Then re-installed MySQL 5. Downloaded the Connectors/J for 5.0 from MySQL copied the mysql-connector-java-5.0.0-beta-bin.jar into CfusionMX7 \ wwwroot \ web-inf\ lib   folder. Restarted ColdFusion. Added the datasource using Other: jdbc:mysql://localhost:3306/myTest com.mysql.jdbc.Driver and now I have this error. Yes... MySQL is running on Port 3306 Yes... I can connect to MySQL 5.0 using NaviCat using Localhost:3306 Any ideas?

what error? ----- Excess quoted text cut - see Original Post for more -----

Guess that would help java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection what error? ----- Excess quoted text cut - see Original Post for more -----

Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class   path? You have to restart CF after you add it so that the jdbc driver gets   loaded in. Here is a link to how to install the postgress driver. The mysql   setup should be similar. http://cfguru.daemon.com.au/archives/000082.html Dave

Yes, it is displayed under System Information in CF Admin Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/000082.html Dave

In your users table do have your machine or sub-net entered to accept   a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then   jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would   need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't   sound like a CF issue but a network issue. Is the machine that you   are using Navicat to connect with also the machine you have CF   installed on? The only other thing I would suggest is check the cf and mysql logs   to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: ----- Excess quoted text cut - see Original Post for more -----

Localhost is where the MySQL Database is at. It is all one machine In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: ----- Excess quoted text cut - see Original Post for more -----

I have CFMX7, MySQL 5.0 and NaviCat all running locally Localhost is where the MySQL Database is at. It is all one machine In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: ----- Excess quoted text cut - see Original Post for more -----

Mysql5, CF7, Win2003 all work together when using I recomend Connector/ODBC 3.51 I would say the 5.0 beta drivers are causing the issue. Casey

> Mysql5, CF7, Win2003 all work together when using > > I recomend Connector/ODBC 3.51 This is awful advice. To use the ODBC drivers for MySQL, you have to install the ODBC services and go through the JDBC-ODBC bridge. > I would say the 5.0 beta drivers are causing the issue. They're alpha (Connector J/5.0), so rolling back to the production Connector J/3.1 drivers should be your first choice, unless there's something very specific you need from the 5.0 drivers. > > Casey

Eeegadds My bad. I quickly went down the lsit and just wasn't paying attention to what I copied and pasted. I blame this on not enough coffee or too much coffee. Yes mysql-connector-java-3.1.12-bin.jar is the connector your looking for. MySQL Connector/J 3.1 Sorry about that. Casey ----- Excess quoted text cut - see Original Post for more -----