安装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."\n";
}
exit(0);