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
Received on Wed Jan 19 2000 - 00:23:38 CST
