Re: IBM's AS/400 toolbox for JAVA

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

Luther--

>Please note, the ADO drivers, however, are still in Beta, and ONLY ship
with
>CA Express beta.

What do you mean the ADO drivers? ADO is the programming layer over OLE DB.
ADO is an interface over OLE DB like RDO is an interface over ODBC. ADO,
like RDO, doesn't physically send or receive data, rather it manipulates
data provided by the underlying OLE DB provider. ADO is simply an OLE DB
consumer, not a database access "driver."

You can write code to the OLE DB interface directly, but doing so requires
using an excrutiating set of APIs. The object-based layer that ADO presents
is generally a much better way to access data with OLE DB (though not every
feature of OLE DB is surfaced through all ADO interfaces).

The AS/400's OLE DB support is two pieces:

1. OLE DB data provider
This is the data provider, programmable with the ADO interface. This
component ships GA with V3R1M3, V3R2M0 and the Express beta (note, however,
except for Express's ADO 2.0 compatibility, there is no difference between
the Express version and the previous OLE DB providers). While Express's OLE
DB provider works with ADO 2.0, it provides no ADO 2.0 features (such as
support for new ADO 2.0 properties, connection state for example). V3R1M3
and V3R2M0's OLE DB data provider only works with ADO 1.0.

2. OLE DB SDK
This component  provides wizards, docs and examples. V3R2M0 and Express
include the SDK, however V3R1M3 does not. V3R1M3 users can download the SDK
http://www.as400.ibm.com/clientaccess/oledb/betainfo.htm. Although this SDK
is labeled a preview version, it is the same SDK that ships with V3R2M0. The
Express SDK works with VB 6.0, but the V3R2M0/V3R1M3 SDK only works with VB
5.


rp




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---