RE: ODBC to AS/400 using Visual Basic 4.0

In ADO the connection object equates to a job on the iSeries, so if you open
your connection and then execute the OVRDBF on the same connection as the
query you'll be fine -- remember to close your connections when you're done.
Oh, and explicitly create your connections, don't let the record set do it
for you, in the long run it's MUCH easier that way.

I don't remember who started the thread, but if you're going to stick with
VB4 at least upgrade to ADO, it's free. RDO is a hack through the Jet
engine, which is also a hack, so you'll be in deep Kimchee (sp?) if you stay
with RDO.

JMTCW.

-Walden

-----Original Message-----
From: Vernon Hamberg
To: midrange-l@midrange.com
Sent: 9/13/2002 11:01 PM
Subject: RE: ODBC to AS/400 using Visual Basic 4.0

Don

You might try a direct call to the OVRDBF command in the connection - if
it'll use the same job, of which I'm not sure. Do this early in the
process.

Vern

At 11:36 AM 9/13/02 -0400, you wrote:
><another sigh>
>Unfortunately, V4R1 does not support the ALIAS keyword.
>
>Donald R. Fisher, III

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