|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.