Solved

Unable to Update Long Text Fields Using ADO

Posted on 1997-11-21
3
365 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 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