SQL Server Compact announcement
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Sticky3Votes
SQL Server Compact 3.5 SP2 Downloads and feature information
The SQL Server Compact 3.5 SP2 Desktop runtime (x86 and x64) is installed with SQL Server 2008 R2 and Visual Studio 2010. Microsoft SQL Server Compact 3.5 Service ...2 Replies | 38559 Views | Created by ErikEJ - Tuesday, April 13, 2010 5:17 PM | Last reply by ErikEJ - Wednesday, June 30, 2010 8:12 AM -
Sticky3Votes
SQL Server Compact 3.5 Downloads
Microsoft SQL Server Compact 3.5 released with Visual Studio 2008. The English release of SQL Server Compact 3.5 is available on the download center and the links are as given ...17 Replies | 98852 Views | Created by Ambrish Mishra - MSFT - Wednesday, August 01, 2007 12:31 PM | Last reply by ErikEJ - Saturday, December 10, 2011 10:57 AM -
Sticky0Votes
SQL Server Compact/Mobile Resources - Webcasts, Papers, Analysis ... etc
SELECT Happy FROM Everywhere SQL Server Mobile is now SQL Server Compact and is unrestricted ...4 Replies | 44836 Views | Created by Laxmi Narsimha Rao Oruganti MSFT - Wednesday, November 15, 2006 5:29 PM | Last reply by David In Ft. Lauderdale - Sunday, March 29, 2009 3:44 PM
-
Proposed0Votes
How to create a compact 4.0 database?
Hi, it looks like a dumb question but I googled for 30 minutes can still can't find a clue. I am very fluent with Management Studio and SQL Server development, but never used ...11 Replies | 136 Views | Created by silly_dude - Thursday, December 05, 2013 12:17 AM | Last reply by ErikEJ - Friday, December 06, 2013 8:17 AM -
Answered1Votes
Why SQLCE 4.0 connect use 20s while 3.5 only use less than 1s?
Hi guys, I have upgraded to SQLCE 4.0 this month, but when I create instance of SqlCeConnection, it will spend over 20s. My dev machine`s OS is windows server ...2 Replies | 95 Views | Created by Joey_Lee - Thursday, December 05, 2013 10:06 AM | Last reply by Joey_Lee - Thursday, December 05, 2013 2:36 PM -
Unanswered0Votes
no mapping exists from DB type AnsiString to known sql server
Sales.Sl_Date) AND (@date21 Replies | 130 Views | Created by Sparrow58 - Friday, November 29, 2013 9:49 PM | Last reply by Fanny Liu - Wednesday, December 04, 2013 12:24 PM -
Proposed0Votes
SQL Server CE 3.5 and permissions with .Net 4 (Desktop app)
System.Security.Policy.PolicyException: Required permissions cannot be acquired. at System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, ...4 Replies | 320 Views | Created by David B045 - Saturday, November 02, 2013 5:19 PM | Last reply by David B045 - Tuesday, December 03, 2013 10:48 AM -
Proposed0Votes
Convert SQL Server database to compact: Error on running Executesql command
I am using below code to convert SQL server database to compact database. It does work fine if i build the application using visual studio 2010 as it targets it to .net 4.0 .But if i build ...1 Replies | 94 Views | Created by IT researcher - Tuesday, December 03, 2013 7:17 AM | Last reply by ErikEJ - Tuesday, December 03, 2013 8:44 AM -
Unanswered0Votes
ICommandText::Execute() causes mem leaks?
Execute() call. Both m_pICmdText and m_pICmdPrepare are released before exiting the program. What else could cause these leaks? I've narrowed it down to only occuring if the execute statment is ...4 Replies | 8880 Views | Created by J Shaddix - Wednesday, September 12, 2007 9:00 PM | Last reply by Nishchal A - Monday, December 02, 2013 10:25 AM -
Answered0Votes
Help with "Problem generating manifest" error
Hi! I'm using VS 2005 SP 1 on my first project with CE. I've recently run into the problem that if I do anything with my SDF file in Visual Studio I get the ...3 Replies | 7534 Views | Created by GoingDotNet - Sunday, February 04, 2007 1:54 PM | Last reply by Hardik Viradiya - Saturday, November 30, 2013 4:23 PM -
Answered1Votes
Generate SQL Server Compact database from EF model
I just installed Visual Studio 2013 and I'm trying to generate a database from an EF model that I created, but I don't see SQL Server Compact as one of the database options even after installing SQL ...3 Replies | 379 Views | Created by fishnet37222 - Friday, October 18, 2013 6:41 PM | Last reply by TTRoadHog - Friday, November 29, 2013 2:19 PM -
Proposed0Votes
Cannot access SQLCE DB after installation
I have created a winform app that writes all data to a SQLCE DB. I am able to successfully install the app but when I try to read or write data, it tells me that it cannot open the ...5 Replies | 163 Views | Created by Kevin.Anderson - Wednesday, November 27, 2013 2:46 PM | Last reply by Olaf Helper - Thursday, November 28, 2013 11:03 AM -
Answered0Votes
Database size not going down after purging data
Please advise me as i have been deleting the data from huge database and data file size is not going down, i ran the ...3 Replies | 144 Views | Created by '''HuuM''' - Wednesday, November 27, 2013 7:27 PM | Last reply by Antoine F - Wednesday, November 27, 2013 9:41 PM -
Answered3Votes
Does SQL CE 4.0 officially support multi-user scenario?
Hello, As per this post: http://technet.microsoft.com/en-us/library/ms171750.aspx So, is it possible to use SQL CE in a 2-tier deployment ...7 Replies | 2931 Views | Created by cp.net - Thursday, October 04, 2012 8:57 PM | Last reply by ErikEJ - Wednesday, November 27, 2013 11:23 AM -
Answered0Votes
Sql Server CE - The column name is not valid. [ Node name (if any) = ,Column name = ]
I have the sql like this SELECT 2, COUNT(3) AS [C3] I run using ADO.NET using System.Data.SqlServerCe.dll and got this error The column name is not valid. [ Node name (if ...8 Replies | 232 Views | Created by IRW7 - Saturday, November 23, 2013 1:40 AM | Last reply by IRW7 - Tuesday, November 26, 2013 1:27 PM -
Answered0Votes
Problems with SQL Server CE 4.0 private deployment
Problems with SQL Server CE 4.0 private deployment System details: Windows 7 64bit.Visual Studio 2010 Ultimate Version 10.0.40219.1 SP1 RelTarget framework: .NET ...3 Replies | 212 Views | Created by Dave_1234 - Sunday, November 24, 2013 2:30 PM | Last reply by ErikEJ - Tuesday, November 26, 2013 9:15 AM -
Answered0Votes
Is there a free report builder and viewer to use with Vistual Studio 2012 Express and SQL CE?
Hi, Is there any free report engine to build and view reports to use with Visual Studio 2012 Express which uses SQL Compact Edtion 4.0? If ...10 Replies | 326 Views | Created by LuisFC - Wednesday, November 13, 2013 6:17 AM | Last reply by Fanny Liu - Thursday, November 21, 2013 12:42 PM -
Answered0Votes
How to install SQL CE 3.5 SP2 managed provider on a Windows Embedded Compact Device
Hello, We are working with the Motorola MK3190 kiosk computer that runs Windows Embedded Compact 7. It comes pre-installed with SQL CE 3.5 SP2, (version 3.5.8154.0, which is the ...2 Replies | 1638 Views | Created by venkar - Saturday, April 06, 2013 2:59 PM | Last reply by akos3 - Wednesday, November 20, 2013 6:29 PM -
Unanswered0Votes
Strange behaviour of bindingnavigator and sql tables
I use default auto-generated binding navigator for my table (sql CE, VS 2010). The 1st problem is: If I add a new entry, save it, dele it, add again, save it - I get concurrency exception. ... -
Answered0Votes
Sqlce 4.0 sp1 - Divide by zero exception when deleting
2 * DATEDIFF(second, LastRequestTime, NextPingTime)) However, attempting to delete causes a divide by zero exception. DELETE FROM ...3 Replies | 285 Views | Created by kingswood - Monday, November 18, 2013 12:49 AM | Last reply by Dan Guzman - Wednesday, November 20, 2013 12:38 PM -
Unanswered0Votes
Lost Records in Sqlce 3.0
Hi, Sometimes when I printed record, I have an error, sometimes memory errors. But sometimes the record save, records lost, Mu connection ...2 Replies | 199 Views | Created by jpais - Tuesday, November 19, 2013 2:07 PM | Last reply by jpais - Wednesday, November 20, 2013 12:24 AM -
Answered1Votes
SQL SC 4.0 with Visual Studio 2012
Hello all, I'm using a WPF project in VS 2012 with SQL SC 4.0 .sdf file, but I can't connect to (open) it via neither SQL Server Compact Toolbox nor by ...1 Replies | 263 Views | Created by TheCarloSsS - Saturday, November 16, 2013 10:41 PM | Last reply by ErikEJ - Sunday, November 17, 2013 8:07 AM -
Answered0Votes
How do I specify the correct entityFramework provider in web.config
I'm having a Package Error after switching connection string from SQL Server to to Compact SQL Server (trying out VS 2013 prerelease with CodeFirst EF 6.0 and compatible compact ...2 Replies | 2887 Views | Created by billjenner - Sunday, July 21, 2013 3:35 PM | Last reply by willvzla - Saturday, November 16, 2013 12:41 PM - Items 1 to 20 of 4904 Next ›