Next: Frequently Asked Questions Up: WDB Installation and Users Previous: WDB Oracle Interface
WDB mSQL Interface
The msql_dbi.pl file makes it possible to use WDB to interface to mSQL.
mSQL ( mini SQL ) is a free database system written by David J. Hughes (Bambi@Bond.edu.au). It is a lightweight database engine designed to provide fast access to stored data with low memory requirements. As its name implies mSQL offers a subset of SQL as its query interface.
mSQL has been developed under Sun OS 4.1.1 but has been tested under Solaris 2.3, Ultrix 4.3, Linux, FreeBSD 2, and OSF/1 (cc not gcc). That said, it should "autoconf" and build on most BSD derived systems, SVR4 based systems or POSIX O/S's (that should cover most of them). It has been reported that it works out-of-the-box on HP-UX, NeXT, SCO, Sequent, Cray, Tandem and a few others.
mSQL is available from
ftp://Bond.edu.au/pub/Bond_Uni/Minerva/msql/
Requirements
You need Perl version 5.000 or later with the MsqlPerl extension to use the wdb Informix interface. The Perl5 source is available from :
ftp://ftp.cis.ufl.edu/pub/perl/src/5.0/perl5.000.tar.gz or
ftp://ftp.funet.fi/pub/languages/perl/ports/perl5/perl5.000.tar.gz
The MsqlPerl extension is available from :
ftp://Bond.edu.au/pub/Minerva/msql/contrib/MsqlPerl-a1.tgz
Configuration
Follow the normal WDB configuration instructions, with the following exceptions :
- Set $DBI_FILE in the wdb.conf file to msql_dbi.pl.
- $DATEFORMAT in the wdb.conf file is ignored.
- Set the first line in the wdb script to perl5 instead of sybperl.
Creating FDF's
Included is also an mSQL version of mkfdf, called mkfdf_msql, which will produce a working template FDF file given a database and table name.
Next: Frequently Asked Questions Up: WDB Installation and Users Previous: WDB Oracle Interface Copyright © 1996 Bo Frese Rasmussen
Last update: Sun Mar 10 22:57:31 1996
| ||||
| ||||