SYMPTOM:
"Specified driver could not be loaded" error message appears when trying to connect an Intelligence Server running on Linux to MySQL Community using the MySQL 5.1.8 ODBC driver in Strategy 9.3.1. The same issue is seen when trying to connect to the database using the mstrtodbcx tool. Additionally, after running the commands below, all paths are found and the odbc.ini file has the expected information.
ldd libmyodbc3.so
ldd libodbcinst.so.1
The issue might not be reproducible in a different environment.
CAUSE:
This is a known issue in Strategy 9.3.1.
ACTION:
Contact Strategy Technical Support for an update on this issue.
WORKAROUND:
Install and use the MySQL ODBC 5.2.5 driver instead to connect to the MySQL Community database.
