mSQL 2.0.1 released

MSQL is a relational, client/server database server that supports a subset of ANSI SQL. It is very popular as a back end for web sites on Unix plataforms.

Hughes Technologies Pty Ltd released version 2.0.1 of the Mini SQL database system and the bundle was uploaded by David J. Hughes onto Pete Norloff's BBS. To get the archive (MSQL201B.ZIP 2583K) jump Pete's Site clicking this URL:

http://www.os2bbs.com

Even though the 2.0 series software has proven to be stable enough for the development
of large applications, the development process is continual. Features are added and bugs are fixed as they are identified so please check developer's web site regularly for upates at

http://www.Hughes.com.au/

This new release includes the new mSQL documentation kit for 2.0. The documentation now includes a very comprehensive (i.e. 80+ pages) User Guide. The User Guide is included as a postscript file for printing on your laser printer. It is also included as an HTML document for those that do not have a postscript laser. Some of the formatting is lost during the conversion to HTML so the postscript version is certainly the best to use if you can. The User Guide is located in the doc directory of the distribution.

As the software has now officially left the Beta test stage, it is being released as a commercial package. The software may be evaluated for 14 days before a license fee is due. If you continue to use the software after 14 days you are required to pay a licnese fee. To license your copy of mSQL 2.0, simply print out the invoice form located in the doc/ directory of this distribution and return it with payment to us either via postal mail or via fax. Our fax number and postal address has changed since the 1.x release so please check the details before sending your payment.

Hughes Technologies continues to support the original ethos of the Internet by providing mSQL 2.0 (and all other Hughes Technologies products) free of charge to certain organisations. If your use of our software is in conjunction with your work or study at one of the organisational types listed below you may continue to use the software beyond the 14 day evaluation without licensing your copy.

o Universities and schools
o Non-commercial research organisations
o Registered not-for-profit organisations
o Registered charities
o Churches

Government agencies and commercial research organisations (such as research departments of corporations or government agencies) are not covered in this clause and as such must license the software if it is to be used.

Please enjoy this release of mSQL and remeber that further information and product support is always available. Our web site contains a lot of on-line documentation that will help you work with mSQL. If you need further assistance, please contact info@Hughes.com.au for general
information or support@Hughes.com.au for product support. If you identify a bug please report it to bugs@Hughes.com.au including the output of "msqladmin version" and an example query or script that reproduces your problem.

Install OS/2

------------------------------------------------------------------------------
INSTALL for the OS/2 Warp Connect version of mSQL version 2.0.x
------------------------------------------------------------------------------



Compilation:
------------

Note: If you don't have a compiler or you don't want to recompile, skip
this section and see 'Installation' instead.

To compile the source you need IBM C/C++ Set/2 or any equivalent compiler.
I've tested the source with IBM C/C++ FirstStep Tools and - later - with
IBM Visual Age C++.
autoconf prepare the Makefiles for compilation
nmake compile all
nmake all compile all
nmake clean delete all object files
nmake delete delete all EXEs and object files
nmake delete_all like 'delete', but deletes all INFs
DOC\ and all files in BIN\OS2\,
INCLUDE\ and LIB\OS2\ as well as all
output files (*.c & *.h) created by
the compiler-compiler (bison/lex)
nmake dist create a distribution archive
--> creates a clean environment,
afterwards 'autoconf' has
to be executed!
nmake install create destination directory struc-
ture and install files



Installation:
-------------

If you don't have a C compiler, you may install the pre-compiled binaries
with the following command entered from the top of the mSQL archive direc-
tory:
os2_inst\install (\OS2_INST\ -> install.cmd, REXX)

Be sure, that the dynamic link library mSQL.DLL is located to a directory
which can be access via LIB_PATH! The best is to extend your LIB_PATH
entry in the CONFIG.SYS file with the binary directory of mSQL.



TESTING:
--------

To test the result do the following (assumption, that the files are
located in \PUBLIC\mSQL2\):
1) cd \PUBLIC\mSQL2\bin change to installation directory
2) start msqld start server
3) msqladmin version check version
4) msqladmin create test create a database "test"
5) msql test < test.msql > xxx run test script
6) msqladm drop test drop database "test"
7) del xxx remove test result file
8) msqladmin shutdown stop server
On 3) you should see the correct program version. 4) will create a database
located in the directory "\PUBLIC\mSQL2\msqldb\test", 6) will remove this
directory. Check "xxx" against the source "test.msql" - all querys should
succeed with the exception of twos (not null, non-unique key). After the
check step 7) should be performed ...



Configuration of the server:
----------------------------

See the online documentation!



Mail Address:
-------------

This small note and the port was written by
Dirk Ohme, eMail: dohme@nerosworld.com
Dirk_Ohme (2:246/2001.9@fidonet)


History

mSQL 2.01 PL B 07 - Sep - 1997
----------------------------------------

o configurable timeout for TCP/IP reads - no longer lock-ups when
a connection goes away.
o fixed a bug within temporary tables, used for instance at queries
using ORDER BY, causing invalid data returns and server crashes.
o fixed a bug with configuration opton 'host_lookup=false' which
prevents the local machine ('localhost') from detection.
o fixed a bug within creation of DISTINCT queries, causing server
hangs, crashes and invalid data - the bug seems to come from a
compiler error of the Visual Age C++ compiler ... ARGH!
o adaption of online manual (INF version).



mSQL 2.01 PL A 01 - Sep - 1997
----------------------------------------
o adaption to Unix version 2.01 (production release)
o note: This is not the final release - documentation has to
be revised and some bugs fixed!



mSQL 2.0 Beta 7 14 - May - 1997
----------------------------------------
o adaption to Unix version 7.1
o start of 'twins' project - support for both OS/2 and Windows NT
o fixed a bug in src/msql/table.c::initTable(), which prevented
order by from correct working



mSQL 2.0 Beta 6 15 - Apr - 1997
----------------------------------------
o adaption to Unix version



mSQL 2.0 Beta 5 ?? - ??? - 1997
----------------------------------------
o (never released)
o adaption to Unix version
o icons adapted for screen resolution 1024 * 768
o removed a nasty (OS/2) bug from MSQL.EXE causing a SIGSEGV
(it seems that the Visual Age C++ has sometimes problems with
dynamically allocated (on the heap) variables in procedures
... switched to 'static' (e.g. data area instead of the heap)
did the trick ... strange!
o added descriptions to the online manual for the newer API calls



mSQL 2.0 Beta 4 28 - Feb - 1997
----------------------------------------
o adaption to Unix version
o re-arrangement in sources so that port is looking more similar
to the original sources (and porting is easier)
o bug-fixes in lite engine (wrong variable type for number of com-
mando parameters caused 'parameter error' on printf() and
fprintf()).
o corrected lite's online description (OS/2 INF) of test() command.
o bug-fixes in mSQL server engine (pre-processor overload of malloc()
caused stack errors under Visual Age C++, several locations where
memory was allocated but not initialized correctly).



mSQL 2.0 Beta 3 ?? - ??? - ????
----------------------------------------
o skipped - never released



mSQL 2.0 Beta 2 ?? - ??? - ????
----------------------------------------
o skipped - never released



mSQL 2.0 Beta 1 9 - Jan - 1997
----------------------------------------
o adaption to Unix version
o first public version
o introduction of SYSLEVEL information system
o adaption of online documentation
@Macarlo, Inc.
@Macarlo's Shareware & Web
OS/2
Java Lobby Member
Java Site Accredited

[TOP] [HOME] [INDEX]