SYMPTOM:
Users get "Specified driver could not be loaded" error when connecting to the Vertica Database via ./mstrtodbcx from Strategy 10.X Secure Enterprise Platform running on a Linux Operating System.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM003:0: on HDBC][DataDirect][ODBC lib] Specified driver could not be loaded.
User has already followed by all the configuration steps for how to connect to a Vertica database in Strategy 10 Secure Enterprise Platform running on a Linux operation as outlined in KB221507.
KB221507: How to connect to a Vertica database in MicroStrategy 10 Secure Enterprise Platform running on a Linux operating systemUser has confirmed that both Database version and ODBC Driver version have been certified, and odbc.sh, odbc.ini, vertica.ini files have been properly configured. But above error still occurs.
Note: Starting with Strategy 10 Secure Enterprise Platform, in order to better align to Vertica's documentation, Vertica's [Driver] section will be removed from the odbcinst.ini. The creation of a new vertica.ini file will be required and a VERTICAINI variable will be added to the odbc.sh file to reference that vertica.ini file.
CAUSE: The environment variable VERTICAINI is not able to reference the vertica.ini file, then the ODBC manager is not able to locate the Vertica driver, above error will occur.
ACTION:Manually set the environment variable VERTICAINI and try again.
Run the export command is as below:
export VERTICAINI="path_to_vertica.ini file"/vertica.ini