Re: Ms link to Oracle - best solution

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 - 03:46:05 CST