How to read a BLOB from Oracle

Discussion in 'Microsoft ADO .NET' started by Chuck Vance, Dec 4, 2007.

  1. Chuck Vance

    Chuck Vance Guest

    Hello ng,

    I try to read a BLOB (HugeBlob) field from oracle 10g database.
    (dotnet-framework 1.1, 2.0)

    1.) I have no chances to install / register third party DLLs because I don't have local admin rights.
    2.) When using "System.Data.OracleClient" the Connection fires the exception "Oracle client software version 8.1.7 or greater
    needed" when its trying to open.

    So using OleDB seems to be the only choice. "Provider=MSDAORA;..."

    I can access all "nornal" fields/columns. Only the BLOB causes the exception:
    "The datatype is not supported." (translated)

    How can I access the BLOB?
    Thanx in advance.
     
    Chuck Vance, Dec 4, 2007
    #1
    1. Advertisements

  2. Download odp.net from otn.oracle.com. It is Oracle's stack for .NET.

    Why? The .Net 2.0 provider is OLD. It was written during the 8i timeframe
    and I am not sure if it has been updated. Perhaps in SP1 for .NET Framework
    2.0, but certainly not in the original release bits. Oracle, on the other
    hand, has altered parts database access bits, which make the OracleClient
    (at least the original installed with the Framework) puke on 10g. NOTE that
    you will have to download the correct ODP.NET, unless Oracle has refined the
    libraries to span the offerings (doubt it, but possible).

    --
    Gregory A. Beamer
    MVP, MCP: +I, SE, SD, DBA

    *************************************************
    | Think outside the box!
    |
    *************************************************
    "Chuck Vance" <nomail@invalid> wrote in message
    news:fj47gt$7tt$03$-online.com...
    > Hello ng,
    >
    > I try to read a BLOB (HugeBlob) field from oracle 10g database.
    > (dotnet-framework 1.1, 2.0)
    >
    > 1.) I have no chances to install / register third party DLLs because I
    > don't have local admin rights.
    > 2.) When using "System.Data.OracleClient" the Connection fires the
    > exception "Oracle client software version 8.1.7 or greater
    > needed" when its trying to open.
    >
    > So using OleDB seems to be the only choice. "Provider=MSDAORA;..."
    >
    > I can access all "nornal" fields/columns. Only the BLOB causes the
    > exception:
    > "The datatype is not supported." (translated)
    >
    > How can I access the BLOB?
    > Thanx in advance.
    >
    >
    >
    >
    >
    >
    >
     
    Cowboy \(Gregory A. Beamer\), Dec 5, 2007
    #2
    1. Advertisements

  3. Chuck Vance

    Chuck Vance Guest

    Hi Gregory,
    > you will have to download the correct ODP.NET, unless Oracle has refined the libraries to span the offerings (doubt it, but
    > possible).


    >> 1.) I have no chances to install / register third party DLLs because I don't have local admin rights.


    Can the ODP.NET be installed/used without admin rights?
    Chuck
     
    Chuck Vance, Dec 5, 2007
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Robert Vabo

    .NET and Oracle BLOB

    Robert Vabo, Aug 20, 2003, in forum: Microsoft ADO .NET
    Replies:
    0
    Views:
    253
    Robert Vabo
    Aug 20, 2003
  2. Robert Vabo

    Oracle BLOB

    Robert Vabo, Aug 27, 2003, in forum: Microsoft ADO .NET
    Replies:
    0
    Views:
    273
    Robert Vabo
    Aug 27, 2003
  3. Prasad
    Replies:
    0
    Views:
    569
    Prasad
    Dec 1, 2003
  4. Goku

    Inserting blob using ORACLE OLEDB

    Goku, Dec 6, 2003, in forum: Microsoft ADO .NET
    Replies:
    3
    Views:
    1,511
    Miha Markic
    Dec 7, 2003
  5. Guest

    Oracle Lob (blob) Read / Write woes

    Guest, Mar 29, 2006, in forum: Microsoft ADO .NET
    Replies:
    3
    Views:
    1,335
    Guest
    Mar 29, 2006
Loading...

Share This Page