Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Unanswered: The insert/update of a text or image did not succeed (was "SQL Error")

    First I recieve this error when I upload a photo and click on the save button.
    'ODBC - update on a linked table 'PersonMisc' failed.'

    Then this error appears after I click ok.

    [Microsoft][ODBC SQL Server Driver][SQL Server] The READTEXT and WRITETEXT statements cannot be used with views[#285][Microsoft][ODBC SQL Server Driver] Warning: Partial insert/update The insert/update of a text or image did not succeed.[#0].

    Is there a size limit on the pictures I am uploading?

  2. #2
    Join Date
    Feb 2003
    @ home
    Do you have enough permitions for Insert/Update the view?


  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Your client side code is using READTEXT/WRITETEXT against a view. That isn't permitted (never has been, due to technical reasons). You have to do the WRITETEXT (to store the picture data) against the underlying table itself instead of the view that you are currently using.


Posting Permissions

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