Hi to all,
my original question was :
> Can Mosaic access DBMS (i.e. Oracle) via SQL ?
------------------------------- SUMMARY --------------------------------------
- Mosaic has no built-in support for DBMS via SQL (at the moment)
- This doesn't mean that you can't do it. In fact you can :
1- Use PERL to build procedure that take data from an HTML form, send queries to the DB and then convert the query output in HTML again.
The most important DB's have PERL extensions : ORAPERL for Oracle, SYPERL for Sybase, INGRAPERL for Ingres, etc.. (See the comp.lang.perl neswgroup).
2- Get GQSL, a gateway program that provides a forms interface to SQL DBMS's.
Try the URL http://www.ncsa.uiuc.edu/SDG/People/jason/pub/gsql/starthere.html
it's a good start point with examples.
I haven't tested GSQL yet. At the moment I am reading the documentation; it seems to be a very good solution to the purpose.
For GSQL and related software many thanks to (sorry for using simply your e-mail addresses) email@example.com and firstname.lastname@example.org. (I'll send you news about my next use of GQSL).
Thanks also to margaret cobleigh (email@example.com) who provided the URL above.
Other interesting URL's are :
Finally many thanks to all the people who responded :
Paul Wain (firstname.lastname@example.org)
Birger Wathne (email@example.com)
Steve Kilbane (firstname.lastname@example.org)
Flavio Maggi (email@example.com)
Derald McMillan (firstname.lastname@example.org)
Andrew Mellanby (email@example.com)
Roy Ramberg (firstname.lastname@example.org)
John Marsh (email@example.com)
Ted Sasscer (firstname.lastname@example.org)
Jeff ...... (email@example.com)
Shaun Gregory (firstname.lastname@example.org)
Anthony Baxter (email@example.com)
This archive was generated by hypermail 2.1.2 : Fri Sep 28 2001 - 23:09:16 CDT