CODEWITHSUNDEEP
coldfusion-10
sudhanshu balaiya
sudhanshu balaiya

Reputation: 43

connection verification failed for data source - Coldfusion Server Administration

I have just installed ColdFusion 10 and am trying to connect to MySql Server 5.1, but it is showing the error below:

Connection verification failed for data source: cfartgallery2 java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: MySQL Server The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Unknown host: MySQL Server

Upvotes: 1

Views: 2623

Answers (1)

sudhanshu balaiya
sudhanshu balaiya

Reputation: 43

Finally after 2 days I solved my own problem of getting the above error. It was due to a missing ODBC connector.

Steps for resolving:

  1. First download and install the ODBC connector of respective version as of your MYSQL server version.
  2. Rhen install vcredist_x64 it is required for sql connectivity.
  3. Then install any SQL Server to create the database and start connecting to it with the datasource you have created in tour CF Administrator.

Hope you can solve your problem with my instructions , if not then please post your queries below.

Upvotes: 1

Related Questions