32 Bit ColdFusion with 64 bit MySQL

gildorr wrote:
> I'm about to install a 32 bit version of ColdFusion 8 onto a server running 64
> bit RedHat Enterprise Linux . Our web developer believes this will only
> function with MySQL if a 32 bit MySQL server is installed. I can't find
> information to support either side, and am not familiar with how ColdFusion
> links into the MySQL database.
>
> On a server that supports 64 bit applications , is there a requirement that a
> 32 bit version of MySQL be installed to function with a 32 bit version of
> ColdFusion, or will ColdFusion function just the same with a 64 bit
> installation of MySQL?
>

First question, why not the 64 bit version of ColdFusion 8?

Secondly, I presume this is a matter of a database driver, 32 bit I
presume, that works both with ColdFusion and MySQL. I feel this is
doable, but I do not know what gotcha's their may be.

I do not see what ColdFusion should care how many bits the database is
using, since it does not even care if the database is on the same
server. In fact putting the database on a separate machine is generally
considered a best practice.