Welcome to my wild goose chase over the last week :pirate3: I am having a beast of a time trying to get Coldfusion to work properly with mySQL.
After successfully creating a database and specifying log-in and password, I tried to register the database through the ColdFusion administrator and received the following error:
[SIZE=1][COLOR=red]Connection verification failed for data source: learningcoldfusion[/COLOR][/SIZE]
[SIZE=1][COLOR=red]java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? [/COLOR][/SIZE]
[SIZE=1][COLOR=red]The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?[/COLOR][/SIZE]
Then…I was directed to this link:
[COLOR=#464646]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/COLOR]
which I followed explicitly, only to receive this error:
[SIZE=1][COLOR=red]Connection verification failed for data source: learningcoldfusion [/COLOR][/SIZE]
[SIZE=1][COLOR=red]java.sql.SQLException: No suitable driver available for learningcoldfusion, please check the driver setting in resources file, error: null [/COLOR][/SIZE]
[SIZE=1][COLOR=red]The root cause was that: java.sql.SQLException: No suitable driver available for learningcoldfusion, please check the driver setting in resources file, error: null[/COLOR][/SIZE]
Basically, ColdFusion administrator will not let me register my “mySQL” database as a data source, even though mySQL has told me that it was created successfully. why might this be? has anyone come across this??
Fitz
