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]
