StarQuest: keeping data in motion

 

StarQuest Technical Documents

Cognos Imprompt returns error when connecting to an iSeries: [Microsoft][ODBC Driver Manager] Invalid argument value


Last Update: 26 June 2008
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ001

Problem

The following error may occur when Cognos Imprompu attempts to connect to an AS/400 using StarSQL.

[Microsoft][ODBC Driver Manager] Invalid argument value

Cognos Impromptu sets the transaction isolation level to the database default isolation level at each transaction. When the database is queried for its default isolation level, StarSQL returns 0 for NONE. This value is not properly interpreted by Impromptu as a valid isolation level and, therefore, the subsequent ODBC API call to set the isolation level fails.

Solution

  1. Change the Isolation Level in your StarSQL data source configuration to Read Uncommitted (or Read Committed). Click Summary and then OK to save the changes.
  2. Change the StarSQL section of the cogdmod.ini file to this:

[DRIVER:SWODBC32.DLL]
SQL_DEFAULT_TXN_ISOLATION="1"
SQL_API_SQLEXTENDEDFETCH="FALSE"
SQL_NON_NULLABLE_COLUMNS="FALSE"
SQL_NULL_COLLATION="FALSE"

  1. Set the SQL_DEFAULT_TXN_ISOLATION="1" for READ UNCOMMITTED and SQL_DEFAULT_TXN_ISOLATION="2" for READ COMMITTED. The setting should match the isolation level selected in the StarSQL data source.
  2. Restart the application and re-try the connection through Impromptu.

Additional Information

Please also see Cognos Technical Document ID: KB69609CS.

DISCLAIMER

The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.