Re: ODBC Oracle Access and Raw SOLUTION

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_at_yahoo.com> wrote in message news:3a1050e8$1_at_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
>
>
>
>
Received on Mon Dec 04 2000 - 17:07:39 CET