Re: NT web server access to AS400 -- MIDRANGE-L


We beat 'em all.

Our NT Web Server solutions are sub-second in terms of response times.
We've used a program to program approach to do this. This technique may not
be for everyone, but if you have access to the AS/400 application code the
modifications are fairly easy to do. Check out
http://www.cm-inc.com/whatsnew/usingiis.htm

We also have been using CA/400 for the interface. We've gotten DataQs and
Spoolfiles delivered to the Web. Check out
http://www.cm-inc.com/AS400ole/


Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/



                                                                                
                   
                    Rob Berendt                                                 
                   
                    <rob@dekko.com>            To:     MIDRANGE-L@midrange.com, 
                   
                    Sent by:                   Domino400@midrange.com           
                   
                    owner-midrange-l@mi        cc:                              
                   
                    drange.com                 Subject:     Re: NT web server 
access to AS400      
                                                                                
                   
                                                                                
                   
                    06/26/00 08:18 AM                                           
                   
                    Please respond to                                           
                   
                    MIDRANGE-L                                                  
                   
                                                                                
                   
                                                                                
                   



We have a process in which someone in a Notes database clicks on a button.
The process then
1)  Calls an AS/400 BPCS bill of material print program (BOM240) and
converts the spool file into a disk file.
2)  Uses ODBC calls to bring the data into Notes
3)  Deletes the work file with DROP TABLE
Notes and the ERP run on the same 400.
Takes 7 seconds.  Not too bad.




larry@paque.net on 06/16/2000 12:00:37 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:        midrange-l@midrange.com@Internet
cc:
Fax to:
Subject:        NT web server access to AS400

We are using Net.Data on an NT IIS server to access data on our AS/400
through ODBC.  We do stored procedure calls and database reads.  The
performance is less than adequate (15-30 seconds) even when using live
connect manager.

Some of you must be using NT web servers and getting data from your AS400.
How are you getting decent response times?

Thanks for any ideas,
Larry Paque
larry@paque.net


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---