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

SQL Query on an XMLObject CaseSensitive Resultset

forums_noreply@adobe.com — Fri, 19 Apr 2013 15:50:26 GMT

Hi there,
I make a SQL query on an object with dbtype = query
<cfquery name="qry_catalog" dbtype="query">
SELECT * FROM catalog query
WHERE country LIKE '# art #'
</ cfquery>

What also goes without problems, interestingly, the query takes only results when the Upper / lower case is correct.
e.g. Search for "UK" brings 13 records from the XML object "uk" no.

I have never read that it is case-sensitive.

I'm open to all suggestions.

Thank you greeting Jochen

Adobe Community : All Content - All Communities

Connection verification failed for data source

SQL Query on an XMLObject CaseSensitive Resultset