【IT168 技术文档】安装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);