How do I make a connection to a MySQL database using ColdFusion?

1
votes

I have Adobe ColdFusion 10 installed on my computer and registered with a free website on 000webhost.com. However, when I tried to connect I got this error:

Connection verification failed for data source: ssss
java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection

This is what I typed in the ColdFusion connector:

  • CF Data Source Name: ssss
  • Database: a9156701_25
  • Server: mysql3.000webhost.com Port 3306
  • Username: a9156701_sayood
  • Password: *******

I don't know if the problem is with the free web host or the way I added the data source.

1
mysqlsqlweb-servicescoldfusion

1 Answers

5
votes

Your datasource looks correct. You are not allowed to connect remotely to the database. I found this mentioned in their forums:

11-12-2013, 05:45 PM: Are you trying to connect remotely? (not allowed) Your files have to be on the server.