Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Could not execute action...Please check the ODBCINI environment variable" when testing the ODBC (connection type) connectivity in the Administration Console in Informatica 9.1.0
Problem Description

In Informatica 9.1.0, when testing the ODBC (connection type) connectivity in the Administration Console or Connections, the following error occurs:

Could not execute action...

The requested operation could not be performed due to the following error :  [REL_10611] Error returned during ODBC access.  ErrorCode=[-1]. Reason=[[DataDirect][ODBC lib] System information file not found.  Please check the ODBCINI environment variable.].

We are unable to test ODBC connectivity from within the Administration Console Connection Test. We can test other relational types excluding ODBC.

Cause
Solution

In the $INFA_HOME/tomcat/bin/, run the following ODBC Test tool:

TestODBCConnection.sh

This is a shell script command to Test ODBC Connections only.
The usage of this command is as follows:

TestODBCConnection.sh <connection name> <username> <password> <connection string> <INFA_HOME>

TestODBCConnections.bat is available for Informatica Servers installed on Windows Server 2003/2008/2008R2.

More Information
Applies To
Product: Data Quality
Problem Type:
User Type:
Project Phase:
Product Version: Informatica 9.1.0; Informatica 9.1.0 HotFix
Database:
Operating System:
Other Software:

Reference

For more information, see IDQ 9.1.0 Administrator's Guide.

Attachments
Last Modified Date:1/11/2012 12:05 AMID:124957
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)