For all those who either had attempted to help or are/have
had the same problem, this is how I resolved my issue.
Somewhat drastic but it works just fine now:
1. Removed CFMX 7
2. Removed MySQL 5.0
3. Rebooted machine
4. Re-installed CFMX 7
5. Reinstalled MySQL 5.0
6. Downloaded mysql-connector-java-3.1.12-bin.jar from MySQL.com
7. Extracted the mysql-connector-java-3.1.12-bin.jar file into the following
directory:
D:\CFusionMX7\wwwroot\WEB-INF\lib
8. Rebooted machine.
9. in CFMX Admin, enabled SandBox Security,
Set all access to datasources and with Ips set to connect, resolve.
10. Create ODBC using "Other" with the following parameters:
JDBC URL: jdbc:mysql://localhost:3306/mindkeeper_support
DRIVER CLASS: com.mysql.jdbc.Driver
Database: {database to connect to}
Username: {self-explanatory}
Password: {self-explanatory}
And it authenicated just FINE :-)
Thanks for everyone's HELP!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231552
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
