Consultor Eletrônico



Kbase P154453: Error 6177 when pulling a table from DB2/400 using IBM Client Access ODBC driver
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/10/2009
Status: Unverified

SYMPTOM(s):

Error 6177 when pulling a table from DB2/400 using IBM Client Access ODBC driver

SYSTEM ERROR: Assignment error. (6177)

FACT(s) (Environment):

The table contains some control characters for ASCII carriage return/line feed
Windows
OpenEdge 10.2B
ODBC DataServer

CAUSE:

The IBM Driver configuration is not set to "Allow nsupported character". Not checking the option on the IBM driver do not convert the ASCII line feed character (0x0A) to the EBCDIC line feed character (0x25).

FIX:

Check the option for "Allow unsupported character" under the Driver's configuration > Translation tab > Advance (Advance translation Options)