MySQL - CFMX7

[centralcan]

Silly question;

Im trying to use the below CF query. to connect to a MySQL DB.
<cfquery NAME="Main1"
DBTYPE="dynamic"
CONNECTSTRING=" Driver={mysql};Server=mysql5.secureconnect.ca;
Database=centr10_bsc;Uid=user;Pwd=pass;">

i get the following CF error:

Attribute validation error for tag query.
The tag does not have an attribute called CONNECTSTRING. The valid
attribute(s) are name, datasource, dbtype, sql, username, password, maxrows,
blockfactor, timeout, dbname, cachedafter, cachedwithin, result, debug.

any ideas?

thanks for your time.

robin,.

[mxstu]

ConnectString is deprecated (see
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0000213.htm.). Why not just
created a datasource?

[centralcan]

its a remote database not located on the server where the site is stored.

ill take a peek through the url you provided to see if that information will fix the issue. thanks for your remarks.

[mxstu]

I'm not sure which version of mySQL you are using. I've never tried this, so
it may not even be possible. However, I know you can use MySQL Connector/J
with MX6.1/7 to connect to a version 4.1.x database. When you set the
properties for a datasource in the CF Administrator, you specify a "JDBC URL".
In theory a JDBC URL does allow you to connect to a remote database. I don't
know if other settings in CF would prevent this from working, but it might be
worth a shot.

Here is an example of my settings in MX 6.1

CF DataSource Name: mySqlDSN
JDBC URL: jdbc:mysql://127.0.0.1:3306/myTestDB
Driver Class: com.mysql.jdbc.Driver
Driver Name: MySQL Connector/J
Username: myUserName
Password: ************

In theory, you would change the JDBC URL to point to the remote server address
and port number. Of course even if this does work, you should definitely look
into the security issues of using this method.

[Walt1986]

I am trying to connect a datasource using MySQL 4.0 to CF MX 7.0 and are
getting the following error.

Connection verification failed for data source: chenegaportal
java.sql.SQLException: Communication failure during handshake. Is there a
server running on 127.0.0.1:3306?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on 127.0.0.1:3306?

Perhaps I am entering the incorrect driver info or doning something wrong in
the process. Does anybody know have step-by-step directions to guide me.
Thank.....!!

[mxstu]

See technote
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

Some people have had issues with the mySql connector-J 3.1.10 jar, so you may
want to use another version. You can find them on the FTP mirror sites. Just
look for 3.0.17ga or 3.1.17 versions of the jar. Here are two ftp mirror sites
I got
from the mysql.com list:

[url]ftp://ftp.orst.edu/pub/mysql/Downloads/Connector-J/[/url]
[url]ftp://mirror.services.wisc.edu/mirrors/mysql/Downloads/Connector-J/[/url]