Re: Oracle Ref Cursor and ADO do not play well together!!

From: Leigh <lsatchell_at_geelongcity.vic.gov.au>
Date: 1 Nov 2001 13:34:29 -0800
Message-ID: <2603dc0c.0111011334.31751896@posting.google.com>

ericn_at_sarek.cjb.net (ericn) wrote in message news:<a271a1ed.0110311517.63cd0504_at_posting.google.com>...
> Thanks, though I already saw this link in many of the older posts in
> this group and I already tried all the methods listed there.
>
> Very frustrating...
>
> I finally have resigned myself to the fact the ADO just doesn't work
> well with oracle.. it seems as if this might be yet another microsoft
> invention designed to break the competion's product... so I re-coded
> my application's functions to use OO4O (Oracle Objects for OLE). Now
> everything works smoothly. I have not had any further trouble and OO4O
> seems to have all the same functionality that I was looking for from
> ADO.
>
> I would advise anyone interfacing with Oracle from a windows platform
> to use OO4O and don't waste your time playing with ADO.
>
> Enjoy!
>
> --Eric
>
> Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9rnkbl0jh1_at_drn.newsguy.com>...

I don't think Oracle would recommend you use ADO either. OO4O lets you use bind variables and other oracle specific features. If you're considering high performance and not wanting to piss off your DBA then you should use OO40.

Leigh. Received on Thu Nov 01 2001 - 15:34:29 CST