We are using c# .netFramework 4.5.1. MSOLEDBSQL is already installed.
Our data access lib. is using following statement.
var m_DbProviderFactory = DbProviderFactories.GetFactory("MSOLEDBSQL"); is giving error Error "Unable to find the requested .Net Framework Data Provider. It may not be installed."
Application was using System.Data.SqlClient. But we have to change it to use MSOLEDBSQL. MSOLEDB sql driver is installed and regedit entry is ok.
What should be entry in config or machine.config for DbProviderFactories for MSOLEDBSQL? I could not find example for MSOLEDBSQL
<system.data>
</DbProviderFactories>
</system.data>
Note that following works OK with correct connection string with provider as MSOLEDBSQL
m_oConn = new OleDbConnection(m_strConnectionString); So it is not installation issue. Issue is only with DbProviderFactories