Re: [CF-Database] CF5, mySQL 4.x and ODBC/JDBC

["Stephen Moretti (cfmaster)" <stephen@cfmaster.co.uk>]

Mark Woods wrote:

> > - see footer for list info
>
>
> > I'd like to be able to use mySQL 4.x, but I'm stuck with CF5.
> > The myODBC 3.51 drivers don't support mySQL4.x (myODBC3.6 is in
> > development still).
>
>
> I've used MySQL 4.1.4-gamma with MyODBC 3.51 and CF5 on Windows 
> without any problems - you sure you haven't got something wrong with 
> the configuration?


Got it all sorted now. I thought I'd posted something about this already.

I hadn't come across this article - 
http://dev.mysql.com/doc/mysql/en/Old_client.html - which tells you that 
you need to set the server to use old password formats and that you need 
to reset the existing passwords to use the old password format.
Once you do that, everything is hunkydory.  I guess if you upgrade an 
existing database then you don't get this problem, until you convert the 
passwords to the new format.

I then got an "Illegal mix of collations" error for one of the tables - 
in the end I recreated the table and imported the data and all was well 
there too.

Regards

Stephen