Specifying cellection using IBMDA400

Connection string

This IBM Client Access OLE DB provider connection string can be used for connections to AS/400.

Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;
Password
=myPassword;
Default Collection=MY_LIBRARY;

Where MY_SYSTEM_NAME is the name given to the System Connection, and MY_LIBRARY is the name given to the library in iSeries Navigator.