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=*****;"/>
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.