I've always used MySQL's JDBC driver, not ODBC. If you search Ben Forta's blog, there's an entry about MySQL 5 in CF, and this has good directions for getting it to work in the comments.
> -----Original Message----- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 2006 4:30 PM > > Anybody run across this before? The connection fails. I can > verify the datasource in windows but cannot verify in CF. > Also I do not see the myODBC after installing the connector, > is that by design? > > > Update CF Data Source Info > The ODBC data source XXX cannot be edited remotely. The > ColdFusion Administrator either does not support remote > editing for this driver [MySQL ODBC 3.51 Driver] or its > driver was not found on the server. > You can use the data source for ColdFusion development, > however you will have to edit the DS settings in the regular > ODBC administrator. > > You can still edit the ColdFusion settings for this > data source: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

