How to use IBM client Access OLEDB provider

This article describes about the IBM Client Access OLEDB Provider.
  • 1719

OLEDB Provider

Connection string which is used for IBM Client Access OLEDB provider is

Provider=IBMDA400;Data Source=system_name;User Id;user_name;Password=password;

In standard connection string the Data Source name used is the name given to the system connection in OperationsNavigator.

Connection string used for specifying collection in IBM Client Access OLEDB Provider is

Provider=IBMDA400;Data Source=system_name;User Id=user_name;Password=password;Default Collection=library_name;

In the above connection string the Data Source name used is the name given to the system connection and the name used in collection field is the name given to the library in iseries Navigator.

Ask Your Question

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.