accessing Oracle BLOB fields with ADO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: accessing Oracle BLOB fields with ADO

Hybrid View

  1. #1
    IHAQ Guest

    accessing Oracle BLOB fields with ADO


    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

  2. #2
    Alan Mazursky Guest

    Re: accessing Oracle BLOB fields with ADO


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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center