CF 7 data source error with MySQL 4.1

[Shane930]

Ok, I am struggling here. I have read everything I could find on hooking up to
MySQL on a local machine and I am still getting this error. I followed tech
note 6ef0253, and read through quite a few others. Any help would be
appreciated. Thanks

Connection verification failed for data source: saamysql
java.sql.SQLException: No suitable driver available for saamysql, please check
the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available
for saamysql, please check the driver setting in resources file, error: null

Here is my data source info:

CF Data Source Name: saamysql
JDBC URL: jdbc:mysql://local/saa
Driver Class: com.mysql.jdbc.Driver
Driver Name
User Name root
Password **************
Description

Shane930

[Shane930]

Ok, I am struggling here. I have read everything I could find on hooking up to
MySQL on a local machine and I am still getting this error. I followed tech
note 6ef0253, and read through quite a few others. Any help would be
appreciated. Thanks

Connection verification failed for data source: saamysql
java.sql.SQLException: No suitable driver available for saamysql, please check
the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available
for saamysql, please check the driver setting in resources file, error: null

Here is my data source info:

CF Data Source Name: saamysql
JDBC URL: jdbc:mysql://local/saa
Driver Class: com.mysql.jdbc.Driver
Driver Name
User Name root
Password **************
Description

Shane930

[mpwoodward *TMM*]

On 2005-05-16 14:09:05 -0500, "Shane930" <webforumsuser@macromedia.com> said:

> Ok, I am struggling here. I have read everything I could find on
> hooking up to MySQL on a local machine and I am still getting this
> error. I followed tech note 6ef0253, and read through quite a few
> others. Any help would be appreciated. Thanks
>
> Connection verification failed for data source: saamysql
> java.sql.SQLException: No suitable driver available for saamysql,
> please check the driver setting in resources file, error: null
> The root cause was that: java.sql.SQLException: No suitable driver
> available for saamysql, please check the driver setting in resources
> file, error: null
>
> Here is my data source info:
>
> CF Data Source Name: saamysql
> JDBC URL: jdbc:mysql://local/saa
> Driver Class: com.mysql.jdbc.Driver Driver Name User Name root
> Password ************** Description
> Shane930

If you have MySQL running on the same server as CF, try changing
"local" in your JDBC URL to "localhost" or "127.0.0.1". The "No
suitable driver" error typically means it can't find the driver (are
you sure you put it somewhere in CF's classpath?), but I'd change the
URL first and see what happens because I doubt that "local" means
anything to CF.

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Shane930]

Thanks Matt, I found the problem. It was in the class path. Thank you for your reply.