RE: another mySql question...

2006-09-08 Thread Ken Ferguson
-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 Connector/J I think, you

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 come

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

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

another mySql question...

2006-09-07 Thread Doug Brown
Anybody run across this before? The connection fails. I can verify the datasource in windows but cannot verify in CF. Also I do not see the myODBC after installing the connector, is that by design? Update CF Data Source Info The ODBC data source XXX cannot be edited remotely. The

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, 2006

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

Re: another mySql question...

2006-09-07 Thread Josh Nathanson
/knowledgebase/index.cfm?id=tn_19170 -- Josh - Original Message - From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 3:35 PM Subject: RE: another mySql question... I've always used MySQL's JDBC driver, not ODBC. If you search

Re: another mySql question...

2006-09-07 Thread Doug Brown
://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170 -- Josh - Original Message - From: Munson, Jacob [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 07, 2006 3:35 PM Subject: RE: another mySql question... I've always used MySQL's JDBC driver

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 driver

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=