Inserting string into Blob field using VB

[ycp]

I need help on inserting text string into Informix blob field using VB recordset. When I use the following code I get memory exception error on appendchunk. Any ideas?
thanks.
-YC-
-------------------------------------
Set rstEmail = New ADODB.Recordset
With rstEmail
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "email", cnn1, , , adCmdTable
.AddNew
'TmpSheet is string, l_msg is informix blob field.
!l_msg.AppendChunk TmpSheet
.Update
.Close
End With
cnn1.Close

 

[ycp]

Hey, is any body using Informix anymore? Adding to my previous post. The snipets of code were actually done by contractor that no longer available. The program use to work but after upgrading Informix 7.2 to 7.3, it bombs. Here is the err. msg:

err.source:
Microsoft OLE DB Provider for ODBC Drivers
err.number
-2147467259
err.Description:
[INTERSOLV][ODBC Informix driver] Out of memory.

field l_msg is type text (blob).

 

[dsuess]

Hello -

Your 2nd post indicates an Informix upgrade from v7.2 to v7.3, and that you're using an Intersolv drive. I would contact Intersolv first and see if you're using the correct Intersolv version. While moving from 7.2 to 7.3 doesn't seem like much, you said it worked fine initially (v7.2) but doesn't work now in v7.3.

- David