RE: another mySql question...

2006-09-08 Thread Ken Ferguson
Correct, sorry, built-in JDBC is what I meant, the 3.x built-int JDBC driver. Thanks for the correction. Thanks, Ken Ferguson 214.636.6126 -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006 9:50 AM To: CF-Talk Subject: Re: another mySql

Re: another mySql question...

2006-09-08 Thread Dan Plesse
I think Ken means JDBC and I think its just namespace conflict problem with jLog for which a good classloader will resolve and you can not use a pageContext based classloader for this. ODBC is a Microsoft technology for windows only. myODBC is something else altogether. A classloader can put the my

Re: another mySql question...

2006-09-08 Thread Rick Root
Ken Ferguson wrote: > That is a false statement. I'm currently using the ODBC drivers with > MySQL 4.1 and MySQL 5 and CF works fine with both. The only thing is > that you can't use the MySQL ODBC driver that CF has built in to the > admin, as it is only for < 4.x versions. (coldfusion doesn't co

RE: another mySql question...

2006-09-08 Thread Ken Ferguson
214.636.6126 -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 5:55 PM To: CF-Talk Subject: Re: another mySql question... AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the ODBC driver at all. It's called Connec

Re: another mySql question...

2006-09-07 Thread Dan Plesse
You cannot use the built in MySQL JDBC driver with MySQL 4/5 in Coldfusion - only 3.23 for 7 I thought they fixed that? Install mysql-connector-java-5.0.0-beta-bin.jar then "jdbc:mysql://localhost:3306/?logger= com.mysql.jdbc.log.StandardLogger&useUnicode=true&characterEncoding=UTF8&user=xxx

Re: another mySql question...

2006-09-07 Thread Rick Root
Josh Nathanson wrote: > AFAIK you *have* to use the JDBC driver with MySQL 4+/CF, you cannot use the > ODBC driver at all. It's called Connector/J I think, you have to download > it from the MySQL website -- here's the link: I think you're confused. You cannot use the built in MySQL JDBC drive

Re: another mySql question...

2006-09-07 Thread Doug Brown
Ok I think I got it to finally work. I am using the mySql myODBC 3.51. I did not know about the connection string. - Original Message - From: "Josh Nathanson" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, September 07, 2006 4:54 PM Subject:

Re: another mySql question...

2006-09-07 Thread Josh Nathanson
om/cfusion/knowledgebase/index.cfm?id=tn_19170 -- Josh - Original Message - From: "Munson, Jacob" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Thursday, September 07, 2006 3:35 PM Subject: RE: another mySql question... > I've always used MySQL's JDBC dr

Re: another mySql question...

2006-09-07 Thread Bryan Stevenson
Yes I've seen a similar error before. Mine was NaviCat could connect to the DB just fine, but CF would always say the DB could not be found or was not running. MOst people have easy success with the connector, but some of us just ran into brick walls. This is why I use MS SQL Server and Oracle

RE: another mySql question...

2006-09-07 Thread Munson, Jacob
I've always used MySQL's JDBC driver, not ODBC. If you search Ben Forta's blog, there's an entry about MySQL 5 in CF, and this has good directions for getting it to work in the comments. > -Original Message- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 200