March 17, 2015 at 10:35 am
I am having a problem moving data from an OLE DB source (Sql Server 2012) to a ODBC Destination (IBM Iseries as400) I get the following error messages:
[ODBC Destination [11]] Error: Open Database Connectivity (ODBC) error occurred. state: '22018'. Native Error Code: 30200. [IBM][System i Access ODBC Driver]Column 5: CWBNL0107 - Converted 10 bytes, 5 errors found beginning at offset 0 (scp=1202 tcp=37 siso=1 pad=4 sl=10 tl=10)
[ODBC Destination [11]] Error: Open Database Connectivity (ODBC) error occurred. state: '22018'. Native Error Code: 30019. [IBM][System i Access ODBC Driver]Error in assignment.
Any Ideas as to what might be the issue. I have narrowed it down to a data typing problem. or an unsupported character.
Any help would be greatly appreciated.
March 17, 2015 at 12:21 pm
It looks like I found the problem. When I changed the datetime columns on the SQL side and converted them to Date because that is the data type on the IBM side....and it worked! column 5 in the error message was not the problem it was the column immediately after which was a date column.
March 17, 2015 at 3:36 pm
paulze2000 (3/17/2015)
It looks like I found the problem. When I changed the datetime columns on the SQL side and converted them to Date because that is the data type on the IBM side....and it worked! column 5 in the error message was not the problem it was the column immediately after which was a date column.
Quick question, what's the AS/400 O/S and Driver version, seen similar problems before?
😎
March 18, 2015 at 6:38 am
its IBM I 7.1.This is the first time I ran into the problem because it is the first time I needed to move data from sq lserver to there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply