SYBASE ASE FOR LINUX安裝及perl連接SYBASE(轉(zhuǎn)載)

jazy

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
其默認(rèn)安裝路徑為/opt/sybase-11.9.2 如需重定路徑至/home/sybase:

rpm --relocate "/opt/sybase-11.9.2"="/home/sybase" -hiv ...

運(yùn)行
$HOME/install/sybinstall.sh
$HOME/.profile

其安裝程序?yàn)?HOME/bin/srvbuild,需要在Xwindows下運(yùn)行,已包含在.profile中.
安裝后還需設(shè)定環(huán)境變量
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."\n";
}
exit(0);



原作者：polygame
來 源：chinaasp