AS400, Crystal & VB Questions?

[PaulaJ]

Im trying to use DAO in VB6.  I want to retrieve a selected recordset via SQL from the AS400 and then run a Crystal report over this recordset.  Do I create a Workspace and Do an OpenConnection in the VB or does the Crystal.Connect do this for me?  We have extremely large files and the Crystal just doesn't like going against them directly for a select.  I'm trying to decrease the number of records that Crystal has to deal with.  I also am trying to get to a completely automated report setup that I can give to my users.  Any Ideas?

 

[listener22]

&nbsp;&nbsp;&nbsp;Nothing will run faster than an SQL script report<br>that runs directly on the AS400, if you have the tools<br>to do so. <p>Jim Carlson<br><a href=mailto:nx56@inetarena.com>nx56@inetarena.com</a><br><a href= > </a><br>oracle, vb, some javascript

 

[PaulaJ]

Do you have any suggestions for applicable tools?

 

[listener22]

I don't have any experience with them, but<br>there's an SQLTool&nbsp;&nbsp;(<A HREF="

http://www.sqltool.com"

TARGET="_new">

http://www.sqltool.com</A>),<br>an

SQLLite (<A HREF="

http://www.rpgiv.com/SQLLite.html"

TARGET="_new">

http://www.rpgiv.com/SQLLite.html</A>),<br>and

there's an AS400, including SQL, tip listing<br>at <A HREF="

http://207.158.252.83/bo400ng/as400sqlstrnum.htm"

TARGET="_new">

http://207.158.252.83/bo400ng/as400sqlstrnum.htm</A>.<br><br>I

hope that this will help.&nbsp;&nbsp;My background is not AS400,<br>but Oracle PL/SQL and SQL*Plus.&nbsp;&nbsp;We have several<br>hundred reports written in SQL that run directly on our<br>server.&nbsp;&nbsp;People have a PC - interface, so the sql scripts<br>are called in an interactive telnet session.&nbsp;&nbsp; <p>Jim Carlson<br><a href=mailto:nx56@inetarena.com>nx56@inetarena.com</a><br><a href= > </a><br>oracle, vb, some javascript

 

[Knight]

IBM has an ADO provider for the AS400.