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

    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
    Location
    @ home
    Posts
    163
    Do you have enough permitions for Insert/Update the view?

    Paulo

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

    -PatP

Posting Permissions

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