Re: Database connectivity - web based

shane,

you can write an agent in lotus script and use lotus script extensions to 
run SQL to access your as400 database, call an as400 program via a stored 
procedure (as long as you only want to pass parameters in, you can't have 
any parameters returned), or run the stored procedure on the as400 which 
contains sql statements and returns a result set (i haven't tried that one 
yet though).

invoke the agent through web your web query save or web query open events 
which fire when the form opens or closes.

i've done lots of the above (as well as a few java servlets which are 
invoked via javascript commands).

we use domino's http server and are not having any performance problems, but 
i'm not an expert in this area by any means.  maybe your network has a 
problem???

hope this helps.

if you would like some examples let me know.

sandy wenig
tazadog@hotmail.com

>From: "Shane D. Rowe" <srowe@hici.net>
>Reply-To: DOMINO400@midrange.com
>To: <DOMINO400@midrange.com>
>Subject: Database connectivity - web based
>Date: Fri, 12 May 2000 08:52:42 -0500
>
>This question is similar to one posted earlier about DECS.  I have similar
>needs in being able to connect to an AS/400 database.  But the interface I
>will be using is web-based using Domino's HTTP server.  I've created some
>sample pages, but am now stuck as to how to get to my backend databases to
>pull information.  One person mentioned using lotus script.  It is my
>understanding that lotus script does not work on the web side.  Therefore,
>how do I connect to my backend database so web browsers can see my data?
>
>Also, are any of you using the Domino HTTP server as your primary web
>server?  If so, how did you speed up its serving abilities?  When I hit my
>server from a web browser, it connects and then waits several seconds 
>before
>the page is ever served.  Can I speed up this process?
>
>Any suggestions or ideas would be greatly appreciated as I am new to 
>Domino.
>
>Have a great day,
>Shane D. Rowe
>
>+---
>| This is the Domino/400 Mailing List!
>| To submit a new message, send your mail to DOMINO400@midrange.com.
>| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
>| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: meechamw@ptd.net
>+---

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

+---
| This is the Domino/400 Mailing List!
| To submit a new message, send your mail to DOMINO400@midrange.com.
| To subscribe to this list send email to DOMINO400-SUB@midrange.com.
| To unsubscribe from this list send email to DOMINO400-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: meechamw@ptd.net
+---