We help IT Professionals succeed at work.

Unable to Update Long Text Fields Using ADO

weinerk
weinerk asked
on
Medium Priority
411 Views
Last Modified: 2010-05-18
using Microsoft Visual InterDev, version 1.0
using data form wizard created a asp form that accesses odbc DB (MS SQL)

runing into a problem with updating fields of type text
supposebly because ActiveX Data Objects (ADO) 1.0
      does not support updating long text fields with a forward-only cursor.

tried remedy suggested by microsoft (see below)
did not work any clues ?


according to microsoft:
  (http://premium.microsoft.com/support/kb/articles/q175/2/45.asp)

       PRB: Unable to Update Long Text Fields Using ADO

       Last reviewed: October 20, 1997
       Article ID: Q175245
       The information in this article applies to:

            Microsoft Visual InterDev, version 1.0
            Microsoft Active Server Pages, versions 1.0, 1.0b
            Microsoft Visual Studio 97

       SYMPTOMS

       When attempting to perform a table update, the following message appears:

          Query Based Insertion or Updating of BLOB values can not be supported.
          This may be caused by an attempt to update a non-primary table in a
          view


       CAUSE

       ActiveX Data Objects (ADO) 1.0 does not support updating long text fields with a forward-only cursor.

       RESOLUTION

       Use a cursor that supports bookmarks (for example, Keyset or Static).

       STATUS

       This behavior is by design.

       MORE INFORMATION

       If you have used Visual InterDev's DataForm Wizard to create the code that is experiencing this problem, follow these instructions:

         1.Edit xxxForm.asp.

         2.Search for the text: "DesignerControl" startspan.

         3.Right-click any of the text that is displayed in green, and select "Edit Design-time Control..."

         4.Click the Advanced tab.

         5.Change the "Cursor Type" to one that supports bookmarks (for example, 3- Static).

         6.Save the changes.

         7.Edit xxxList.asp and perform steps 2-6 again.




Comment
Watch Question

maybe you opened your cursor in forward mode, check in the source code the CursorType and the Lock Properties...

to insert/update a record these properties have to be at least set to:
adOpenStatic ---------  3
adLockOptimistic ----- 3

for more info append the code of your asp where the connection and the cursor are opened.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
I also updated to MDAC 1.5

so i am not sure what did it

also was wondering where can i get more info of cusors and locks?
thanks

I evaluated the idea to update to MSDAC but i preferred to continue using ADO for his semplicity...
for more info about cursors and locks in ADO look at the on-line documentation in Visual Interdev..
it's very simple and explicative...
let me know how your work go
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.