Connection verification failed for data source

[ColdFusion2]

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

[Carl Von Stetten]

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.

[BKBK]

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.