Re: Connect to Sybase from Oracle

From: Joe and Anne Buhl <jabuhl_at_qwest.net>
Date: Sat, 17 Feb 2001 10:27:34 -0700
Message-ID: <Rkyj6.1390$GE.208187@news.uswest.net>

Actually the best solution would be to fire up the component integration services with the Sybase server and create proxy tables that point to the Oracle database. This will require the direct connect for Oracle from Sybase. This allows your application to stay the same. It will require a later release of Sybase, 11.5 or 11.9 can't remember which. We ran it in production for a few years and it worked pretty good.

joe

"Jining Han" <jining_han_at_MailAndNews.com> wrote in message news:3A923871_at_MailAndNews.com...
> Oracle Transparent Gateways is probably your best option.
>
> Of course the cheap and quick and dirty way to do this is to have Sybase
> spit
> out the data into files.
>
> Good luck
> ----------
> Jining Han
> Sallie Mae
> >===== Original Message From "Olivier Marcou" <Marcou.Olivier_at_wanadoo.fr>

---

> >Hi,
> >
> >Today, data come from somes files, but in few days, data comes from
 Sybase.
> >Is it possible to directly access to Sybase from Oracle v7.3 (and after
> >Oracle v8) ?
> >
> >Thanks for your help.
> >
> >Olivier
> >
>
> ------------------------------------------------------------
> Get your FREE web-based e-mail and newsgroup access at:
> http://MailAndNews.com
>
> Create a new mailbox, or access your existing IMAP4 or
> POP3 mailbox from anywhere with just a web browser.
> ------------------------------------------------------------
>
Received on Sat Feb 17 2001 - 11:27:34 CST