ZClasses for Database Access

   This archive is the mSQL part of a project to provide
a consistent object oriented C++ API to commonly used
databases.  It is designed to be platform non-specific.
The databases currently supported by this API are mSQL,
Oracle 7 and a generic ODBC access class will be on the
way soon. 

New features in version 2.0:
1. A bug fixed in multiple ZmSQL class instances referencing
same ZmSQLConnection instance.
2. Support for variable arguments to be passed to ZmSQL::Open(char*,...)
3. Added member function to ZmSQLConnection to get Database listing
   of a server.
4. Added member function to ZmSQLConnection to get Table listing of 
   a database.
5. After connection to a database, ZmSQLConnection holds an array of
   ZField (Field[]) that contains info about every field in the database.

TO USE THESE CLASSES:

	Make sure that libmsql.a and msql.h are available 
	in the search path or modify the Makefile to suit your
	config.

	Edit zmsqltest.cc to preform a valid SQL by editing the
	line that has sql.Open(...).(The default should work
	if you have run any of the test utils that come with 
	the mSQL package.)

	Modify the Makefile to meet your system configuration.

	Modify the defines for SERVER, DATABASE, and TABLEin zmsqltest.cc 
	to suit your site configuration. The defaults are 
	SERVER = localhost
	DATABASE = test
	TABLE = zmsqltest (See below to create) 

	
	Type make all.

	Make sure msqld is running.

	Create a database called test if there is not one already.

	In zclass/db, type msql test < zmsqltest.sql. This will
	create the table zmsqltest that the test app accesses.
 
	Run zmsqltest.  The output should be first a list of the
	datbases on the server specified then a list of tables 
	in the specified database and then a listing of the 
	fields selected and their lengths, then a listing
	of the records returned by the SQL.  Each field should
	be on a newline and each record should be delimited
	by a dashed line.

	If zmsqltest doesn't work, mail me and I will be glad to help.

That's about it.  After zmsqltest runs correctly you can put the 
libzdb.a file where you want.

This software is available via:
	ftp://bond.edu.au/pub/Minerva/msql/Contrib/zmsql-2.1.tar
	ftp://alfred.niehs.nih.gov/pub/Database/msql/zmsql-2.1.tar

	if you have probs resolving the host name alfred.niehs.nih.gov, 
	PLEASE send
	me a mesage, fuqua@niehs.nih.gov. Our DNS is a bit confused
	right now and it would help rectify them problem.

Good Luck,
Dean Fuqua
fuqua@niehs.nih.gov
http://alfred.niehs.nih.gov/Dean/home.html


