Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    9

    Unanswered: linked server to UDB

    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?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    What happens when you try
    Code:
    insert into TESTUDB3.TEST.T1
    VALUES ( '1','1','1','1','1')

  3. #3
    Join Date
    Sep 2005
    Posts
    9
    Same error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •