>
>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

Reply via email to