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. -----Original Message----- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 10:56 AM To: CF-Talk Subject: Re: MySQL/CFMX7 (RESOLVED) 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:231592 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
