IB 5.6 update text in blob

Posted on 2003-03-20
Medium Priority
Last Modified: 2013-12-09
Hello I have a problem with update text in ib 5.6
read is no problem.

first I tried this:
Set RS=myadoDBconn.Execute("UPDATE PMMEMO SET TEKST='jaap'")

I get the error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[INTERSOLV][ODBC InterBase driver][InterBase]conversion error from string "BLOB"

then I tried this

cmd.SQLType = text
cmd.sql = "UPDATE into table(PMMEMO, TEKST) values (?,?)"
cmd.parameters(0).value = 1
cmd.parameters(1).value = 'This is new blob text' (177)

I get the error

Error Type:
Compilatiefout Microsoft VBScript (0x800A03EA)
/call.asp, line 177, column 26

Please help cornee

Question by:Cornee
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
  • 3
  • 2

Expert Comment

ID: 8173531
The right way is with parameters. Read about right use of them in ado reference

Author Comment

ID: 8173867

I need more info please ( I am a newbee)

I cant seem to find the info I need about parameters.
where can I find this ADO reference.. MS i guess..
I only find .net stuff

Is it possible at all to insert text in a blob field with ASP?

Do I Need Stored Procedures ?
Do I need UDF or FreeUDFLib or something?

totally lost here....


Accepted Solution

BAlexandrov earned 225 total points
ID: 8175965
The right way for working with blobs is parametrized query.
It is easy acheivebale with ADO.
See reference for ADO Command Object - it is for working with params, I don't remember now more.
Also chech what OleDB provider you use.
Consider this one

At this site are also lots of samples with ADO.

Bojidar Alexandrov

Author Comment

ID: 8202536
I tried a lot of examples with parametrized but no succes
When i tried the code of www.ibprovider.com i get this error:

the error
ADODB.Parameters (0x800A0E7C)
Parameter object is improperly defined. Inconsistent or incomplete
information was provided.

This is my code:

set cmd=createobject("adodb.command")
cmd.ActiveConnection= myADODBconn
cmd.CommandText = "insert into PMOPDRACHT (CONTACTNAAM) values(?)"

cmd.Parameters.Append cmd.CreateParameter("CONTACTNAAM",VarChar, , , "AAA")


This is not a blob field but a varchar, when varchar is working then i go try to insert a blob field.

What is going wrong here??????
Please help me


Author Comment

ID: 8252350
It is working with parametrized query and get chunk but thanks!!!!!

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

743 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