MySQL/ColdFusion MX 7 (RESOLVED)

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

Glad you solved your problem > Set all access to datasources and with Ips set to connect, resolve. > > 10. Create ODBC using "Other" with the following parameters: BUT YOU DIDN'T SET AN ODBC!!! You created a CF datasource. Every time you call it an "ODBC" you make troubleshooting more confusing. CF uses, as well all know, *J*DBC -- and you use the ODBC Socket *JDBC* connection if you actually need ODBC connectivity. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) ashenfelterj@transitionpoint.com

My apologies John. I had tried both ways using the ODBC using the Selection of MySQL(3.x) as well as Other (JDBC). However, I did use the "ODBC" settings within the Control Panel to rule out the issues Governing the Port, Username, and password for the MySQL Database Server as well as to confirm that the server was in fact running. Glad you solved your problem > Set all access to datasources and with Ips set to connect, resolve. > > 10. Create ODBC using "Other" with the following parameters: BUT YOU DIDN'T SET AN ODBC!!! You created a CF datasource. Every time you call it an "ODBC" you make troubleshooting more confusing. CF uses, as well all know, *J*DBC -- and you use the ODBC Socket *JDBC* connection if you actually need ODBC connectivity. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) ashenfelterj@transitionpoint.com

> My apologies John. I had tried both ways using the ODBC using the > Selection of MySQL(3.x) as well as Other (JDBC). Again, not to be a pain, but no you didn't set up an ODBC. You set up a MySQL(3.x) JDBC datasource. Then you set up an Other JDBC datasource using the mysql connector/j. Mixing ODBC and JDBC really makes following the thread confusing. Repeat it with me "I set up a *DSN*" or "a ColdFusion *datasource*". You did *not* set up an ODBC connection unless you chose "ODBC Socket when you configured the cf *datasource*. However, I did use ----- Excess quoted text cut - see Original Post for more -----

John, in fact YES I did create an ODBC just not in ColdFusion. So if we get technical I did the *ODBC* in the Windows Control Panel to validate the connection information. Now with that said, instead of me saying *ODBC* in the thread, The proper term would have been "using the ColdFusion Datasources To establish a datasource using JDBC". Since the datasource For MySQL(3.x) as listed in the drop down of selections was not Working. By sincerely, I do apologize for the misleading of information based on *proper terminology*. Again, I do appreciate the assistance That you provided. > My apologies John. I had tried both ways using the ODBC using the > Selection of MySQL(3.x) as well as Other (JDBC). Again, not to be a pain, but no you didn't set up an ODBC. You set up a MySQL(3.x) JDBC datasource. Then you set up an Other JDBC datasource using the mysql connector/j. Mixing ODBC and JDBC really makes following the thread confusing. Repeat it with me "I set up a *DSN*" or "a ColdFusion *datasource*". You did *not* set up an ODBC connection unless you chose "ODBC Socket when you configured the cf *datasource*. However, I did use ----- Excess quoted text cut - see Original Post for more -----