[AccessD] Accessing Oracle BLOB via MS Access

Hi Jack,

I also work with Oracle data in Access but have been able to work around the 
field problem you ask about though luck as I haven't needed any of those 
fields in my apps. I am wondering if a pass-through query with an instr or 
the like to reformat the data on teh Oracle side before it get's sent over 
to the Access side of things would work? In a Pass Trhough query you are 
using Oracle SQL and you should be able to access those fields that way and 
if you can format them into regular string type fields through something 
like the instring function (like a left or a mid function in Access) it may 
do the job for you.

Gary Kjos
garykjos at hotmail.com





>From: Drawbridge.Jack at ic.gc.ca
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Accessing Oracle BLOB via MS Access
>Date: Wed, 26 Nov 2003 09:40:02 -0500
>
>I'm hoping someone has an answer or advice on this. We have Oracle 9i with 
>a
>table containing Blob/Clob data types. We also do a lot of data base 
>queries
>against Oracle via Access 97 and Access 2000. (ODBC ADO).
>
>A new application has the blob/clob. Attempting to access these fields 
>gives
>an error in Access. Does anyone have a technique or samples of how to 
>access
>this Oracle data type with Access 97 or 2000?
>
>TIA.
>Jack
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
online games and music with a high-speed Internet connection!  Prices start 
at less than $1 a day average.  https://broadband.msn.com (Prices may vary 
by service area.)