Re: Ms link to Oracle - best solution

But how does it compare to OCI?
Brad

On Wed, 19 Jan 2000 09:46:05 GMT, M. Armaghan Saqib <armaghan_at_yahoo.com> wrote:

>Oracle Objects for OLE is a reasonably simple solution and gives you
>native access from any OLE application.
>
>My tool SQL Link for XL uses OO4O and is considerably fast compared to
>ODBC access.
>
>regards,
>M. Aramghan Saqib
>------------------------------------------------------------------------
>* SQL PlusPlus: Add power to SQL Plus.
>* SQL Link for XL: Integrate Oracle with XL.
>* Oracle CBT with sample GL (Triggers and Forms Source Code included.
>Download free: http://www.geocities.com/armaghan/
>------------------------------------------------------------------------
>
>In article <863lmj$c69$1_at_bgtnsc01.worldnet.att.net>,
> "Corey Lawson" <corey.lawson_at_worldnet.att.com> wrote:
>> Oracle has also packaged the OCI (Oracle Call Interface) into some
>OCXs/TLBs
>> that you can use directly...it should be an option to install that
>stuff
>> from the Oracle client software installer...
>>
>> "Brad Aisa" <baisa_at_my-deja.com> wrote in message
>> news:3884E6AD.E2BB7015_at_my-deja.com...
>> > Aleksander Miler wrote:
>> > >
>> > > Hi,
>> > >
>> > > Does anybody knows what can be the best solution for importing
>data from
>> > > Oracle database to Microsoft tools. I mean especially about MS Sql
>> Server
>> > > and its OLAP tools.
>> > > One of solutions can be ODBC - unfortunatelly as I know it is not
>very
>> fast
>> > > :-(
>> > > Maybe anybody knows (and has some experience) something else -
>maybe
>> about
>> > > ADO or OleDB (esp. concerning Oracle) ?? Or maybe the best
>selution
>> would be
>> > > to use Oracle OCI interface ???
>> >
>> > MS has taken great pains to make their stuff work with Oracle.
>Also, I
>> > think you are mistaken about ODBC being "slow." But that said, MS
>> > includes a high performance OLE DB driver with their latest
>products.
>> > But you should also be able to use the Oracle ODBC driver. Another
>> > alternative is just to export the data into a text file, then use
>bcp to
>> > load it into MS SQL.
>> >
>> > --
>> > Brad Aisa <baisa_at_NOSPAMbrad-aisa.com>
>> > http://www.brad-aisa.com/ -- PGP public key available at:
>> > http://pgp.mit.edu:11371/pks/lookup?search=Brad+Aisa&op=index
>> >
>> > "The paper wall will be next to fall." -- Brad Aisa
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Jan 19 2000 - 06:23:48 CST