Solved

Unable to Update Long Text Fields Using ADO

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

821 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