Re: ODBC and MySQL 4.1

[Dan Brown]

I got this fixed by making sure that the password was stored in the old format, as Rob pointed out. I followed the example on the page that Rob pointed to (http://dev.mysql.com/doc/mysql/en/Old_client.html)
ie
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

and then I also had to tell the mysql server to use the old password authentication scheme by invoking it with the following options:
mysqld-nt --console --old-passwords=TRUE

hope that helps
Dan