Sybase ASE for Linux installation and Perl connection Sybase

Installing 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 want 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 installer is $home/bin/srvbuild and needs to be run under Xwindows and is included in. Profile.

Setting environment variables after installation

Sybase=/home/sybase

Dsquery=sybase (ServerName)

Installing Perl DBI

1 Required Packages

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 Examples:

#!/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);