Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
INFO: Using Multiple Recordsets for Performance with SQL Server CE Database
Article ID: 271931 - View products that this article applies to.
This article was previously published under Q271931
SQL Server 2000 Windows CE Edition supports only a single connection to a database. If you open more than one connection to the same database, an additional Connection.Open call gives an explicit error 25035 (File sharing violation) SSCE_M_FILESHAREVIOLATION:
SQL CE Books Online displays the following if you search on 25035:
25035 File sharing violation SSCE_M_FILESHAREVIOLATION
Two applications on a Windows CE device or Pocket PC cannot concurrently open a connection to the same SQL CE database.
This behavior is by design. Inside of an application, you can pass around the connection object and create multiple recordsets. This article describes how to use multiple recordsets for performance with a SQL CE application.
SQL CE does not allow you to open more than one active connection to the same database at the same time. The SQL CE engine can support a large number of simultaneously opened recordsets on one connection. However, there are other limiting factors, such as available memory, programming environment, and locking issues. Locking can become an issue if you are using multiple recordsets on the same object (generally with transactions).
Following are some helpful tips when you are working with multiple recordsets in a SQL CE application:
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/274112/EN-US/ )INFO: Performance Tips & Efficient Ways to Handle Memory for SQL CE
Article ID: 271931 - Last Review: February 22, 2007 - Revision: 1.1