RE: NT web server access to AS400

I tried ....

This is what I got:

Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]CEE9901 - Application
error. *N unmonitored by *N at statement *N, instruction X'4000'.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (22:1) to (22:30). 


Date/Time: 06/16/00 11:25:22
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
Remote Address: 209.101.248.132
HTTP Referer: http://www.imrail.com/CFDOCS/CFPROGS/KSRequest.cfm
Template:
C:\InetPub\wwwroot\WashCorp\Rail_grp\IMRL\CFDOCS\CFPROGS\KSresponse.cfm
 
Kenneth

****************************************
Kenneth E. Graap
IBM Certified Specialist
AS/400 Professional
Network Administrator
NW Natural (Gas Services)
keg@nwnatural.com
Phone: 503-226-4211 x5537
FAX:    603-849-0591
****************************************





-----Original Message-----
From: Scott Mildenberger [mailto:Smildenber@Washcorp.com]
Sent: Friday, June 16, 2000 10:06 AM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: NT web server access to AS400


We use ODBC directly and for the best performance have adopted the following
approach (these are all inquiry only accesses).  When a web user does an
inquiry, the application uses ODBC to write a single record to a file
detailing the inquiry.  This file has fields for the inquiry input as well
as the output to be presented to the user.  The file has a trigger program
that updates the record (before it actually hits the DB) with the output
information for the inquiry.  As soon as the web application has written
it's inquiry record it immediately rereads the record (each record has to
have some unique key - we use a randomly generated number) which will now
contain the response to the inquiry.  This moves almost all processing onto
the 400, prior to this we were having difficulty creating good logicals to
match the SQL coming through ODBC from the web app.  If you want to try one
of our sites go to 

http://www.imrail.com/CFDOCS/CFPROGS/KSRequest.cfm and use IMRL for Car
Initial and 50012 for Car Number.

Let me know if you want more details.  Of course, if I had total control of
the environment I would put a 400 on the internet and use e-RPG (RPG CGI
programs).

Scott Mildenberger

> -----Original Message-----
> From: larry@paque.net [SMTP:larry@paque.net]
> Sent: Friday, June 16, 2000 10:42 AM
> To:   midrange-l@midrange.com
> 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
+---