I am using VFP 9 connecting to MySQL with the MySQL ODBC driver v3.51 and am having the following issue.
If a password to a database contains non-alphanumeric characters, for example a ';' or '[' the connection will fail. If I change the password to the db to just characters and numbers the connection succeeds.
Other programs that connect to the database can use the original password containing the special characters, so I know the issue lies within the VFP/ODBC connection.
I was just wondering if anyone else has experienced this and if there is a known workaround.