Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gam
Starting Member
9 Posts |
 Posted - 2007-03-15 : 15:36:41
|
| I'm trying to set up a linked server from sql server 2000 to udb 8.1.14. My selects to the UDB table work fine. Inserts/updates deletes fail. The insert returns - OLE DB error trace [OLE/DB Provider 'IBMDADB2' IRowsetChange::InsertRow returned 0x80040e53: The provider does not support the necessary method.]. Here's the insert format - INSERT OPENQUERY(TESTUDB3, 'SELECT * FROM TEST.T1') VALUES( '1','1','1','1','1'). Is this the correct format? Does the IBM provider allows updates? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-15 : 15:39:01
|
| This is not a SQL Server problem, but rather a problem with the provider. I would check your provider's documentation or contact the vendor of the provider for support on this.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
linked server to UDB