Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Problem with ODBC - Data from Korea

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's avatar
    Anonymous
    8 years ago

    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 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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