Re: Oracle User-Defined Types and ADO

Hey, many thanks. You are right. Oracle Object for Ole is excactly what I needed.

"Lionel Mandrake" <nobody_at_nospam.nowhere.nohow> wrote in message news:uQ837.127460$mG4.63444069_at_news1.mntp1.il.home.com...
> From the OLE DB Provider (8.1.7.0.0) Release Notes
> (http://otn.oracle.com/docs/tech/nt/ole_db/doc/readme.txt):
> ...
> 5.5 The Provider does not currently support Oracle8i Object datatypes.
> ...
>
> However, I believe that Oracle Objects for OLE *does* provide support for
> Object datatypes.
>
> It has been awhile since I was doing development on a regular basis.
 There
> is a book published by Sybex called "Oracle and Visual Basic Developer's
> Handbook" that would cover this topic. It is by Oracle staff members Jim
> Fedynich, Jenny Besaw and Mark Tomlinson. ISBN is 0-7821-2476-3.
>
> Also see (http://technet.oracle.com/tech/nt/ole_db/) if you haven't
> already...
>
> HTH
>
>
> "No Name" <fakeadress_at_fake.com> wrote in message
> news:4YR27.105$xW3.19472_at_newsread2.prod.itd.earthlink.net...
> > Windows 2k
> > Oracle 8.1.7
> > ADO 2.6
> > VB 6
> >
> > Hello,
> > Have been working with ADO and Oracle for a long time and have been
 pleased
> > with the results. Now I've been looking into the all of the
 possibilities
> > with Oracle's user-defined types and object tables, etc. Just as a
 quick
> > test, I created a datatype and used it in a table definition. Then if I
 do
> > a "select * from mytable" with ADO it tells me that my new datatype is
 not
> > supported.
> > I tried both Microsoft and Oracle's OleDB providers.
> >
> > So tell me, am I just completely screwed in trying to use these Oracle
> > features with a VB application???
> >
> > Thanks!
> >
> >
>
>
>
Received on Sat Jul 14 2001 - 14:45:11 CDT