CF Server 5 and MYSql

[DrumzCT]

I've seen similar question from searching but not quite exactly the problem I'm
having. I installed myodbc to my webserver fine.

When I went to the site url to test it i got an error that said "odbc error
data source not found and no default driver installed"

So after much seraching online I can't seem to find anything that will add
MYSQL to my coldfusion server odbc list. This is in the CF Admin under ODBC.
The drop down has most odbc drivers in there already.

Anyone know where I can download/install this?
Thanks in advance.

[cf_menace]

CF 5 for WIndows doesn't ship with a MySQL Driver. CF 5 for Linux does.

I'm assuming you're on WIndows, so first go get the
[url]http://www.mysql.com/products/connector/odbc/[/url] driver and install it.

Then go to Control Panel > Administrator Tools > Datasources (ODBC)

Create a SYSTEM datasource (not a USER one). Fill in all the relevant
information. Once it's created, go back to CF Admin and you'll see the MySQL
datasource available in your list of datasources.

[DrumzCT]

Thanks so much! It worked great.

One final hurdle.

I tried to verify the connection through CF Admin and it came up with a
"connection failure" error.

It said a few things to check in the configuration which I know are fine. Then
it said something about setting CF up with a special account.

Not sure if it means on the CF server or the server hosting the MYSQL database
or what.

[DrumzCT]

Actually scrap that. Just tested the URL and the sites working fine. Not sure why CFAdmin cant verify but it doesn't seem to be causing any problems.

Thanks for the help!