tag:blogger.com,1999:blog-5238131531249720750.post7111448376993397595..comments2024-03-19T13:28:26.291+01:00Comments on Everything SQL Server Compact: SQL Server Compact 4.0 under ASP.NET Hosting– common issuesErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5238131531249720750.post-15728761227182172762014-02-15T03:12:06.523+01:002014-02-15T03:12:06.523+01:00Thank you so much for outlining the problems assoc...Thank you so much for outlining the problems associated with SQL server compact 4.0.The usage of virtual memory for each connection of SQL Server Compact has been reduced in SQL Server Compact 4.0. The visible difference is that if an application tries to open 40 to 50 simultaneous connections in SQL Server Compact 3.5 SP2, an ‘out of virtual memory’ exception will be hit. But with SQL Server Compact 4.0, the application can easily open as many connections as needed to the database file, up to the full extent of 256 connections without running out of virtual memory.Anonymoushttps://www.blogger.com/profile/14069084767074509247noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-76938171529502610742012-08-23T21:46:40.219+02:002012-08-23T21:46:40.219+02:00Hi Sebastian, assembly version 4.0.0.0 and 4.0.0.1...Hi Sebastian, assembly version 4.0.0.0 and 4.0.0.1 is the same code, but 4.0.0.1 is isolated for desktop deployment and does not Work with medium trust. Version 4.0 and 4.0 SP1 both support medium trust, as long as you use assembly version 4.0.0.0. Please feel free to contact me by mail if you need further info. See my blog post about 4.0 SP1 for a feature "overview".ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-41478123138091203412012-08-23T21:17:15.102+02:002012-08-23T21:17:15.102+02:00Hi Erik, can you tell us what is new in 4.0.0.1 as...Hi Erik, can you tell us what is new in 4.0.0.1 as opposed to 4.0.0.0? We're thinking of downgrading to 4.0.0.0 to support medium trust again, but unsure what we'd be losing. <br /><br />Also, will there be a future version that does support medium trust?Anonymoushttps://www.blogger.com/profile/11660207570089874455noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-60584960044794526182011-10-31T10:41:26.961+01:002011-10-31T10:41:26.961+01:00Rod: SQL Server Compact is no longer part of the S...Rod: SQL Server Compact is no longer part of the SQL Server releases, but tied to Visual Studio only. In VS 11 Preview, version 4.0 is included, I am guessing a service pack for 4.0 could apprear before VS 11 appears.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-24129783298005257052011-10-30T23:44:42.534+01:002011-10-30T23:44:42.534+01:00I'm just about to decide upon a first, SQL Com...I'm just about to decide upon a first, SQL Compact 4 app for shared server space. I'm always looking to do new things which have some chance of surviving as a 'version next'. Is there any news confirming that there will be such a thing as SQL Compact 5 as part of 'Denali' in 2012?<br />Thank you in advance.Rod Machttps://www.blogger.com/profile/12703761122579581492noreply@blogger.com