Coldfusion Administration:Adding Data Sources Error
* connection verification failed data source: online_store
[]java.sql.sqlexception: communication failure during handshake. there server running on localhost:3306?
the root cause that: java.sql.sqlexception: communication failure during handshake. there server running on localhost:3306?
thats message when try add mysql database using coldfusion admin page. never error when add access database.
where going wrong?
could or suggest something?
[]java.sql.sqlexception: communication failure during handshake. there server running on localhost:3306?
the root cause that: java.sql.sqlexception: communication failure during handshake. there server running on localhost:3306?
thats message when try add mysql database using coldfusion admin page. never error when add access database.
where going wrong?
could or suggest something?
1) mysql server running? localhost:3306 standadr port mysql. if have changed port number during mysql installation should change in dsn string in cf well. mysql server either not running or not configured properly.
2) mysql driver using? if trying set dsn standard mysql 3.x driver shipped cf, may have problem. go mysql.org , download latest mysql connector/j + instructions on how install , how configure dsn. bet not have error updated driver if mysql running , configured properly.
2) mysql driver using? if trying set dsn standard mysql 3.x driver shipped cf, may have problem. go mysql.org , download latest mysql connector/j + instructions on how install , how configure dsn. bet not have error updated driver if mysql running , configured properly.
More discussions in ColdFusion
adobe
Comments
Post a Comment