Solved

Unable to Update Long Text Fields Using ADO

Posted on 1997-11-21
3
360 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.




0
Comment
Question by:weinerk
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
Wiz_of_Oz earned 20 total points
ID: 1089279
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.
0
 
LVL 1

Author Comment

by:weinerk
ID: 1089280
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

0
 
LVL 2

Expert Comment

by:Wiz_of_Oz
ID: 1089281
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
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question