Authentication not compatible with MySQL

[smarques]

The current Windows Authentication is not compatible with MySQL.

The problem is the <domain>\<username> query uses only one backslash. MySQL needs double-backslash.

http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html

I traced the ODBC connection. The problematic select statement was:

Select UserID from 't_secuser' where UserLogin='MyDomain\user2'

According to MySQL the backslash character should be inserted in queries as '\\'. The above query will not work as intended.

This prevents the use of Windows Authentication with MySQL.

[alesliehughes]

Thanks for you detailed report.

The bug has been fixed and will in the next build of EA (787)

Alistair