MEETINGHOUSE LIBRARY PROGRAM

An Open Source Java program that is implements a mini database suitable for a small library typically found in a church meetinghouse. It utilizes Java, and datavision and open source report generator similar to Crystal Reports©. Features Item Check In, Item check out, Searching by Title, Subject, Inventory Report and Checked Out Report .




MANUAL and more screen shots

INSTALTION AND Prerequisites

Windows 95 – Untested may not work - May not work with MDAC2.6

  1. Download and Install Java 1.4 Runtime or greater www.sun.com

  2. Install DCOM, Microsoft Jet, and MDAC 2.6 (If not already installed/updated) ---Free downloads from www.microsoft.com

  3. Download and install the library setup program Library_Database 0.95 Includes Source Code

Windows 98, ME

  1. Download and Install Java 1.4 Runtime or greater www.sun.com

  2. Install Microsoft Jet, and MDAC 2.7 (If not already installed/updated) ---Free downloads from www.microsoft.com

  3. Edit config.sys and add a line shell=comand.com /e:8192 /p.

  4. Download install the library setup program Library_Database 0.95 Includes Source Code

Windows 2000, XP

  1. Download and Install Java 1.4 Runtime or greater www.sun.com

  2. Update to MDAC 2.7 if necessary www.Microsoft.com

  3. Download install the library setup program Library_Database 0.95 Includes Source Code

Linux – Not Fully working Currently having SQL and installation issues

  1. Download and Install Java 1.4 Runtime or greater www.sun.com

  2. Make sure a database program has been installed such as MySQL or Postgres

  3. Make sure a ODBC driver and ODBCConfig is installed

  4. Download install the library setup program Library_Database 0.95 Includes Source Code on a Windowze machine

  5. Copy the folder installed on the Windoze machine to you Linux machine

  6. Use the SQL.txt file to create SQL tables ..... Note You will need to create your own permissions – grant options

  7. Configure ODBCConfig create a link called library leave the user name and password blank

  8. ISSUES::

    A. Need script to set class path for datavsion

    B. SQL case sensitive issues, SQL syntax compatibilities issues

Contact me (NO SPAM PLEASE)

[email protected]

Other Links

Java at http://www.sun.com

Installer program Inno Open Source Windows Installer

http://www.istool.org and http://www.innosetup.com

DataVision is an Open Source reporting tool similar to Crystal Reports.



DataVision is developed and maintained by Jim Menard ([email protected]). The

latest version of DataVision can be found on the DataVision Web page at

http://datavision.sourceforge.net.



Hosted by www.Geocities.ws

1