From: "Jeff Siegel" <js1111@yahoo.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools,microsoft.public.access.externaldata,microsoft.public.data.odbc
References: <3a1050e8$1@rpc1284.daytonoh.ncr.com>
Subject: Re: ODBC Oracle Access and Raw SOLUTION
Date: Mon, 4 Dec 2000 11:07:39 -0500
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Original-NNTP-Posting-Host: agadulusiegej.atlantaga.ncr.com
Message-ID: <3a2bc14a$1@rpc1284.daytonoh.ncr.com>
X-Original-Trace: 4 Dec 2000 11:07:38 -0500, agadulusiegej.atlantaga.ncr.com
NNTP-Posting-Host: ncrnews.daytonoh.ncr.com
X-Original-NNTP-Posting-Host: ncrnews.daytonoh.ncr.com
X-Trace: 4 Dec 2000 11:07:41 -0500, ncrnews.daytonoh.ncr.com
X-Original-Trace: 4 Dec 2000 11:07:41 -0500, ncrnews.daytonoh.ncr.com


Here is a solution that works in Oracle  (use rawtohex in a new view)

eg
create view class2_attr as select rawtohex(class_id) class_id from classes;

Thanks for the other ideas

Jeff


"Jeff Siegel" <js1111@yahoo.com> wrote in message
news:3a1050e8$1@rpc1284.daytonoh.ncr.com...
> I can't get Access to read a raw(16) type from Oracle 8i into a usable
> format.
>
> It looks like Oracle's ODBC driver sends RAW fields to Access as Binary
> types.
> These "binary types" are not really useful in Access.  A type of TEXT
> would be more suitable.  Ideally I'd like that field to show up as TEXT in
> Access.
>
> I think this stuff came across as TEXT with Oracle 7.3, but I'm not
> positive.
>
> Is there a way to do this?  Or is this just Microsoft and Oracle not
 wanting
> to talk to each other?
>
>
> Thanks,
>    Jeff
>
>
>
>