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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB6/CR7/ODBCDirect to AS400. How to code the connection?
- Thread starter PaulaJ
- Start date
Paula,<br><br>Try the "Visual Basic (Microsoft) Databases" forum.<br><br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href= Cargill's Corporate Web Site</a><br>
- Status
Similar threads
- Locked
- Question
