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
Printable View
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
"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.
