With Client variables, I believe you have to first have your datasource set up and working. THEN you go into the CFAdministrator and set up the Client vars.
It's a while since i set up Client vars, but if i recall correctly, it has to check the datasource when you 'submit' after changing the details of the client vars. One of hte options at that time is to let it create its own CFDATA and CFGLOBAL tables, and I'd recommend letting it do it. Then you know for sure its all going to work. But i dont believe client vars use any tricky sql at all, so it should work on any database that is avlid datasource for CF. It only does SQLinserts, deletes and selects. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/12/07, Dinner <[EMAIL PROTECTED]> wrote: > 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? :-/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4