accessing Oracle BLOB fields with ADO

[IHAQ]

Hi

I'm having problems using ADO to access a BLOB field in an Oracle database.
Did any body face the same problem or have any way arround it? any smart
solutions????

Thanks

IHAQ

[Alan Mazursky]

"IHAQ" <khanewal2000@hotmail.com> wrote:
>
>Hi
>
>I'm having problems using ADO to access a BLOB field in an Oracle database.
>Did any body face the same problem or have any way arround it? any smart
>solutions????
>
>Thanks
>
>IHAQ

The problems that you may encounter with BLOB fields include:

1. Can not be read by the Microsoft Provider - ONLY the Oracle Provider
works.

2. You must write GETCHUNK code to retrieve the BLOB data - there is no
simple, direct reference to read BLOB fields.

We have not been successful reading BLOB using ADO. The best method appears
to be to create an object connection, retrieve with an SQL statement, and
maually load BLOB to a variable.