Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unhappy Unanswered: Linked Server Update Problem

    I am getting an error trying to update a table in DB2 via SQL Server using a Linked Server. I can query the table using OPENQUERY but not via four-part name.

    I can do this...

    SELECT

    Select * from OpenQuery(db2link, 'Select frst_nm from yccfssc9.person where id_prsn = 2')

    When I try to Query using four-part names I get the following error...

    7399 OLE DB Provider 'MSDASQL' reported an error. The provider does not support the necessary method.

    UPDATE

    When I try to update using this...

    Update OpenQuery(db2link, 'Select frst_nm from yccfssc9.person where id_prsn=2') Set frst_nm = 'Fred'

    I get the following error...

    The OLE DB provider 'MSDASQL' indicates that the object has no columns.

    When I try to update using four part names I get the error that says that the provider does not support the necessary method.

    OTHER INFO

    I was originially using version 6.1 of the db2 client (db2odbc.dll) but tried the 7.1 client and got the same error.

    I believe we are using version 6.1 of db2 connect.

    The mainframe db2 is version 7.0 release 1.0

    Any help would be greatly appreciated. I referenced Microsoft Knowledge Base Article #270119 to get the workarounds that I attempted...

    Gary

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    KBA to resolve the update error issue.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    thanks but....

    Satya, thanks for the reply but in my post I referenced this KBA. Neither of the workarounds mentioned by microsoft worked.

    Originally posted by Satya
    KBA to resolve the update error issue.

Posting Permissions

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