Coldfusion + MySQL + MyODBC > How to work?

[rninja]

I have installed coldfusion. Works properly. I have also installed MySQL. Also works great. I even have MyODBC installed.

But now I want to get them conversing with one another. I need to have a website with database access, and to learn the coldfusion database conectivity is neccessary.

Does anyone know how to get MyODBC working? In the Coldfusion administrator, I set-up the datasource and the options for coldfusion however, when I try to validate the connection, coldfusion reports:

Error Diagnostic Information
ODBC Error Code = IM003 (Specified driver could not be loaded)
Specified driver could not be loaded

What do I need to do or change or install?


Rninja

 

[tleish]

Here's some information, but you may be allready familiar with it.

http://www.iserver.com/support/virtual/coldfusion/mysql.html

They also make meantion of that MySQL databases need to be in ALL CAPS in order for them to work properly with ColdFusion.

http://www.allaire.com/Handlers/index.cfm?ID=16050

- tleish