DOCUMENT:Q194799  12-SEP-2001  [odbc]
TITLE   :HOWTO: Retrieve RAW/LONG RAW Data from Oracle for ASP Page
PRODUCT :Open Database Connectivity (ODBC)
PROD/VER::2.0,2.1,2.1 SP2,2.5,2.6,2.7,Build 2.573.2927
OPER/SYS:
KEYWORDS:kbcode kbATM kbASP kbOLEDB kbOracle kbProvider kbGrpDSVBDB kbGrpDSMDAC kbDSupport kbMDA

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft ODBC for Oracle version 2.5 Build 2.573.2927 
 - ActiveX Data Objects (ADO), versions 2.0, 2.1, 2.1 SP2, 2.5, 2.6, 2.7 
 - Microsoft Active Server Pages 
 - Microsoft Data Access Components versions 2.5, 2.6, 2.7 
-------------------------------------------------------------------------------

SUMMARY
=======

This article explains how to insert and retrieve RAW or LONG RAW data from an
Oracle database for use in an Active Server Pages (ASP) page.

MORE INFORMATION
================

1. To insert images into an Oracle table, see the following article in the
   Microsoft Knowledge Base:

   Q185958 HOWTO: Use ADO GetChunk/AppendChunk with Oracle for BLOB Data

   NOTE: We do not recommend using Microsoft Access to insert images into Oracle.
   Microsoft Access adds an OLE wrapper around the object that prevents the
   object from being extracted and interpreted correctly by ASP.

2. To query and display the image, use the following code:

         <%@ LANGUAGE="VBSCRIPT" %>

         <%
         'Clear existing HTTP header information.
         Response.Expires = 0
         Response.Buffer = TRUE
         Response.Clear

         'Set the HTTP header to an image type, if you want to display
         'a jpg you need to use the "image/jpeg" content type.
         Response.ContentType = "image/gif"

         Dim strTemp

         Set oConn = Server.CreateObject("ADODB.Connection")

        'You need to change this line to reflect your DSN, UID
        'and PWD.
         oConn.Open "DSN=Ovteam;UID=userid;PWD=password;"

        'Change this line to use your table that contains a raw or
        'long raw field.  In this case, ID is the primary key of the
        'IMAGE table and IMG is the RAW or LONG RAW data column.
         sSQL = "Select ID, IMG from IMAGE where ID = 1"

         Set oRS = Server.CreateObject("ADODB.Recordset")
         oRS.Source = sSQL
         oRS.ActiveConnection = oConn

        'The cursor type does not seem to matter.  A keyset cursor was used
        'with success for this article; however, you will not be able to
        'scroll with it because the content type of this page is set for
        '"image/gif".

         oRS.Open

         strtemp = oRS("IMG")
         Response.BinaryWrite(strTemp)
         Response.End

         oRS.Close
         Set oRS = nothing
         oConn.Close
         Set oConn = nothing
      %>

NOTE: Because you are changing the content type of this page, you can display
only one image. In order to incorporate this into a page with text, you need to
do a server side include of this .asp page to get the picture into another page.

REFERENCES
==========

For additional information, please see the following article in the Microsoft
Knowledge Base:

   Q192743 HOWTO: Use ADO GetChunk/AppendChunk with Oracle for TEXT Data

Additional query words:

======================================================================
Keywords          : kbcode kbATM kbASP kbOLEDB kbOracle kbProvider kbGrpDSVBDB kbGrpDSMDAC kbDSupport kbMDAC250 kbMDAC260 kbmdac270 kbado270 
Technology        : kbAudDeveloper kbADOsearch kbASPsearch kbADO210 kbADO200 kbADO210sp2 kbADO250 kbADO260 kbODBCSearch kbMDACSearch kbMDAC250 kbMDAC260 kbODBCOracle25732927 kbMDAC270 kbADO270 kbODBCOracle250Search
Version           : :2.0,2.1,2.1 SP2,2.5,2.6,2.7,Build 2.573.2927
Issue type        : kbhowto

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2001.