SQL-GAteway for WWW
Hello everybody,
Does anybody of you know how to write a SQL-WWW-GAteway for Informix?
I have tried to use the CGI, but I have not had success.
here is the contents of the cgi-script:
PATH="/disk4/usr1/rz/harmlos/www/:$PATH"export PATH
# Header:
cgiutils -expires now -ct text/html
#Body:
echo "<HTML>"
echo "<HEAD>"
title="DATENBANKTEST"
echo "<TITLE>${title}</TITLE>"
echo "</HEAD>"
echo "<BODY>"
echo "<H1> Test einer Informix <---> WWW- Schnittstelle </H1>"
echo "<br>"
echo "<pre>"
dbaccess harmlos probe.sql
echo "</pre>"
echo "<br></BODY>"
echo "</HTML>"
here comes probe.sql:
select * from gaeste
if I connect to the www-server with http://cha01:8080/CGI/probscr the server
returns with the following value:
802: Cannot open file for run.
and if I start the script manually it works:
$ probscr
Content-Type: text/html
Expires: Monday, 16-Jan-95 16:05:17 GMT
<HTML>
<HEAD>
<TITLE>DATENBANKTEST</TITLE>
</HEAD>
<BODY>
<H1> Test einer Informix <---> WWW- Schnittstelle </H1>
<br>
<pre>
datum lfdnr nachname vorname
10.01.1995 5 Schmidt Helmut
10.01.1995 6 Kohl Helmut
10.01.1995 7 Herzog Roman
10.01.1995 8 Weizsaecker, von Richard
10.01.1995 1 Adenauer Konrad
10.01.1995 2 Erhard Ludwig
10.01.1995 3 Kiesinger Georg
10.01.1995 4 Brandt Willi
8 row(s) retrieved.
</pre>
<br></BODY>
</HTML>
Can anybody of you help me ?
Thank you,
Olaf
--
______________________________________________________________________
| O L A F M E N Z E L < menzel@tfh-berlin.de > |
|______________________________________________________________________|
| Student of computer science | Technische Fachhochschule Berlin |
| christian students group "Quelle des Lebens e.V." |
|______________________________________________________________________|
|Petersburger-Str. 31 | D-10249 Berlin | GERMANY | Tel: +49 30 4296240 |
|______________________________________________________________________|
|"Where the Spirit of the Lord is,there is liberty." Bible: 2.Cor. 3:17|
|______________________________________________________________________|