On 2/7/06, ColdFusion <[EMAIL PROTECTED]> wrote: > 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 > 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. > > > -----Original Message----- > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] > Sent: Monday, February 06, 2006 11:25 PM > To: CF-Talk > Subject: Re: MySQL/CFMX7 (RESOLVED) > > 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) [EMAIL PROTECTED] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231590 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
