Problem with (hashed) passwords

[Delphard]

I my program I have my own login form from which I forward username and password to (ADO)ConnectionString, and then make Connection Active.
But, MySQL Server reports error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
Newest version of server (and client) is installed.
Help says that server uses hashed password when user is attemp to connect.
How can I provide hashed password from my application?

 

[kittyyo]

Maybe the option "Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program." could help, read at

http://dev.mysql.com/doc/mysql/en/old-client.html

Anyway, the newest client library used by your program (don't know which one is used by ADO) should support the new MySQL authentication mechanism.

 

[Delphard]

Reset password to pre-4.1 clients actually helps and now it's possible to make connection. But...
Still need explanation why ordinary (post-4.1) passwords don't works!?
(maybe ODBC 3.51 driver doesn't support new hashing?)
((this version of ODBC is pretty old, but latest one!?!?))