Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 29, 2011 08:18 PM by GrandpaB
Jul 28, 2011 02:43 PM|LINK
I'm attempting to develop a small website project using VWD 2010 Express with a SQL Server CE 4.0 database. To check out ability to publish the website, I've created a simple one page project with a one table database. The page contains a Gridview and
DataSource; it was easy to build and works on my development system without error.
Publishing it is another story! I have been working on publishing it at my host provider for about a month. I have an open thread on the SQL Server Compact forum, but despite the suggestions I have received I cannot successfully publish it. There have
been many variations; this is the current status of the project.
After building the project the bin folder contains the following files.
To the project's bin folder I have added the System.Data.SqlServerCe.dll file and two folders, amd64 and x86. Each one of these folders contain the following files.
Both the amd64 and x86 folder also contain a folder, Microsoft.VC90.CRT. Both the VC90.CRT folders contain the following files.
After publishing the project I check the files and structure of the bin folder on the host server. It is identical to bin folder on my development system, except that the VC90.CRT folders on the host server do not contain the Microsoft.VC90.CRT.manifest
The web.config is shown below.
<add name="csToys" connectionString="Data Source=|DataDirectory|\Toys.sdf"
<compilation debug="true" strict="false" explicit="true" targetFramework="4.0" />
<customErrors mode="Off" />
<add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0"
description=".NET Framework Data Provider for Microsoft SQL Server Compact"
Version=220.127.116.11, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
With the project configured as shown above I get the following error whenever I attempt to open the project on host server. Any suggestions would be greatly appreciated.
Server Error in '/' Application.
The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail. (Exception from HRESULT: 0x800736B1)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail. (Exception from HRESULT: 0x800736B1)
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[COMException (0x800736b1): The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail. (Exception from HRESULT: 0x800736B1)]
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) +0
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode) +49
System.Data.SqlServerCe.UnmanagedLibraryHelper..ctor(String fileName) +76
System.Data.SqlServerCe.NativeMethodsHelper..ctor(String modulePath) +27
System.Data.SqlServerCe.NativeMethods.LoadValidLibrary(String modulePath) +281
System.Data.SqlServerCe.NativeMethods.LoadNativeBinariesFromPrivateFolder(String privateInstall) +76
System.Web.UI.WebControls.SqlDataSource.CreateConnection(String connectionString) +21
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +117
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Jul 29, 2011 08:18 PM|LINK
I originally began developing the website using VWD 2010 Express with a SQL Server CE database. The design was well along when I signed up with GoDaddy on June 20. There has been a 5 week effort to get that working. GoDaddy's response was limited to "you
have a scripting error." I published simple "Hello World" sites both with and without a database. If a database was included I got an error when the page was served from GoDaddy. In the past 2 days I developed simple WebMatrix websites with and without
databases. The non-database sites would work if I entered mySite.com/default.cshtml; the database sites would crash! Without WebMatrix support GoDaddy does not recognize the .cshtml or .vbhtml extensions.
Bottom line - GoDaddy does not support SQL Server CE 4.0 or WebMatrix! I hope my experiences save someone else from the frustration that I experienced.