List:General Discussion« Previous MessageNext Message »
From:Arthur Maloney Date:May 19 2004 5:28pm
Subject:Password error
View as plain text  
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:ArthurM@stripped

Thread
Password errorArthur Maloney19 May
RE: Password errorVictor Pendleton19 May