SYBASE ASE FOR LINUX安裝及perl串連SYBASE

安裝Sybase ASE
sybase-common-11.9.2-1.i386.rpm
sybase-ase-11.9.2-1.i386.rpm
安裝Sybase OpenClient
sybase-openclient-11.1.1-1.i386.rpm
來源:
http://www.sybase.com/products/databaseservers/linux/thankyou1192.html
方法:
rpm -hiv sybase-common-11.9.2-1.i386.rpm
rpm -hiv sybase-ase-11.9.2-1.i386.rpm
rpm -hiv sybase-openclient-11.1.1-1.i386.rpm
其預設安裝路徑為/opt/sybase-11.9.2 如需重定路徑至/home/sybase:
rpm --relocate "/opt/sybase-11.9.2"="/home/sybase" -hiv ...
運行
$HOME/install/sybinstall.sh
$HOME/.profile
其安裝程式為$HOME/bin/srvbuild,需要在Xwindows下運行,已包含在.profile中.
安裝後還需設定環境變數
SYBASE=/home/sybase
DSQUERY=sybase(servername)
安裝PERL DBI
1 需要的程式包
DBI-1.xx.tar.gz
DBD-Sybase-0.xx.tar.gz
來源:
http://www.perl.com/CPAN-local/authors/Michael_Peppler/
http://www.perl.com/CPAN-local/modules/by-module/DBI/TIMB/
2 安裝方法
gunzip DBI-1.xx.tar.gz
tar xvf DBI-1.xx.tar
    perl Makefile.PL
    make
    make test
    make install
gunzip DBD-Sybase-0.xx.tar.gz
tar xvf DBD-Sybase-0.xx.tar
    perl Makefile.PL
    make
    make test
    make install
3 基本編程範例:
#!/usr/bin/perl
use DBI;
my $server = "sybase";
my $dbh = DBI->connect('dbi:Sybase:','sa','',{syb_dbd_server=>$server});
my $sth = $dbh->prepare("sp_help");
$sth->execute();
my $text;
while(($text) = $sth->fetchrow)
{
    print $text."";
}
exit(0);