php 连接 sybase,SYBASE ASE FOR LINUX安装及perl连接SYBASE-PHP教程,系统相关

安装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);