Yeah, if you don't have the DSN config available to you, you're kind of stuck. You can sort of fake it by manually doing your own JDBC connections, but that's a disaster waiting to happen. If you've got the ability to do it locally on your own hardware, I'd highly recommend that approach. Controlling your own stack from top to bottom is WAY better than having to deal with other people's stuff, especially when you're learning/playing.
cheers, barneyb On Mon, Jan 19, 2009 at 10:24 AM, daniel kessler <dani...@umd.edu> wrote: >> When you set up the CF DSN one of >>the fields is for the DB server, just add the IP (or name if you have >>one) of the server and the port number (probably 3306) and you should >>be good to go. > > okay. I see. In my case, I'm in a shared hosting environment where CF and > Oracle are given to me. I don't have access to the management of either, > except as a user. So I couldn't point the CF to my mySQL database on another > machine. I was hoping that there was a way as a CF user I could do that for > certain queries. It sounds like that's a no. So to learn mySQL, it seems > that I should also install the CF single-user server on my Mac OSX. I guess > I should then go the whole route and enable the Apache that comes with the > machine. > > > daniel > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4