A leading international company ever

ASP Knowledge Center cliniquementchill.com

• Home
• ASP Access Table
• ASP SQL Server
• ASP NET 2.0
• ASP database

SQL Server Compact Edition (original name - SQL Server Everywhere) - a new product line Microsoft SQL Server, a version of SQL Server Mobile to lift the ban work under Win32 and a modified license. The product is released on January 11, 2007.

SQL Server Compact is based on the same code as SQL Server Mobile. The database is stored in a single file format which coincides with the format of "mobile" version. This engine and file format for some years now used in some "desktop" products Microsoft, in particular, the client MSN. Unlike SQL Server Express, running as a separate service, SQL Server Compact is done "in-proc", that is, under causing process. SQL Server Everywhere is a perfect ASP database access solution.

Restriction on the maximum size of a database file - 4 GB. However, later became known [1] that the restriction of 4 GB is a purely technical (because the original database was used on devices, where the 4 GB is more than enough), so they will be changed in subsequent versions.

Using SQL Server Compact for Web applications under IIS impossible (software and licensing restrictions). Later it was announced [2] that might use SQL CE from the IIS in the new version. To do so, before using the library run AppDomain.CurrentDomain.SetData ( "SQLServerCompactEditionUnderWebHosting", true). However, this approach is not recommended because SQL CE is not optimized for a large number of simultaneous users.

Multi work with one database files from different computers - is not supported with regard to technical difficulties. However, access from different processes on one computer is possible and is staffing. Well, SQL Server Everywhere could be recommended to connect active server pages database with your web application.

© cliniquementchill.com 2008 all right reaserved