Yes. The CF server's hostname (as in IP, or machine name), has to be "attached" to the username in MySQL with which you are trying to connect from CF server. If you list the users table in MySQL you will see that by default "root" is set up to connect only from "localhost." MySQL documentation describes how to add remote users, it's on their site. ----- Original Message ----- From: "K" <[EMAIL PROTECTED]> I have a MySQL server running on a FreeBSD box, serving up a simple DB w/one table. I am trying to get my Wintel box running W2K and CF Server to see the DB on the MySQL Server. For good measure, my copy of CF Studio is also on the W2K server (development environment). I have installed MyODBC on the W2K machine and set up a User DSN and System DSN for the MySQL DB to the best of my knowledge. The Connection shows up in CF Admin, but will not Verify. Also, I'm not entirely sure how to set up a connection to a remote RDS server through Studio. I'm an MySQL newbie, novice with CF (but steadily learning more each day). Are there some settings that I have missed? Any help would be better than where I am now. Thanks in advance. Kevin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
