> 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:318183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4