I noticed at the bottom of that page there are some user comments about recompiling and ODBC not working. Any concerns regarding those comments and the issues I'm having?

Steve

Michael Stassen wrote:
No, I'm saying that your client (ODBC from Coldfusion) was built against an earlier version of the mysql client library, so it doesn't understand the new, more secure, authentication protocol introduced in mysql 4.1.

Did you read the manual section I suggested? It contains an explanation of your exact error message, along with a link to another page <http://dev.mysql.com/doc/mysql/en/Old_client.html> which offers work-arounds.

Michael

Steve Grosz wrote:

So, you're saying its a problem with the password on the root account? This was a brand new install.

I'm a little confused here.

Steve

Michael Stassen wrote:

See the manual <http://dev.mysql.com/doc/mysql/en/Password_hashing.html>.

Michael

Steve Grosz wrote:

I am trying to set up a ODBC connection from a Coldfusion server to a MySql server, both running on Windows2003 Servers. I installed the ODBC 3.51 driver on the Coldfusion server, and am trying to make the connection.

When I go to set up the ODBC link and say 'test data source' I get a message that says [MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySql client'.

What is this refering to???????

Thanks,
Steve



-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to