I have CF running on win98 against MySQL/OpenBSD and it works fine. you have to set up user acct and privledges in MySQL. I thinks its hosts, users, some other stuff. Also everything is CASE SENSITIVE (tables, fields, ...). And try to get a connection through an ODBC testing tool first then try to get it with CF. For a front end link to MySQL through MSAccess. K <[EMAIL PROTECTED]> wrote: 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 Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
