RE: ODBC to AS/400 using Visual Basic 4.0

Yes, I believe I'm using RDO.  I create workspace, database, and record set
objects.  Then I assign the desired AS/400 file to the database object using
the OpenDatabase method of the workspace and open the file using the
OpenRecordset method of the database object.

Taking your advice, I attempted to open the file in Access and achieved
success, but only after changing the naming convention for the ODBC driver
to "SQL".  However, Access would not recognize the multiple members in the
file.  Perhaps that is a limitation of ODBC?

So I went back to my program and changed the code to use the SQL naming
conventions and now it works.  At least it will open the record set, but
only against the first member.  Is there no way to make it open a specific
member?

<long deep sigh>
Your other recommendations sound very reasonable, but I do not have Client
Access Express here as our primary production machine is on V4R1 and not
likely to be upgraded.  We do have a V4R5 box for our Lawson package,
though.  Would that help me?

I am also highly unlikely to convince my boss we need to invest in VB6 or
VB.net.  The only reason I've been allowed to work with VB 4.0 is because we
already had it.  At least it's the "Enterprise" version.

Thanks for your help.

Donald R. Fisher, III
Project Manager
The Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@roomstoreeast.com

<clip>
Can you connect using your DSN from another application like Access?  If so,
you're dealing with malformed syntax.  If not, your data source may be
configured incorrectly.

If I may make a recomendation:  Upgrade to VB.NET, or VB6 if you can find
it, get
the latest version of MDAC, and use activex data objects (ADO).  (I'm
assuming
you're on some version of Client Access Express, which comes with it's own
data
provider for ADO).  It's much easier, and you can treat any recordset
essentially the
same regardless of the RDBMS behind it (although there are minor differences
in
supported features from provider to provider).
<clip>