On 3/11/07, Jonathan B wrote: > I'm trying very hard to figure out how to get MySql 5 to work with CF client > variable storage. I need that... its a requirement. Has anybody done it > before? The CF administrator does not have it built in, and when I try to > manually create CFDATA and CFGLOBAL, my front end app errors out with a > "500" database error.
I know it works. I'm not sure what your problem is specifically tho. Doesn't have what built in? The mysql5 driver? You'll need to go and download a newer version from the mysql.com site. I think 3.0.17-ga is the "newest" that won't slow you down with the varchar strangeness*. Then you can use "other" when specifying a DSN type, and configure the datasource for mysql 5. *varchar strangeness is the added milliseconds for each varchar field included in the result set. Actually, I think maybe the updated datadirect drivers might have a newer mysql one? If you haven't gotten them from Adobe already, you should. Anyways, I'm not even sure if that's what you're having troubles with. Wanna clarify? Maybe try dropping the table, and running the create script from CF admin again? :-/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
