Extended Dynamic Support Error Client Access ODBC

Resolving The Problem

1. In the ODBC.INI file set the following:
ExtendedDynamic=0
ForceTranslation=1

2. Make sure Client Access for Windows is being used and not Client Access for DOS Extended.

3. The cause of the error is the following:

The problem is that the database is expecting journalling, which isn't needed because Impromptu is a read-only product. Since it will only do "selects", there is no need to journal the transactions, since it cannot rollback a select statement.

The other side issue of this is that IBM is mixing isolation levels and transaction levels, which are not the same thing.

IBM's ODBC driver has a transaction level of 0 - Commit Immediate, which is not a standard level. Our lowest level is Read Committed, which is not accepted nor low enough for the database.

The solution for now is to turn on journalling on the AS/400. The IBM have indicated that this will have very little impact on performance since it is only doing select statements. The down side of journalling is that it does take up disk space on the AS/400.

The apar number from IBM is: SA46876

NOTE: IBM currently has patches available for this problem. Contact IBM to receive the fix for this problem.

4. In the ODBC.INI try the following settings:

Commit_mode =1
Package= [suffix must be nba]

if commit_mode=0
then package suffix must be fba
else if commit_mode = 1
then package suffix must be nba
else if commit_mode = 2
then package suffix must be vba

5. In the ODBC.ini try to add in the section [DRIVER:CWBODBC.DLL] the following:

Disable Transaction Support="T"