Home >Backend Development >PHP Tutorial >SYBASEASEFORLINUX installation and perl connection SYBASE_PHP tutorial
SYBASEASEFORLINUX installation and perl connection SYBASE_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:29:241039browse
Install Sybase ASE sybase-common-11.9.2-1.i386.rpm sybase-ase-11.9.2-1.i386.rpm Install Sybase OpenClient sybase-openclient-11.1.1-1.i386.rpm Source: http:/ /www.sybase.com/products/databaseservers/linux/thankyou1192.html Method: 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 The default installation path is /opt/sybase-11.9.2 If you need to redirect the path to /home/sybase: rpm --relocate "/opt/sybase-11.9 .2"="/home/sybase" -hiv ... Run $HOME/install/sybinstall.sh $HOME/.profile. The installation program is $HOME/bin/srvbuild, which needs to be run under Xwindows and is included. profile. After installation, you need to set the environment variable SYBASE=/home/sybase DSQUERY=sybase(servername). Install PERL DBI 1. The required package DBI-1.xx.tar.gz DBD-Sybase-0.xx.tar. gz Source: http://www.perl.com/CPAN-local/authors/Michael_Peppler/ http://www.perl.com/CPAN-local/modules/by-module/DBI/TIMB/ 2 Installation method 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 Basic programming example: #!/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." "; } exit(0);