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

How much easier is it to develop and maintain a web based application over a
VB application?  It really doesn't matter to me which direction I go.  But
I'd definately agree with you and not have to deal with problems like
"Driver level 1.2.33 not compatible with DLL 2.1.22 while running under
build 34.1.1".  Do you have some information on where I can learn more about
invoking RPG programs and Database access through the web?

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 3:31 PM
Subject: RE: access as/400 database files w/Visual Basic 6


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