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 reset 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 must be run in Xwindows and is included in. profile.
After installation, you also need to set Environment Variables
SYBASE =/home/sybase
DSQUERY = sybase (servername)
Install PERL DBI
1. 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 $ something = $ dbh-> prepare ("sp_help ");
$ Something-> execute ();
My $ text;
While ($ text) = $ something-> fetchrow)
{
Print $ text ."";
}
Exit (0 );