3rd try for a response

[Steve Grosz]

I noticed that I need to 1) install the JDBC driver on that machine,
then copy a .jar file to a /cf location as well?

When you say the JDBC driver performs better, what do you mean?

Thanks!
Steve

mpwoodward *TMM* wrote:

> Steve Grosz wrote:
>

>> Matt,
>>
>> No, I haven't tried that driver, just because I have been using the
>> MySql ODBC driver on my other server and it has been working fine for
>> months....
>>
>> I am using v 4.1.17 of the MySql server.

>
>
> Unfortunately I can't address the ODBC issue (since I haven't ever used
> MySQL that way), but if you don't have a specific reason to use ODBC I'd
> really suggest going with JDBC. It will perform far better.
>
> The trick with MySQL 4.1 is that you'll need to install the MySQL JDBC
> drivers because the ones that ship with CF don't work with MySQL 4.1.
> (Well, they do, but you have to rehash your passwords using a different
> method on the MySQL server.) If you're interested in giving that a shot
> there's a technote on macromedia.com about it here:
> [url]http://tinyurl.com/622pq[/url]
>
> Or if you have trouble post here again and I can walk you through it.
>
> Matt
>

[mpwoodward *TMM*]

Steve Grosz wrote:

> I noticed that I need to 1) install the JDBC driver on that machine,
> then copy a .jar file to a /cf location as well?

The "install" of this driver really involves just putting the JAR file
on your server, then adding the JAR file to CF's classpath so it can be
found. Where you put the JAR file is really up to you, but you do need
to add it to CF's classpath.

> When you say the JDBC driver performs better, what do you mean?

Performs better meaning improved speed and stability (in most cases).

Matt
--
Matt Woodward
Team Macromedia - ColdFusion

[Steve Grosz]

Well, its seems to be working, so thank you!! If it seems to work well,
maybe I'll move it to my production servers instead of using the ODBC
driver.

Steve

mpwoodward *TMM* wrote:

> Steve Grosz wrote:
>

>> I noticed that I need to 1) install the JDBC driver on that machine,
>> then copy a .jar file to a /cf location as well?

>
>
> The "install" of this driver really involves just putting the JAR file
> on your server, then adding the JAR file to CF's classpath so it can be
> found. Where you put the JAR file is really up to you, but you do need
> to add it to CF's classpath.
>

>> When you say the JDBC driver performs better, what do you mean?

>
>
> Performs better meaning improved speed and stability (in most cases).
>
> Matt

[mpwoodward *TMM*]

Steve Grosz wrote:

> Well, its seems to be working, so thank you!! If it seems to work well,
> maybe I'll move it to my production servers instead of using the ODBC
> driver.
>
> Steve

Fantastic Steve--glad to help. I definitely think you'll be happier
with the JDBC drivers.

Matt
--
Matt Woodward
Team Macromedia - ColdFusion