I've installed SQL Server Compact Edition 4.0 on Win7 x64 and it runs both for Asp.Net and Desktop Applications. This PC also have Visual Studio 2010 SP1 installed. But my Server 2008 R2 produces following error for Asp.Net applications, although it can run Desktop Applications: Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8482. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details. I've tried both with a SqlDataSource and SqlCeConnection. My web.config is like below: Also tried to copy dll's as sugested but no effect.
The updates for SQL Server Compact 3.5 SP2 are now referred to a CU (Cumulative Update), which is what the hotfixes also were previously. The difference now is. Note that SQL Server Compact 3.5 Server Tools cannot be installed side-by-side with earlier versions of Server Tools on the computer that is acting as the IIS server. SQL Server Compact 3.5 Server Tools can replicate data between SQL Server Compact 3.5 and SQL Server 2005 and later versions.
There are two ways to deploy SQL Server CE 4.0 in ASP.net. • Medium trust, or • private deployments. Your configuration file uses version 4.0.0.0 - this requires Medium Trust, and requires the App Pool user having permission to access the SQL Server Compact COM dlls in C: Program Files Microsoft SQL Server Compact Edition. Autodesk crack torrent. Where medium trust fails, you could attempt private deployment. This is my preference and there's less chance something will go wrong with your system sometime in the future. If you private deploy the SQL Server CE DLLs, by copying all the files in v4.0 Private to bin, make sure your Web.config declare a dependency on version 4.0.0.1.
This version is not deployed in the GAC and this will ensure your private copy gets loaded. You will also require a corresponding change in the DbProvider section in Web.config.