AS/400 and Visual Basic

[Guest.Visitor]

Can anyone tell me what the preferred method is to access data from an AS/400 thru Visual Basic ? We would also like to be able to call COBOL and/or CL programs from within Visual Basic. We are at V3R2M0 and using VB Enterprise Edition. Any help would be appreciated ! Thanks Phil

[Guest.Visitor]

I would suggest using OLE DB. You can find more information on this in the red book: "A fast path to AS/400 client server using OLE DB support"

[David Abramowitz]

I recently attended a session (led by Roger Pence of the "other" magazine) on using OLE and ADO for record level access. This was formerly called <u>Project Lightning</u>. Without having detailed experience, it seems like a much better method than ODBC. CA/400 versions V3R2 and higher comes with a free SDK for developing applications using this method. Dave

[Guest.Visitor]

Dennis, I have been told that V3R2M0 does not support OLE DB. Is this true ? Thanks Phil

[David Abramowitz]

Phillip wrote: I have been told that V3R2M0 does not support OLE DB. Is this true ? No. Dave

[Guest.Visitor]

<blockquote><tt> I have been told that V3R2M0 does not support OLE DB. Is this true ? </tt></blockquote> I dont know. I have used it on a v4r3m0 machine and it works fine there.