Blobs and Oracle

[Rod Orr]

Public Trust is going through the process of doing an evaluation of ASPdb Enterprise.

A requirement is the ability to store blobs in the database and retrieve them (graphics, Word Documents, Excel etc).
We really need a working example to access this product please.


PROBLEM: Results appear to be coming back but we do not see a picture: (Picture was loaded into the database using sql/loader). We only see a place holder

ISS Server 1.0 is NT 4.0 Service Pack 5.
Oracle Version: 8i runing on Dynix 4.4.5
Odbc Driver: Oracle ODBC Driver 8.00.58 (We tried the microsoft Driver 2.573 without any success using blobs)

Table layout:

SQL> descr webuser.emp_table
Name Null? Type
------------------------------- -------- ----
KEY_VALUE NUMBER(38)
EMP_NAME VARCHAR2(40)
PHONE_NO VARCHAR2(20)
B_LOB BLOB


Our ASPdb Script so far mainly source from ASPdb examples:

<%response.buffer=true%>
<CENTER><h2>In-Cell image Demo</h2>
<%
Set X=Server.CreateObject(&#34;AspDB.EP&#34
X.dbUnit=1

X.dbDSN=&#34;DSN=WEB; UID=webuser; PWD=webuser;&#34;
X.dbDBtype=&#34;oracle&#34;

X.dbmode=&#34;grid&#34;
X.dbSQL=&#34;Select * FROM emp_table&#34;
X.dbGridHideFlds=&#34;2&#34;
X.dbGridTableTag=&#34;BORDER=1&#34;
&#39;to display inlcell jpg
X.dbBLOB=&#34;b_lob,image/jpg,browser,1&#34;
X.ASPdbEP
%>

</CENTER>

[Bill Hunt]

I am also doing an AspDb Oracle implementation.
I would like to share the experiences if you would&#39;nt mind.
My email is williamhunt@compuserve.com.




------------
Rod Orr at 2/14/00 10:58:30 PM

Public Trust is going through the process of doing an evaluation of ASPdb Enterprise.

A requirement is the ability to store blobs in the database and retrieve them (graphics, Word Documents, Excel etc).
We really need a working example to access this product please.


PROBLEM: Results appear to be coming back but we do not see a picture: (Picture was loaded into the database using sql/loader). We only see a place holder

ISS Server 1.0 is NT 4.0 Service Pack 5.
Oracle Version: 8i runing on Dynix 4.4.5
Odbc Driver: Oracle ODBC Driver 8.00.58 (We tried the microsoft Driver 2.573 without any success using blobs)

Table layout:

SQL> descr webuser.emp_table
Name Null? Type
------------------------------- -------- ----
KEY_VALUE NUMBER(38)
EMP_NAME VARCHAR2(40)
PHONE_NO VARCHAR2(20)
B_LOB BLOB


Our ASPdb Script so far mainly source from ASPdb examples:

<%response.buffer=true%>
<CENTER><h2>In-Cell image Demo</h2>
<%
Set X=Server.CreateObject(&#34;AspDB.EP&#34
X.dbUnit=1

X.dbDSN=&#34;DSN=WEB; UID=webuser; PWD=webuser;&#34;
X.dbDBtype=&#34;oracle&#34;

X.dbmode=&#34;grid&#34;
X.dbSQL=&#34;Select * FROM emp_table&#34;
X.dbGridHideFlds=&#34;2&#34;
X.dbGridTableTag=&#34;BORDER=1&#34;
&#39;to display inlcell jpg
X.dbBLOB=&#34;b_lob,image/jpg,browser,1&#34;
X.ASPdbEP
%>

</CENTER>

[Frank Kwong]

Just remember that -

Look for &#34;Bob Cummings&#34; in this forum and contact him. He has Oracle&#39;s BLOBs working some time ago and his BLOBs contains a mix of BMP and JPGs.


FK


------------
frank at 2/26/00 4:04:59 AM

1. Make sure the BLOB field is of ADO datatype 201 or 203.
2. Make sure the jpg stored in the BLOB field has a user controllable header offset.
3. ASPdb examples works in MS-SQL (pubs DB) BLOB fields which stores the gif files with no header offset.
4. If still have problem. Send me a small sample (5-10 records) of you ORACLE DB and I&#39;ll look at that.

FK



------------
Rod Orr at 2/14/00 10:58:30 PM

Public Trust is going through the process of doing an evaluation of ASPdb Enterprise.

A requirement is the ability to store blobs in the database and retrieve them (graphics, Word Documents, Excel etc).
We really need a working example to access this product please.


PROBLEM: Results appear to be coming back but we do not see a picture: (Picture was loaded into the database using sql/loader). We only see a place holder

ISS Server 1.0 is NT 4.0 Service Pack 5.
Oracle Version: 8i runing on Dynix 4.4.5
Odbc Driver: Oracle ODBC Driver 8.00.58 (We tried the microsoft Driver 2.573 without any success using blobs)

Table layout:

SQL> descr webuser.emp_table
Name Null? Type
------------------------------- -------- ----
KEY_VALUE NUMBER(38)
EMP_NAME VARCHAR2(40)
PHONE_NO VARCHAR2(20)
B_LOB BLOB


Our ASPdb Script so far mainly source from ASPdb examples:

<%response.buffer=true%>
<CENTER><h2>In-Cell image Demo</h2>
<%
Set X=Server.CreateObject(&#34;AspDB.EP&#34
X.dbUnit=1

X.dbDSN=&#34;DSN=WEB; UID=webuser; PWD=webuser;&#34;
X.dbDBtype=&#34;oracle&#34;

X.dbmode=&#34;grid&#34;
X.dbSQL=&#34;Select * FROM emp_table&#34;
X.dbGridHideFlds=&#34;2&#34;
X.dbGridTableTag=&#34;BORDER=1&#34;
&#39;to display inlcell jpg
X.dbBLOB=&#34;b_lob,image/jpg,browser,1&#34;
X.ASPdbEP
%>

</CENTER>