Adobe Community: Message List - Connection verification failed for data source

Re: Connection verification failed for data source

forums_noreply@adobe.com — Fri, 11 Jul 2014 12:47:41 GMT

You certainly filled in incorrect values in the form on the datasource page of the Coldfusion Admnistrator. If the problem persists, make a printscreen of the values you fill in the form. We would be glad to discuss it.

Re: Connection verification failed for data source

forums_noreply@adobe.com — Tue, 08 Jul 2014 15:46:24 GMT

Why are you using ODBC to connect to MS SQL Server or MySQL? Use the provided JDBC drivers - they are faster and more reliable than ODBC. Consider ODBC a database connection method "of last resort" (i.e., only when a JDBC driver isn't available).

-Carl V.

Connection verification failed for data source

forums_noreply@adobe.com — Tue, 08 Jul 2014 09:08:27 GMT

Hi, I'm trying to connect to a MS SQL2000 and a MYSQL server with CF11.

System WIN7, Apache32, bit CF11 32 bit, the error message is.

Connection verification failed for data source: picos

java.sql.SQLException: [Macromedia] [SequeLink JDBC driver] [ODBC socket] internal error: the data source name not found and no default driver specified

The root cause what that: java.sql.SQLException: [Macromedia] [SequeLink JDBC driver] [ODBC socket] internal error: the data source name not found and no default driver specified

What can I do? Thank you for an answer.

friendly greetings

Jochen Vetter