Re: Data queue to web app

[Patrick Townsend <townsend@xxxxxxxxxxxxxx>]

Wayne,

I can't answer the questions about ADO, but check the Max frame size on
your AS/400's ethernet line description. You might need to increase it
to handle larger buffers of data without breaking up the TCP frame.

Patrick

Wayne Capwell wrote:
> 
> Hello,
> We have modified a group of RPG programs to use data queues instead of
> display files to communicate with an internet connected browser. We
> created physical files that emulate the display file formats and send
> and receive the data queues in the RPG programs instead of reading and
> writing the display file formats.  We create the data queues on the
> AS/400 with a length of 2000 characters.
> 
> On the web server side, we created a dll using Visual Basic 6.0 and
> Microsoft ADO objects to receive the data queue information and present
> it to our server application.  The web application parses the data queue
> string into the browser pages.  We also have prefined character strings
> that emulate the function keys, etc. that sends data back to the
> AS/400,  so the RPG program can complete the read data queue function
> and continue with its normal processing.
> 
> All works well when we send less than 680 characters of data. However,
> when the RPG program sends more than 680, the VB dll get an "Automation
> Error" and ceases processing.  We have tried several iterations of the
> VB with the same results.  We know the data queue contains all the
> information on the AS/400 side.
> 
> If anyone knows of this problem or even knows of a resource in IBM or
> Microsoft that can help, I would greatly appreciate the help.
> Here are our questions:
> 
> 1) What version of ADO is recommended? The app currently uses Microsoft
> OLE DB ADO Library 1.0.  All other versions of ADO we try crashes. Are
> all versions of ADO supported?
> 
> 2) Why can we send 2000 characters to the data queue, but only receive
> approx. 680 characters? This causes an "Automation Error".  Why?
> 
> 3). Could they provide code samples of using ADO to communicate with
> AS400 data queues. We used samples from IBM's web site to develop what
> we are using now. Any examples in particular of moving large record sets
> to and from data queues. All samples from IBM's web site sends and
> receives
>  small amounts of data.
> 
> TIA
> 
> Wayne
> --
> ______________________________________
> Wayne W. Capwell
> Red Oak Technologies, Inc.
> 11301 Carmel Commons Blvd., Suite 114
> Charlotte, NC  28226
> 704-945-1067
> 
> Manufacturing...Production...Solutions
>      http://www.redoaktech.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
> +---

-- 
IBM AS/400 communications, FTP automation, and network security
software and consulting services.

http://www.patownsend.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
+---