The specified driver of Mysql odbc 5.1 driver cannot be loaded.

Problem:

After installing the new 5.1 mysql odbc Driver, the program prompts "(MySQL ODBC 5.1 Driver). The specified Driver cannot be loaded ."

Solution:

The security settings of windows2003 are very important. Therefore, many people set the directory permissions only for the Administrator and SYSTEM, but such settings may cause problems in running My SQL.

The solution is divided into two steps.

1. In Directory Security Settings of C: \ Program Files \ MySQL \ Connector ODBC 5.1, the Users account must have full control permissions.

2. The C: \ Program Files \ MySQL Server 5.0 Users account must have full control permissions.

After adding permissions, refresh the page to take effect.