实现ASP.NET / SQL Compact 4.0到Windows Server 2012的问题 [英] Implementing ASP.NET / SQL Compact 4.0 to Windows Server 2012 problem

问题描述

嗨伙计



我昨天在服务器讨论区问过这个问题，但我没有进一步前进。希望在这里取得更大的成功。



我目前使用SQL Compact 4.0的私有部署在Windows Server 2008上成功运行.NET 4.0网站。数据库dll驻留在应用程序的bin文件夹中。



我正在迁移到一家新的网络托管公司，我想在Windows 2012上进行测试，最终是为了转向。 NET 4.5及更高版本的SQL Server。我正在使用一个全新的服务器安装。



我的出发点是移动我的所有网站文件夹，包括测试数据库和SQLCE dll并测试网站 - 现有文件夹和内容的直接副本。



不幸的是，我第一次加载主页时收到以下错误消息。 无法找到所请求的.Net Framework数据提供程序。可能无法安装。



跟踪的第一部分说明：



[ArgumentException：无法找到请求的.Net Framework数据提供程序。它可能没有安装。]

System.Data.Common.DbProviderFactories.GetFactory（String providerInvariantName）+1480919

System.Data.EntityClient.EntityConnection.GetFactory（String providerString ）+26



[ArgumentException：在配置中找不到指定的商店提供商，或者无效。]

System.Data .EntityClient.EntityConnection.GetFactory（String providerString）+91

System.Data.EntityClient.EntityConnection.ChangeConnectionString（String newConnectionString）+246

System.Data.EntityClient.EntityConnection ..ctor（String connectionString）+43

System.Data.Objects.ObjectContext.CreateEntityConnection（String connectionString）+85



etc



我还在学习.NET和服务器环境，所以请善待。我今天也研究了答案，但它似乎提出的问题多于我的答案。



这个链接似乎并不表示我做错了什么私有部署SQL Compact，虽然显然有些不对。



鉴于我的设置和显示的错误是否有最好的位置来查看/检查？



有什么想法吗？



干杯



Paul ...

Hi Folks

I asked this question in the server discussion area yesterday but I'm no further forward. Hoping for more success here.

I currently have a .NET 4.0 website successfully running on Windows Server 2008 using a private deployment of SQL Compact 4.0. The database dlls reside in the application's bin folder.

I am moving to a new web host company and I want to test this on Windows 2012, ultimately with a view to moving to .NET 4.5 and, later, SQL Server. I am using a brand new server installation.

My starting point was to move across all of my website folders, including a test database and SQLCE dlls and test the site - a straight copy of the existing folders and contents.

Unfortunately I get the following error message when loading the home page for the first time. "Unable to find the requested .Net Framework Data Provider. It may not be installed. "

The first part of the trace states:

[ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.]
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +1480919
System.Data.EntityClient.EntityConnection.GetFactory(String providerString) +26

[ArgumentException: The specified store provider cannot be found in the configuration, or is not valid.]
System.Data.EntityClient.EntityConnection.GetFactory(String providerString) +91
System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) +246
System.Data.EntityClient.EntityConnection..ctor(String connectionString) +43
System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) +85

etc

I am still learning .NET and server environment so please be kind. I have researched for answers today also but it seems to raise more questions than answers for me.

This link doesn't seem to indicate I am doing anything wrong with my private deployment of SQL Compact, though clearly something isn't right.

Given my setup and the errors shown is there a best place to look/check first?

Any ideas?

Cheers

Paul ...

推荐答案

您的托管服务提供商是否在服务器上安装了SQL CE？如果没有，请访问 http://www.microsoft.com/en-us /download/details.aspx?id=17876 [ ^ ]您可以安装

Have your hosting provider install SQL CE on the server? If not, please kindly go to http://www.microsoft.com/en-us/download/details.aspx?id=17876[^] and you can install it

这篇关于实现ASP.NET / SQL Compact 4.0到Windows Server 2012的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！