Re: AS/400 OLE DB support (project ligthning)

["Roger Pence" <rp@xxxxxxxxxxxxxx>]

Denis--

>When the module get activated, i get an error stating that the
ADODB.Connection object type is not a valid >type. I have installed the SDK
but no luck. I think that something must be missing or not configured
corretly on >my pc (win95).

You need to tell MS Access the location of some Lightning and MS OLE DB
libraries. This is done using the Tools|References menu option (shown at the
bottom of page 4). This menu option is only enabled when the VB editor is
opened in Access. You’ll need to select the three choices shown below:

 1. AS/400 Express Toolkit Table Index Type Library 1.2 (CWBZZIDX.DLL)
 2. Express Toolkit ActiveX and OLE DB Add-Ins (CWBZZVBA.DLL)
 3. Microsoft OLE DB ActiveX Data Objects 1.0 Library (MSADO10.DLL).
A similar step is necessary when using Lightning with Word or Excel.

rp


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