Unable to find the requested .Net Framework Data Provider. It may not be installed.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
mkvidyashankar
Posts: 1
Joined: Thu 07 Jun 2018 03:00

Unable to find the requested .Net Framework Data Provider. It may not be installed.

Post by mkvidyashankar » Thu 07 Jun 2018 03:06

I am using Visual studio 2017, istalled dontconnect for postgres, it is working on local computer but in server it is giving error
Unable to find the requested .Net Framework Data Provider. It may not be installed.
my web.config file

Code: Select all

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
	<connectionStrings>
  <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
   providerName="System.Data.SqlClient" />
  <add name="krrdaConnectionString" connectionString="User Id=postgres;Password=krrda@2011;Host=89.238.162.147;Database=krrda;Persist Security Info=True"
   providerName="Devart.Data.PostgreSql" />
  <add name="drrpConnectionString" connectionString="User Id=postgres;Password=krrda@2011;Host=89.238.162.147;Database=drrp;Persist Security Info=True;Initial Schema=public"
   providerName="Devart.Data.PostgreSql" />
 </connectionStrings>
 
	<system.web>
    <identity impersonate="false" />
		<compilation debug="true" strict="false" explicit="true" targetFramework="4.0">
			<assemblies>
				<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
				<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies></compilation>
		<authentication mode="Forms">
			<forms loginUrl="~/Account/Login.aspx" timeout="2880"/>
		</authentication>
		<membership>
			<providers>
				<clear/>
				<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/"/>
			</providers>
		</membership>
		<profile>
			<providers>
				<clear/>
				<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/"/>
			</providers>
		</profile>
		<roleManager enabled="false">
			<providers>
				<clear/>
				<add name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ApplicationServices" applicationName="/"/>
				<add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/"/>
        <add name="dotConnect for PostgreSQL" invariant="Devart.Data.PostgreSql" description="Devart dotConnect for PostgreSQL" type="Devart.Data.PostgreSql.PgSqlProviderFactory, Devart.Data.PostgreSql, Version= 7.5.644.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
      
      </providers>
      
      
		</roleManager>
	</system.web>
	<system.webServer>
		<modules runAllManagedModulesForAllRequests="true"/>
	</system.webServer>
</configuration>

please help to get out of this error

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Unable to find the requested .Net Framework Data Provider. It may not be installed.

Post by Pinturiccio » Thu 07 Jun 2018 15:58

Have you installed dotConnect for PostgreSQL on the server with "ASP.NET Providers" settings? When you install dotConnect for PostgreSQL with "ASP.NET Providers" settings on a computer, the corresponding records are automatically added to the machine.config. If there are no such records in the config file of the application, they are taken from the machine.config. But there are no such records in machine.config on the deployment server.

You can find the records that you need to add to the config file of the application in our documentation:
https://www.devart.com/dotconnect/postg ... cific.html

Post Reply