2 Replies Latest reply: Jul 11, 2014 5:47 AM by BKBK

Connection verification failed for data source

ColdFusion Jul 8, 2014 2:08 AM

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

1. Re: Connection verification failed for data source

Carl Von Stetten Jul 8, 2014 8:47 AM (in response to ColdFusion)

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.
Like Show 0 Likes (0)

Actions
2. Re: Connection verification failed for data source

BKBK Jul 11, 2014 5:47 AM (in response to ColdFusion)

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.
Like Show 0 Likes (0)

Actions

Go to original post

Legend

Correct Answers - 10 points