accessing Oracle BLOB fields with ADO
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
Re: accessing Oracle BLOB fields with ADO
"IHAQ" <email@example.com> wrote:
>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
The problems that you may encounter with BLOB fields include:
1. Can not be read by the Microsoft Provider - ONLY the Oracle Provider
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.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL