|
sybase-common-11.9.2-1.i386.rpm sybase-ase-11.9.2-1.i386.rpm www.c hinaitpower.coml8MDiw
安装Sybase OpenClient www.c hinaitpower.coml8MDiw
sybase-openclient-11.1.1-1.i386.rpm www.c hinaitpower.coml8MDiw
来源: http://www.sybase.com/products/databaseservers/linux/thankyou1192.html www.c hinaitpower.coml8MDiw
方法: 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: www.c hinaitpower.coml8MDiw
rpm --relocate "/opt/sybase-11.9.2"="/home/sybase" -hiv ... www.c hinaitpower.coml8MDiw
运行 $HOME/install/sybinstall.sh $HOME/.profile www.c hinaitpower.coml8MDiw
其安装程序为$HOME/bin/srvbuild,需要在Xwindows下运行,已包含在.profile中. 安装后还需设定环境变量 SYBASE=/home/sybase DSQUERY=sybase(servername) www.c hinaitpower.coml8MDiw
安装PERL DBI 1 需要的程序包 www.c hinaitpower.coml8MDiw
DBI-1.xx.tar.gz www.c hinaitpower.coml8MDiw
DBD-Sybase-0.xx.tar.gz www.c hinaitpower.coml8MDiw
来源: http://www.perl.com/CPAN-local/authors/Michael_Peppler/ www.c hinaitpower.coml8MDiw
http://www.perl.com/CPAN-local/modules/by-module/DBI/TIMB/ www.c hinaitpower.coml8MDiw
2 安装方法 www.c hinaitpower.coml8MDiw
gunzip DBI-1.xx.tar.gz tar xvf DBI-1.xx.tar www.c hinaitpower.coml8MDiw
perl Makefile.PL make make test make install www.c hinaitpower.coml8MDiw
gunzip DBD-Sybase-0.xx.tar.gz tar xvf DBD-Sybase-0.xx.tar perl Makefile.PL make make test make install www.c hinaitpower.coml8MDiw
3 基本编程范例: www.c hinaitpower.coml8MDiw
#!/usr/bin/perl use DBI; www.c hinaitpower.coml8MDiw
my $server = "sybase"; www.c hinaitpower.coml8MDiw
my $dbh = DBI->connect('dbi:Sybase:','sa','',{syb_dbd_server=>$server}); my $sth = $dbh->prepare("sp_help"); $sth->execute(); my $text; www.c hinaitpower.coml8MDiw
while(($text) = $sth->fetchrow) { print $text."\n"; } exit(0); www.c hinaitpower.coml8MDiw
|