Problem with ODBC - Data from Korea

[Anonymous]

Hi, 

i am getting this error trying to create a Schedule refresh procedure in the service:

when i am refreshing the same query from the Desktop or making a "Refresh Now" process there is no problem (the data is refreshed successfully) 

any thoughts? many thanks

This is the Error:

Failed to update data source credentials: ODBC: ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 862 to 933 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 862 to 933 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 862 to 933 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 862 to 933 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 862 to 933 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 933 to 862 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 933 to 862 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0107 - Converted 10 bytes, 2 errors found beginning at offset 4 (scp=933 tcp=934 siso=1 pad=3 sl=10 tl=10) ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWB0930 - Operating system returned error code 87 ERROR [22018] [IBM][System i Access ODBC Driver]Column 1: CWBNL0101 - Error occurred while attempting to convert data from code page 934 to 1202 ERROR [22018] [IBM][System i Access ODBC Driver]Error in assignment.

[Anonymous · Accepted solution]

Hi, it seems that i  have found the problem. it was in the ODBC definitions under the the conversion  Tab

i am not sure why it is a problem only in the service but if i change 

The "Overide client codepage setting with the following:" to  1208 the problem is solved

thanks