I created an ASP.NET website (not a web application) using Visual Studio 2012 Ultimate and the "SQL Server Compact 4.0 Local Database" in my C # code.
I can successfully compile and publish the website on another IIS web server with the Windows Server 2008 R2 Standard operating system. I can even check, successfully, this site on the machine in which I developed it.
I am publishing a website from Visual Studio on a web server running IIS. To publish, I use Build-> Publish Website. In the publication profile, I use the Web Deploy method. Despite the fact that I successfully use the "local SQL Server Compact 4.0 database" on my website, the "settings" (in the publication profile) do not detect any databases in the project. Which may not be a problem.
When I try to open a website on an IIS Web Server machine, I get the following error.
Failed to load file or assembly "System.Data.SqlServerCe, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd8080cc91" or one of its dependencies.
As my project is a website, not a website application, I don't have node links in the solution explorer. I think that System.Data.SqlServerCe.dll, which is a GAC type in my project, does not publish on the web server, which causes this error. Can I copy this .dll manually? If so, where to host the ISS web server? I do not see the bin folder.
Any help to fix this error will be appreciated.
thank
source
share