Well, then it's actually a user error who didn't read the docs well enough!!!! /s/'whil')- SQL command on connect: left empty
Note that I can connect to and manipulate the test database interactively (I added a table, inserted records, etc., all as user
7. Hit "Test Data Source"
8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client.
9. I have no idea what this means. I don't even understand some of the words, much less the whole durn tootin' sentence.
I tried the same thing with a System DSN (and it filled in 'localhost' for the Host/Server instead of 127.0.0.1), and got the same error.
Ideas? Is this a user error or a driver error? Is this MySQL5 specific?
Thanks,
Whil
This is neither a user error nor a driver error. What has happened is that the ODBC drivers prior to 3.51.10 do not understand the new user authentication that entered MySQL as of v4.1 . There are several ways to work around this. They are well documented here:
http://dev.mysql.com/doc/mysql/en/old-client.html
Thanks, Shawn. I've got (most) of it working now! (Inside my app I'm still having trouble, but that's not appropriate for this list!)
Whil
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]