linked db run update/insert/delete error

Build a OLE DB ODBC connection to a DB2 database, linked db name is HOC25PR
Run select from OPENQUERY no problem

select * from OPENQUERY (HOC25PRD, ' select * from db2ins01.recon_extract '

But for Delete/Insert/Update OPENQUERY statment
update OPENQUERY (HOC25PRD, ' select * from db2ins01.recon_extract where col2=''2''') set col1='TESTUPD'

Got error message
---------------------------------------------------------------------------------------
Server: Msg 7399, Level 16, State 1, Line
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData returned 0x80004005: ]

Any clue or suggestion

Thanks

HG

check this article for an example
http://dbforums.com/arch/30/2003/6/789523

Maybe you need a different driver. the error message is "driver not
capable". Have you tried the IBM DB2 OLEDB (IBMDADB2) driver or the MS DB2
OLEDB driver (DB2OLEDB, from Microsoft's HIS2000 product)? When I tried
this with the DB2 OLEDB it worked for me.

-Dino

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

2 13th July 18:11 dino chiesa [microsoft] External User Posts: 1	linked db run update/insert/delete error check this article for an example http://dbforums.com/arch/30/2003/6/789523 Maybe you need a different driver. the error message is "driver not capable". Have you tried the IBM DB2 OLEDB (IBMDADB2) driver or the MS DB2 OLEDB driver (DB2OLEDB, from Microsoft's HIS2000 product)? When I tried this with the DB2 OLEDB it worked for me. -Dino