Re: IBM's AS/400 toolbox for JAVA

Roger,

Thanks for your explanation! I was under the false understanding there were
separate "ADO" drivers as well. I have CA V3R2M0 and have searched the
documentation multiple times for any info on using ADO never found any .. so
I assumed the OLD DB stuff was something lower level. And then someone on
the as400 newsgroups mentioned ADO 2.0 support in CA Express, so I got it
all mixed up.

Does that mean it is not possible to use the OLE DB stuff from CA V3R2M0
with ADO 2.0? And to use it with ADO 1.1, howdo you specify the ADO drivers
in the connection string? We have started using ADO 2.0 to access our
AS/400's data but so far just with ODBC data sources we have created.

Thanks,

Luther

LAM_SoftTel@usa.net -- http://www.lanandam.com
-----Original Message-----
From: Roger Pence <rp@rogerpence.com>
To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
Date: Thursday, 25 March 1999 15:05
Subject: Re: IBM's AS/400 toolbox for JAVA


>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
>+---

+---
| 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
+---