RE: Data queue to web app -- MIDRANGE-L

Wayne
        We too have this DataQ solution in place. We too have written an
ActiveX DataQ Object. Your use of the ADO although deviates from our
solution, we access our ActiveX objects directly without ADO. Our DataQ
has a max length of 5000 and we consistently send these long strings
without failures.

If you can't find a solution to the ADO issue and wish to get a copy of
our ActiveX Objects see http://www.cm-inc.com/AS400ole/ or email me
directly at ken@cm-inc.com

Ken Slaugh (707) 795-1512 Ext 118 
Programmer/System Analyst - Chouinard & Myhre, Inc. 
Certified Network Administrator MSE
Specialist - Client Access/400 

http://www.cm-inc.com/ 



-----Original Message-----
From: Wayne Capwell [mailto:wayne@redoaktech.com]
Sent: Wednesday, December 01, 1999 6:43 AM
To: midrange
Subject: Data queue to web app


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
+---
+---
| 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
+---