Using BLOBs (Byte) in VB6 via OLE DB to IDS 7.30

Using BLOBs (Byte) in VB6 via OLE DB to IDS 7.30

Post by Richard Spit » Sun, 31 Dec 1899 09:00:00



Hi Informixers,

without any previous experience with BLOBs, I'm having trouble starting
a project that uses "byte" type BLOBs with IDS 7.30 as backend,
VB6 as frontend and Informix's OLE DB provider as middleware.

I have a rather simple employee information system using the above
tools that my boss now wants enhanced with pictures. The VB6 and
OLE DB documentation doesn't give me any hints about BLOBs. Does
anybody have experience with this subject and maybe some example
source code to point me in the right direction?

Regards, Richard
--
+--------------------------+------------------------------------------+

| EDV-Gruppe Anaesthesie   | Tel     : +49-89-7095-6110               |
| Klinikum Grosshadern     | FAX     : +49-89-7095-6420 <-- NEW!!!    |
| 81366 Munich, Germany    | GSM     : +49-172-8933578                |
+--------------------------+------------------------------------------+

 
 
 

Using BLOBs (Byte) in VB6 via OLE DB to IDS 7.30

Post by Leopold The Ca » Sun, 31 Dec 1899 09:00:00


Richard,

In VB6 DataEnvironment associate Image control with your picture field.

Leopold


> Hi Informixers,

> without any previous experience with BLOBs, I'm having trouble starting
> a project that uses "byte" type BLOBs with IDS 7.30 as backend,
> VB6 as frontend and Informix's OLE DB provider as middleware.

> I have a rather simple employee information system using the above
> tools that my boss now wants enhanced with pictures. The VB6 and
> OLE DB documentation doesn't give me any hints about BLOBs. Does
> anybody have experience with this subject and maybe some example
> source code to point me in the right direction?

> Regards, Richard
> --
> +--------------------------+------------------------------------------+

> | EDV-Gruppe Anaesthesie   | Tel     : +49-89-7095-6110               |
> | Klinikum Grosshadern     | FAX     : +49-89-7095-6420 <-- NEW!!!    |
> | 81366 Munich, Germany    | GSM     : +49-172-8933578                |
> +--------------------------+------------------------------------------+


 
 
 

1. Updateble cursor on VB6 - Informix 7.3 via ADO/OLE DB

Hi

I'm trying to upsize an app from access to Informix and I've run into
the following problems:

1st
How do I create an scrollable and updateble cursor in VB6 using ADO via
OLE DB to
a informix 7.3 DB running on Linux?

2nd
When I try the following:

Dim rsTo as new ADODB.Recordset
rsTo.Open "Firms", conIfmx, adOpenForwardOnly, adLockPessimistic,
adCmdTableDirect
'
' Do this a couple times
'
rsTo.AddNew
rsTo!Specials = "some text"
rsTo.Update

after a variable number of updates VB6 crashes with a memory fault
error.

The key to this seems to be that Specials is a text field, thus it is of
variable length, but
can be longer that 255 chars.

Any idea why the OLE DB provider would crash in the prepare call?

Peter Hinz
Chief Software Engineer
Visual Information Systems

2. Where is the faq for this group??

3. looking for methods for handling Byte BLOBS with IDS 7.3

4. Q&E and SQLServer

5. store blob field in IDS 7.30

6. Sybase sp_recompile

7. Retrieving Blob data via OLE DB

8. SourceSafe and SQL

9. Updating Record (via stored proc) with Blob Field using VB6

10. Using the OLE DB flat file provider to automate DTS w/VB6

11. Error -2147467259 using ADO 2 OLE DB Provider for Oracle VB6 EE

12. Connect to AS4000 with VB6.0 using ADO and OLE DB

13. connection to SQL SERVER 7.0 via OLE-DB using COGNOS IMPROMPTU 7.0 tool