I'm using a SQL 2000 Linked Server to access DB2 using a Microsoft OLE DB Provider for ODBC. The DB2 client is 7.2.
I can select data from the data source going to a Host DB2 table; however, I'm not able to insert data:
I get the following error message:
Server: Msg 7399, Level 16, State 1, Line 37
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][CLI Driver] CLI0133E Option type out of range. SQLSTATE=S1092]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x80004005: ].