Client does not support authentication protocol

[john holder]

I received the following error attempting to open MySql db from VB.
(using 5.1.44 server from 4.0.21 client)

[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client

I then used following suggestion on the server pc to fix the problem.

SET password for 'user'@'localhost'=OLD_PASSWORD('newpassword');
FLUSH PRIVILEGES;

The VB program will not recognize the new password but still works with the
old password except the ODBC error still exists !

Do i need to do anything on the client side? I have many users still on the
old version (4.0) And why does the client VB still work with the old pswd?

thanks