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

>From: Frank W. Kany IV [mailto:frank.kany@burr-reid.org]
>use VB as a front end to my RPG applications

Why VB instead of a web app? Leaving the arguments of ASP vs. JSP vs.
Relationan Web, etc. alone, no matter which of our methods you select they
are all "thin client" web browser based. Are you really doing anything on
the client that requires a fat client?

Unless you absolutely need a fat client I'd always look at the web-based
solution today. Multi machine VB support issues are a mess, especially if
you aren't familiar with VB. Wouldn't you rather spend your time solving a
problem like "We need to send e-mails to our clients" that a problem like
"Driver level 1.2.33 not compatible with DLL 2.1.22 while running under
build 34.1.1"

-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 15:10
To: midrange-l@midrange.com
Subject: Re: access as/400 database files w/Visual Basic 6


Thanks for all your help.  The reason why I want to learn how to access
AS/400 database files is becuase I'm trying to learn how to use VB as a
front end to my RPG applications.  I don't know how it all works and I want
to learn.

Frank W. Kany IV
The Law Offices of Burr & Reid
www.burr-reid.org
----- Original Message -----
From: "Walden H. Leverich" <WaldenL@TechSoftInc.com>
To: <midrange-l@midrange.com>
Sent: Friday, August 09, 2002 2:53 PM
Subject: 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.
> _______________________________________________
> 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.
>


_______________________________________________
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.