EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB275914: "Specified driver could not be loaded" error appears when connecting to the Vertica Database from MicroStrategy Secure Enterprise Platform running on a Linux Operating System.


Community Admin

• Strategy


This technical note describes the error "Specified driver could not be loaded", which is generated when connecting to the Vertica Database via ./mstrtodbcx from MicroStrategy 10.x Secure Enterprise Platform.

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 system
User 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

 

 


Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

June 5, 2017