'Error connecting to DSN: XXXXX
Connect Failed. Error type: Odbc error. Odbc operation attempted:
SQLDriverConnect. Driver's SQLAllocHandle on SQL_HANDLE_ENV failed.'
CAUSE:One of the causes for this issue is that the Strategy Intelligence Server is a Universal installation that resides on a UNIX operating system and there is a missing entry for an ODBC driver instance in the Strategy odbc.sh file. This ODBC driver instance is in turn used by a data source name (DSN) to connect to the metadata. Since this entry is missing along with its respective configuration, Strategy Developer and Strategy ODBC Test Tool cannot connect to the metadata when using a data source name (DSN) that uses this ODBC driver.
Note: The Strategy odbc.sh file is located at <HOME_PATH>/env, where <HOME_PATH> is the directory specified as the Home Directory during the installation of Strategy Intelligence Server Universal.
ACTION:The user needs to manually add the entry for the ODBC driver instance and its respective configuration relative to the database type that the user wants to connect to in the Strategy odbc.sh file. After the entry has been added the Strategy Intelligence Server needs to be restarted. Once these steps have been performed, the user will now be able to connect to the metadata via Strategy Developer or Strategy ODBC Test Tool.
