DataSource.Error: Microsoft Db2 Client: HISMPCB0002 In BasePrimitiveConverter

[eferniza]

Getting the following error when trying to retrieve a table from a AS400/Mapics server.

DataSource.Error: Microsoft Db2 Client: HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 65535. SQLSTATE=HY000 SQLCODE=-343

Anybody knows the source of the error, or workaround to pull this information directly from the server.

[lbendlin]

The code page is missing - set to -1 which is equivalent to 65535.

Specify 65001 for utf-8,  or maybe 1252 for such an old machine

Code Page Identifiers - Win32 apps | Microsoft Learn