.netdatabase-connectionconnection-stringibm-midrangeoledbconnection

ibmda 400.1 provider is not registered in local machhine


I am trying to connect to AS400 database from c#.net. Am getting this exception "ibmda400.1 provider is not registered in local machhine", How to resolve this ?

This is my connection string and am connecting using OLEDB

<add name="StudentConn" connectionString="Provider=IBMDA400.1;User ID=****;Password=*****;Data Source=****;Default Collection=*****;"/>

Solution

  • You need to have a client package installed to have the driver available.

    updated as of 2022-01-26
    The ACS Application Packages (Windows/Linux/PASE/Mac) are downloadable from the same IBM page as the base ACS. You don't need to get them through ESS, though you still need an IBM login ID. enter image description here