For DB2 only, you need to verify that a special string key is defined in the Windows Registry to allow the driver to pad DB2 char for bit data fields with spaces, instead of binary zeros.
WARNING! Be cautious when using regedit.exe or regedt32.exe, you can disable your machine. Make a backup of your registry before making any changes.
To add the WorkArounds2
String Key
Using the Windows Registry editor (regedit.exe or regedt32.exe), open one of the following sections in the Registry:
For User DSN: HKEY_CURRENT_USER \SOFTWARE\ODBC\ODBC.INI
For System DSN: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
In this section, locate an entry for the DSN you created.
If the WorkArounds2 string key is not there, select Edit | New | String Value from the Edit menu, to add a String Value named WorkArounds2 (case sensitive). After it has been created, modify the new entity and give it a value of 131072.
Click OK.
Repeat this process for each DB2 UDB DSN that you are going to use with ECDA.
