Skip to main content
C
ColdFusion2
Participant
July 8, 2014
Question

Connection verification failed for data source

  • July 8, 2014
  • 2 replies
  • 1869 views

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

This topic has been closed for replies.

2 replies

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
July 11, 2014

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.

Carl Von Stetten
Carl Von Stetten
Legend
July 8, 2014

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.

Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices