Installing DBD::SQLAnywhere on Unix and Mac OS X

Install the DBD::SQLAnywhere interface on the supported Unix and Mac OS X platforms to use Perl to access SQL Anywhere databases.

Prerequisites

You must have ActivePerl 5.6.0 build 616 or later and a C compiler installed.

Task

Download the DBI module source from http://www.cpan.org.
Extract the contents of this file into a new directory.
At a command prompt, change to the new directory and run the following commands to build the DBI module.
perl Makefile.PL
make
If for any reason you need to start over, you can use the command make clean to remove any partially built targets.
Use the following command to test the DBI module.
make test
To complete the installation, run the following command at the same prompt.
make install

Make sure the environment is set up for SQL Anywhere.

Depending on which shell you are using, enter the appropriate command to source the SQL Anywhere configuration script from the SQL Anywhere installation directory:

In this shell...	Use this command...
sh, ksh, or bash	. bin/sa_config.sh
csh or tcsh	source bin/sa_config.csh

At a shell prompt, change to the sdk/perl subdirectory of your SQL Anywhere installation.
At a command prompt, run the following commands to build DBD::SQLAnywhere.
perl Makefile.PL
make
If for any reason you need to start over, you can use the command make clean to remove any partially built targets.
To test DBD::SQLAnywhere, copy the sample database file to your sdk/perl directory and make the tests.
cp samples-dir/demo.db .
dbsrv16 demo
make test
If the tests do not run, ensure that the bin32 or bin64 subdirectory of the SQL Anywhere installation is in your path.
To complete the installation, run the following command at the same prompt.
make install

Results

The DBI Perl module and the DBD::SQLAnywhere interface are ready for use.

Next

Optionally, you can delete the DBI source tree. It is no longer required.

Discuss this page in DocCommentXchange.