Josh Nathanson wrote: > AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the > ODBC driver at all. It's called Connector/J I think, you have to download > it from the MySQL website -- here's the link:
I think you're confused. You cannot use the built in MySQL JDBC driver with MySQL 4/5 in Coldfusion - only 3.23 But ify ou're using MyODBC via the ODBC socket, you should be fine with that. That being said... the original poster said he couldn't verify the DSN in CF, but didn't specify an error... the message he posted looked like a message you'd get when trying to edit the settings. Ultimately though you're right. Using the MySQL JDBC driver from MySQL is the way to go... plenty of technotes on how to set them up using the "Other" datasource type. jdbc url: jdbc://localhost:3306/database_name driver class: com.mysql.jdbc.Driver driver name: MySQL 4.x Driver (or whatever) Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252456 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
