You can try using the old-passwords option in the my.cnf file or you can try
building your ODBC driver from the bitkeeper source. I would check the
documentation to verify that the ODBC build you have supports the 4.1.+
servers.
-----Original Message-----
From: Arthur Maloney
To: [EMAIL PROTECTED]
Sent: 5/19/04 12:28 PM
Subject: Password error
Hello MySQL Listers,
Using myODBC 3.51.07, Win2k SP4, ADO 2.7 & mySQL5
If I make the connection when user account does not have a password it
works.
If I set a password I get the error below ???
Which MySQL client is it referring to??
Any suggestions regarding connection string ??
err No -2147467259
[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol
requested by server; consider upgrading MySQL client
cnn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=" & strServerName & ";" _
& "DATABASE=" & strDBName & ";" _
& "UID=" & strLogin & ";" _
& "PWD=" & strPassword & ";" _
& " OPTION=3"
also tried '& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 163841
--
Best regards,
Arthur mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
