> >Well anyway, I guess it works thru odbc so I should move on to other problems. >lol! >
Not in a production environment! I would use the JDBC-ODBC bridge only in dire circumstances - there is a lot of processing going on that would not be necessary with straight JDBC. So, a few questions: Are you sure you are running MySql on 3307 (you can confirm via. netstat on windows). The default MySql port is 3306 Have you granted rights to the database for your user, and can they connect from the host you are trying to connect from (even if you are connecting locally, the name of your computer will be the "host" in this case - easiest to just grant rights to user@'%')? If all else fails, you can download a generic SQL client (like SquirrelSql) to eliminate CF from the equation. I've had similar issues getting CF to connect to MSSQL locally over TCP/IP and each time it was related to the DBMS config. HTH, Dave Ross http://www.coldspringframework.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

