Up Prev Next
From: Thanasis Bothos <thanasis at uclink4 dot berkeley dot edu>
Subject: Re: How do I access multiple databases on multiple hosts
Date: Jul 14 1999 3:59PM
One solution would be to create proxy tables on your local Sybase server ,
each pointing to tables on the remote servers. Once you do that, you can
work with these tables as if they are local.
To accomplish this you need to CIS-enable your Sybase server; this is
actually a simple thing to do. Look up Component Integration Sevices at
Sybase's on-line docs, where you will find examples.
Hope this helps
At 02:34 PM 7/14/99 +0000, Kathy J. Doty wrote:
>Please excuse my ignorance on this subject.
>I am very new to both sybase and to Sybperl.
>Some background info - the project I am working
>on has a number of sybase databases scattered
>all around the country on a number of different hosts.
>What I would like to be able to do is
>query these databases using Sybperl to obtain
>results from some of the tables from each of these
>databases as well as results from the database
>I have on my own host and display them on a web page.
>We are using ASE v11.5.1 on a SUN workstation
>running Solaris 2.6
>We are using version 2.10 of Sybperl
>Since I as I said, I am extremely new to this,
>if you might provide a small example of how I can
>connect to multiple sybase databases on different hosts
>would be very helpful.
>I apologize if this question has been asked/answered
>before but any help you can provide would be