Re: CF -> mySQL (and OT from there)

2009-01-19 Thread daniel kessler
Those are good points. Thank you very much. It's way past time I learned the management side of CF anyway. I'm sure it'll be good for me. thanks for taking the time to respond. daniel ~| Adobe® ColdFusion® 8 software 8 is th

Re: CF -> mySQL (and OT from there)

2009-01-19 Thread Barney Boisvert
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. Contro

Re: CF -> mySQL (and OT from there)

2009-01-19 Thread daniel kessler
> 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

Re: CF -> mySQL (and OT from there)

2009-01-19 Thread Barney Boisvert
CF can connect to a database on a remote box - that's the way pretty much everything is set up, except on shared hosting where you usually have a single box filling both roles. With separate boxes you can scale the two halves separately, which is quite important as your resource needs grow, becaus

CF -> mySQL (and OT from there)

2009-01-19 Thread daniel kessler
I'm trying to learn to set up a mySQL database. Does CF have to be on the same machine/server for it to talk to the mySQL database? I'm also not sure if I have to set up a web server for anything to talk to the database or can I just give it an IP that the database is on, somehow. Finally, ca