IBM Client Access OLE DB provider connection strings

Connects to


  • Standard

    Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;

    Where MY_SYSTEM_NAME is the name given to the system connection in OperationsNavigator

  • Specifying cellection

    Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;
    =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.

Problems connecting?
Get answer in the AS/400 Q & A forum
OLE DB ProviderProvider=IBMDA400Info and provider downloads



Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.