Home | About | Documentation | Download I-Con.dk 
     
  next up previous external
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 up previous external
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
Latest News
  • New Homepage!
         24-Feb-2000
  • SourceForge Hosting
         5-Mar-2000
  • Downloads
  • WDB Ver.1.4
         6-Mar-1996
  • WDB Ver.2.000 beta
         24-Feb-2000
  •  


    Copyright © Bo Frese   Last modified: 05-03-2000