On Tue, Oct 02, 2001 at 03:27:04PM -0400, [EMAIL PROTECTED] wrote:
>
> Does anyone have a sample code which demonstrates
> using DBI to access both a remote oracle and local
> sybase servers simultaneously?
Umm, how about this:
$syb = DBI->connect('dbi:Sybase:foo', ...);
$ora = DBI->connect('dbi:Oracle:bar', ...);
It's a bit tricky, but I hope you get the idea :-)
> Goal is to connect & perform same operations
> (insert & select & delete) on both databases. From a
> code level perspective, each insert
> and update must in affect be performed twice ( once
> for each datastore oracle/sybase). This would render
> the databases equal in terms of information added
> & and removed.
>
> I have an idea of how I might try it but wanted to
> know if anyone had done it or knows exactly how,
> caveats, etc. The oracle queries would be to a
> remote host while the sybase queries would be on
> the local host.
Take a look at DBD::Multiplex (The one shipped with the DBI is old.
Search the archives for the url of the latest, or some kind soul
will post it.)
Tim.
