[AccessD] Connection to AS400?

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