{"id":5614,"date":"2014-04-04T05:07:43","date_gmt":"2014-04-04T05:07:43","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/04\/04\/deploying-sqlserver-ce4-in-asp-net-mvc-collection-of-common-programming-errors\/"},"modified":"2014-04-04T05:07:43","modified_gmt":"2014-04-04T05:07:43","slug":"deploying-sqlserver-ce4-in-asp-net-mvc-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/04\/04\/deploying-sqlserver-ce4-in-asp-net-mvc-collection-of-common-programming-errors\/","title":{"rendered":"Deploying SqlServer CE4 in ASP.NET MVC-Collection of common programming errors"},"content":{"rendered":"<p>Hi,<\/p>\n<p>Please refer to the first known issue\u00a0in the SQL Server Compact 4.0 CTP1 from the blog:\u00a0 http:\/\/blogs.msdn.com\/b\/sqlservercompact\/archive\/2010\/07\/07\/introducing-sql-server-compact-4-0-the-next-gen-embedded-database-from-microsoft.aspx<br \/>\n<em>The native DLLs of SQL Server Compact 4.0 CTP1 need the Microsoft Visual C++ 2008 Runtime Libraries (x86, IA64 and x64), Service Pack 1. Installing the SQL Server Compact 4.0 CTP1 using the Windows Installer (.exe) file, also installs the Visual C++ 2008 Runtime Libraries SP1. If SQL Server Compact 4.0 CTP1 is deployed privately in the application\u2019s folder the following have to be present on the machine for SQL Server Compact to function properly: a.\u00a0\u00a0\u00a0\u00a0\u00a0 Installing the .NET Framework 3.5 SP1 also installs the Visual C++ 2008 Runtime Libraries SP1.<\/em><\/p>\n<p><em>b.\u00a0\u00a0\u00a0\u00a0\u00a0 Visual C++ 2008 Runtime Libraries SP1 can be downloaded and installed from the location given below:<\/em><\/p>\n<p><em>http:\/\/go.microsoft.com\/fwlink\/?LinkId=194827<\/em><br \/>\n<em>Note that installing .NET Framework 2.0 or 3.0 or 4 does not install the Visual C++ 2008 Runtime Libraries SP1<\/em>.<\/p>\n<p>In addition, you could refer to \u201cTo deploy a SQL Server Compact 3.5 database by using private file\u2013based deployment\u201d the section from http:\/\/technet.microsoft.com\/en-us\/library\/aa983326.aspx to deploy a SQL Server Compact 4.0 database.<\/p>\n<p>If you have any more questions, please let me know.<br \/>\nThanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, Please refer to the first known issue\u00a0in the SQL Server Compact 4.0 CTP1 from the blog:\u00a0 http:\/\/blogs.msdn.com\/b\/sqlservercompact\/archive\/2010\/07\/07\/introducing-sql-server-compact-4-0-the-next-gen-embedded-database-from-microsoft.aspx The native DLLs of SQL Server Compact 4.0 CTP1 need the Microsoft Visual C++ 2008 Runtime Libraries (x86, IA64 and x64), Service Pack 1. Installing the SQL Server Compact 4.0 CTP1 using the Windows Installer (.exe) file, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5614","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=5614"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5614\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=5614"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=5614"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=5614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}