Internal error (unable to find .NET framework data provider) RSS

• • Reply
  

  jokul

  0 Points

  7 Posts

  Internal error (unable to find .NET framework data provider)

  Jun 28, 2012 11:07 PM|LINK

  I'm using ASP.NET with webmatrix and Razor (C#) but my website does not display.  i'm currently being hosted at godaddy and my server has IIS 7 and ASP.NET 4.0 installed.

  in particular, the error seems to come up when i attempt to initiate a connection.  after enabling detailed error reports in the web.config, it appears the server is unable to detect the proper .NET data:

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

  additionally, the offending line (in _AppStart.cshtml):

  Line 1:  @{
  Line 2:      WebSecurity.InitializeDatabaseConnection("Users", "UserProfile", "UserId", "Email", true);

  
  
  

  i can confirm that the "Users.sdf" SQL Compact databse is in my App_Data folder on the FTP.  additionally, i have enabled .cshtml as a MIME type in web.config:

  <?xml version="1.0" encoding="UTF-8"?>
  <configuration>
  
  
      <system.web>
          <customErrors mode="Off"/>
          <compilation debug="true"/>
      </system.web>
      
      <connectionStrings />
      
      <system.data>
          <DbProviderFactories>
              <remove invariant="System.Data.SqlServerCe.4.0" />
                  <add invariant="System.Data.SqlServerCe.4.0" name="Microsoft® SQL Server® Compact 4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
          </DbProviderFactories>
      </system.data>
      
      <system.webServer>    
          <modules runAllManagedModulesForAllRequests="true"/>
          
          <staticContent>
              <remove fileExtension=".cshtml" />
              <mimeMap fileExtension=".cshtml" mimeType="application/cshtml" />
          </staticContent>
          
          <httpErrors errorMode="Detailed" />
          <asp scriptErrorSentToBrowser="true" />
      </system.webServer>
  
      
      
  </configuration>
  
  
  

  i have done the actions described in this topic regarding changes to the web.config file and enabling the App_Data folder for read/write. i believe the issue is that i used WebMatrix FTP protocol to upload to the site instead of a web deploy (so the .DLLs may not be included), but when i attempt to use web deploy protocol, my connection times out. here i am trying to use web deploy:

  

  i'm not sure if site name is important, but all the same information works just fine when uploading using FTP protocol.

  not sure where i'm going wrong

• • Reply
  

  cornball76

  Participant

  1128 Points

  211 Posts

  Re: Internal error (unable to find .NET framework data provider)

  Jun 28, 2012 11:25 PM|LINK

  I don't have any experience but looking around these 2 links may help you.

  http://www.bartlannoeye.be/blog/deploying-your-site-with-sql-ce-4.0-to-shared-webhosting-part-2

  http://stackoverflow.com/questions/4762857/using-sql-server-ce-4-on-a-remote-host-with-mvc-3

  I learn by helping others. I may not always be correct but my intentions are good. If my answer helps please mark it as so.
• • Reply
  

  Mikesdotnett...

  All-Star

  155645 Points

  19985 Posts

  Moderator

  MVP

  Re: Internal error (unable to find .NET framework data provider)

  Jun 29, 2012 05:06 AM|LINK

  Find System.Data.SqlServerCe.dll on your machine* and add a copy of it to the bin folder in your web site root, then upload that.

  *C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Desktop on my machine

  Regards, Mike
  Web Pages CMS | My Site | Twitter
• • Reply
  

  jokul

  0 Points

  7 Posts

  Re: Internal error (unable to find .NET framework data provider)

  Jun 29, 2012 07:02 AM|LINK

  still have the same problem :(

  list of all .dlls i have:

  Microsoft.Web.Infrastructure.dll

  NuGet.Core.dll

  System.Data.SqlServerCe.dll

  System.Web.Helpers.dll

  System.Web.Razor.dll

  System.Web.WebPages.Administration.dll

  System.Web.WebPages.Deployment.dll

  System.Web.WebPages.dll

  System.Web.WebPages.Razor.dll

  WebMatrix.Data.dll

  WebMatrix.WebData.dll

• • Reply
  

  Mikesdotnett...

  All-Star

  155645 Points

  19985 Posts

  Moderator

  MVP

  Re: Internal error (unable to find .NET framework data provider)

  Jun 29, 2012 07:32 AM|LINK

  Try removing the System.Data node from your web.config altogether.

  Regards, Mike
  Web Pages CMS | My Site | Twitter
• • Reply
  

  jokul

  0 Points

  7 Posts

  Re: Internal error (unable to find .NET framework data provider)

  Jun 29, 2012 07:35 AM|LINK

  still the same error, i had actually tried this one earlier though.

• • Reply
  

  mebinici

  Participant

  829 Points

  258 Posts

  Re: Internal error (unable to find .NET framework data provider)

  Jul 03, 2012 03:28 PM|LINK

  I believe I had a similar issue when I had a shared/virtual hosting server with GoDaddy.

  The simple solution was to contact GoDaddy and they did something on their end (install or upload the .dll references or perhaps tweak the security settings on the server?).

  Worth a shot...

  Check out my website: http://www.TheTradeBox.com
  Love collecting video games, movies and board games!
  Enjoying my '11 WRX, so sexy...
  • Marked as answer by Dino He - MSFT on Jul 06, 2012 05:53 AM
• • Reply
  

  jokul

  0 Points

  7 Posts

  Re: Internal error (unable to find .NET framework data provider)

  Jul 09, 2012 10:31 PM|LINK

  i've been gone for some time but godaddy assures me this is not an issue with their hosting but rather something else i've forgotten, not sure what else there is though at this point.