WARNING - You should always make a backup of the Registry before making any changes.
To resolve this error, set WorkArounds2=8192 for the affected data source. This can be done by using the Registry Editor (RegEdit).
1. Run RegEdit
2. Locate the ODBC DSN in the Registry:
For a USER Data Source, go to HKEY_CURRENT_USER -> Software -> ODBC -> ODBC.INI -> YourDataSourceName
For a SYSTEM Data Source, go to HKEY_LOCAL_MACHINE -> Software -> ODBC -> ODBC.INI -> YourDataSourceName
For 32-bit applications (ODBC drivers) on 64-bit Windows, (MACHINE) Data Source, go to
HKEY_LOCAL_MACHINE -> Software -> Wow6432Node -> ODBC -> ODBC.INI -> YourDataSourceName
3. Click on the folder for your data source; from the menu choose:
Edit -> New -> String Value
4. Set the name of the new string value to be WorkArounds2
5. Double click on WorkArounds2 in the right hand panel; this will bring up a dialog box with a data value field
6. Change the data value to 8192 (The string value that must be added to Windows XP SP2 and Progress 10.1A02 is WorkArounds2=40960)
7. Click OK
8. Close RegEdit
PCs running Windows 95 and 98 need to be rebooted for this setting to take effect
9. NOTE: When using a FILE DSN, simply open the (text) FILE DSN with your favorite text editor, add the following string to its contents (without quotes and using the appropriate (integer) value for <nnnnn>: "WorkArounds2=<nnnnn>". Save the file.