Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    South Africa
    Posts
    3

    Question Unanswered: Update Problen on ASA 8 when used as a Linked Server in MS SQL 2000

    I have Adaptive Server Anywhere 8 as a Linked Server in MS Sql 2000.
    "Select" and "Insert" statement would execute all right,
    but "Update" statements would return an error.
    For Instance:
    ...
    Select * From OpenQuery(ASA_LinkedServer, 'Select * From Test_Table')
    Insert Into OpenQuery(ASA_LinkedServer, 'Select * From Test_Table') Values (111, 'Test Insert')
    ...

    would execute without problems.

    ...
    Update OpenQuery(ASA_LinkedServer, 'Select * From Test_Table') Set Col2 = 'Test_Update'
    ...

    however will return the following error

    ...
    Server: Msg 7320, Level 16, State 2, Line 1
    Could not execute query against OLE DB provider 'MSDASQL'.
    The provider could not support a row lookup position.
    The provider indicates that conflicts occurred with other properties or requirements.
    OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandText::Execute returned 0x80040e21:
    Select * From Test_Table[PROPID=DBPROP_BOOKMARKS VALUE=True STATUS=DBPROPSTATUS_CONFLICTING], [PROPID=DBPROP_IRowsetLocate VALUE=True STATUS=DBPROPSTATUS_CONFLICTING]].
    ...

    The Table is very simple(int and varchar),
    The Linked Server is regestered in MS SQL through the OLE DB for ODBC and a ODBC Datasource to the ASA 8.

    Does any body have an idea how to make this "Update statement work?

    Regards
    Ilia

  2. #2
    Join Date
    Nov 2003
    Posts
    9

    Re: Update Problen on ASA 8 when used as a Linked Server in MS SQL 2000

    I am having the same problem. The only difference is that I have SQL Server 2000 at both ends and the problem is not only in the 'Update' statement but also in the 'Delete' statement.

Posting Permissions

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