RE: access as/400 database files w/Visual Basic 6

Frank,

Get a "in 21 days" book for VB that includes database access (probably
something called ADO or Active Data Objects.) Learn this with Access or MSDE
as the backend database. Once you understand data access from VB to a
database you can change the ODBC driver for Access for the one for the
iSeries and you'll have a good start.

As for Joe's comments on cross-file relationships. I would look strongly at
using "stored procedures" to do the updates. These SPs can be RPG (or Cobol)
programs on the iSeries. Of course, if you're willing to understand the
cross-file relationships then you can issue updates from VB as well.

But, first things first, learn VB data access against a local database, then
worry about the iSeries, it's not really any different.

-Walden


------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)



-----Original Message-----
From: Frank W. Kany IV [mailto:frank.kany@burr-reid.org]
Sent: Friday, August 09, 2002 14:19
To: midrange-l@midrange.com
Subject: access as/400 database files w/Visual Basic 6


This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I would like to LEARN how I can have my VB6 applications connect to our
AS/400 and access data to use in my VB6 applications.  I am a beginner at
VB6.  I'm just going to write simple VB6 applications to update/delete/write
records to an AS/400 database file.

Does anyone have any kind of pdf documents or websites that would point me
in the right direction?

TIA,

Frank W. Kany IV
The Law Offices of Burr & Reid
www.burr-reid.org
--


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.