> 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

Reply via email to