Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

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
>much appreciated.
>Kathy Doty