> 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.
This is just on my development machine. > > 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 I'm positive it's runnin on 3307. mySQL admin is showing the info under server information > > 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@'%')? I've tried it a few different ways. I used the root user login info, and also created a new one. Neither worked. > > 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. > k gotcha. I might just let it ride since it's my dev machine and I can make it work. Sometimes the more I do, the more I go in reverse. heeheehee! Thanks a ton Dave! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245477 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

