[AccessD] Connection to AS400?

Have used not this in a couple of years but there are two OLEDB 
providers one from MS and one from IBM
This site lists a lot of valid connection strings.
For IBM you will have to read their "Red Books"
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForAS400FromIBM

Dan Waters wrote:

>I am trying to connect from AXP to and AS400 MRP system using OLEDB, and I
>am trying to confirm what the connection string should be.
>
> 
>
>I believe this is correct:
>
> 
>
>stgOLEDBProviderName = "IBMDA400"    
>
>stgDataSource = "AS400"
>
>stgUserID = "UserID"  '-Some UserID
>
>stgUserPassword = "UserPassword"  '-Some User Password
>
> 
>
>cnn.Open "Provider=" & stgOLEDBProviderName & ";Data Source=" &
>stgDataSource & ";", stgUserID, stgUserPassword
>
> 
>
> 
>
>Also, are there any 'switches' that need to be set on the MRP side to allow
>the use of OLEDB technology?
>
> 
>
>Thanks!
>
>Dan
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada