SQL Server Compact announcement
-
3 VotesSQL 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 ...Sticky | 18 Replies | 118654 Views | Created by Ambrish Mishra - MSFT - Wednesday, August 01, 2007 12:31 PM | Last reply by VenkateshMunnu - Monday, November 14, 2016 5:53 AM
-
0 Votes
SQL Server Compact/Mobile Resources - Webcasts, Papers, Analysis ... etc
SELECT Happy FROM Everywhere SQL Server Mobile is now SQL Server Compact and is unrestricted ...Sticky | 4 Replies | 54481 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
-
0 Votes
Legacy Microsoft SQL CE database version 3.5 on Windows 10
Hi, Most of ours software uses the legacy Microsoft SQL CE database version 3.5 on Windows 7 operating system. We are planning to run thoses ...Proposed | 2 Replies | 47 Views | Created by Mat0023 - Wednesday, May 23, 2018 1:23 PM | Last reply by Xi Jin - Thursday, May 24, 2018 6:46 AM -
0 Votes
MS SQL SERVER for Windows CE
I need install free MS SQL SERVER (some like Express Edition) to Windows CE. It is possible? How to do? Where is installation package?Proposed | 2 Replies | 118 Views | Created by MS SQL SERVER for Windows CE - Tuesday, May 15, 2018 12:16 PM | Last reply by Hilary Cotter - Tuesday, May 15, 2018 2:31 PM -
0 Votes
SQL Compact 4.0 support in Windows 10
I haven't found any information like: "SQL Compact 4.0 is supported in Windows 10" or "SQL Compact 4.0 is NOT supported in ...Unanswered | 1 Replies | 131 Views | Created by Kruudash - Monday, May 07, 2018 3:13 PM | Last reply by Castorix31 - Monday, May 07, 2018 3:27 PM -
0 Votes
I need the solution to An error occurred while initializing sql server compact System.invalidoperationexception... cannot open... system.data.sqlserverce.3.5 not installed
please help me resolve the error that I'm getting. An error occurred while initializing sql server compact System.invalidoperationexception... cannot open... system.data.sqlserverce.3.5 not ...Proposed | 1 Replies | 132 Views | Created by smia31 - Sunday, April 22, 2018 1:09 PM | Last reply by Olaf Helper - Monday, April 23, 2018 7:59 AM -
0 Votes
Is there any alternative for SQLite ? Can we use SQL Server Compact as alternative for SQLite?
Is there any alternative for SQLite ? Can we use SQL Server Compact as alternative for SQLite? Can we store the SQL Server Compact file in ...Unanswered | 4 Replies | 159 Views | Created by bSurendiran - Saturday, April 21, 2018 12:52 PM | Last reply by Visakh16 - Saturday, April 21, 2018 5:58 PM -
1 Votes
Local data storage
I'm in the process of developing a windows WPF application that needs to be deployed on several 1000 machines. I'm looking for my application to store data locally in a local data ...Unanswered | 1 Replies | 130 Views | Created by Sudharsan.PJ - Monday, April 16, 2018 4:14 PM | Last reply by Teige Gao - Tuesday, April 17, 2018 1:55 AM -
2 Votes
SQL Server CE 4.0 package did not load correctly
Using Visual Studio 2010, in Server Explorer I'm trying to add a connection by right clicking on Data Connections and selecting "Add Conection...". When I do this I get an error that ...Answered | 5 Replies | 7476 Views | Created by TerryDiederich - Tuesday, August 28, 2012 12:41 PM | Last reply by shalu.june14 - Friday, April 06, 2018 2:10 PM -
5 Votes
Format money or float 2 decimal places
How do I format the money or float field types to 2 decimal places during a SELECT statement?Answered | 5 Replies | 34974 Views | Created by rcfearn - Monday, March 24, 2008 8:50 AM | Last reply by Visakh16 - Wednesday, April 04, 2018 10:24 AM -
0 Votes
using Flush Interval correctly in SqlCE
I have a requirement that fits nicely with the Flush Interval, I hope. The requirement is that the SqlCE 4.0 database should not write to disk on every update, delete, but only ...Answered | 5 Replies | 295 Views | Created by danielsn - Saturday, March 24, 2018 7:28 PM | Last reply by danielsn - Tuesday, March 27, 2018 12:21 AM -
0 Votes
Use of Entity Framework and Compact SQL CE files
I have a requirement for one .sdf file per instantiation of a class, and I may have up to 1000 instances of this class. Would it be wrong to use EntityFramework in this rather odd ...Answered | 1 Replies | 237 Views | Created by danielsn - Wednesday, March 21, 2018 9:49 PM | Last reply by Teige Gao - Thursday, March 22, 2018 7:26 AM -
0 Votes
problems related to installation
I installed SQL Compact and it appeared to work yesterday, as a window under "additional windows" in Visual studio 2015. Today in a different instance of Visual Studio it ...Proposed | 1 Replies | 249 Views | Created by danielsn - Wednesday, March 21, 2018 6:19 PM | Last reply by Teige Gao - Thursday, March 22, 2018 5:51 AM -
0 Votes
limitations of SQL CE
If I have 1000 .sdf files, will I be able to have one transaction on each in parallel from my application (in an ideal case where threads are of no limitation etc), or is there a limitation on number ...Answered | 2 Replies | 235 Views | Created by danielsn - Wednesday, March 21, 2018 12:03 AM | Last reply by danielsn - Wednesday, March 21, 2018 3:10 AM -
1 Votes
SQL Compact with SQL 2016 for merge replication + Web Synchronization
Hi, We have been using SQL 2012, SQL compact for our Handheld application. We use IIS for web synchronization for merge replication. This configuration is working fine no ...Answered | 9 Replies | 810 Views | Created by Rupesh_Patel - Thursday, November 09, 2017 4:42 PM | Last reply by ErikEJ - Tuesday, March 13, 2018 1:25 PM -
0 Votes
Mega-BUG in SqlCeDataReader.GetBytes (SQL CE 3.5)
I''v writed my own SqlBlobReadStream : Stream that uses SqlCeDataReader.GetBytes method. I'h specified sequential access mode for reading. In my SqlBlobReadStream I should calculate my ...Unanswered | 2 Replies | 7115 Views | Created by Dmitry Valyukov - Thursday, August 14, 2008 4:10 PM | Last reply by clint.conrad - Wednesday, February 14, 2018 7:31 AM -
0 Votes
sql enterprise core license
Hi, We are having a sql enterprise core license quantity 4. My question is how many vCPU we can configure for SQL Server as per our license quantity. ...Proposed | 1 Replies | 374 Views | Created by Anu_1986 - Tuesday, February 13, 2018 10:00 AM | Last reply by Olaf Helper - Tuesday, February 13, 2018 10:15 AM -
0 Votes
Accessing SQL Server Compact from SSMS 2008 R2
I am using SQL Server 2008 R2 with SSMS, and I want to connect to SQL Server Compact (sdf files) but the option is disabled (greyed out). I also installed SQL ...Proposed | 3 Replies | 400 Views | Created by cardila021 - Friday, February 09, 2018 5:10 PM | Last reply by Teige Gao - Monday, February 12, 2018 8:46 AM -
0 Votes
Failed to decrypt a column encryption key using key store provider: 'MSSQL_CERTIFICATE_STORE'.The last 10 bytes of the encrypted column encryption key are: '57-C6-CB-21-3D-6C-CF-55-C6-61'. The system cannot find the file specified.
Hi, We are working on the "Always Encrypted" feature in the SQL 2016 db to perform the deterministic encryption on one subscription with few columns. ...Unanswered | 6 Replies | 1406 Views | Created by Abhishesh Pandey - Wednesday, January 10, 2018 2:06 PM | Last reply by Teige Gao - Tuesday, January 23, 2018 9:09 AM -
0 Votes
Is it possible to use SQL Server Compact 4.0 in Visual Studio Integration Services (SSIS)?
I have SSIS projects using connection managers to SQL Server Compact 3.5 databases. I would like to update all my databases to version SQL Server Compact 4.0 but it seems that no connection manager is ...Unanswered | 1 Replies | 506 Views | Created by SWAT Team member _1 - Wednesday, January 17, 2018 1:42 PM | Last reply by pituach - Wednesday, January 17, 2018 3:12 PM -
0 Votes
Error starting project in VS 2017 pro
I am learning asp.net / C# at my job. I was practicing using VS community edition. Now I have installed 2017 professional edition and SQL Server 2012 (after uninstalling CE version). ...Unanswered | 1 Replies | 538 Views | Created by WJaggers - Tuesday, January 16, 2018 9:08 PM | Last reply by Olaf Helper - Wednesday, January 17, 2018 7:10 AM -
0 Votes
Getting Out of memory Exception while performing Encryption on columns.
Hi, We are working on the "Always Encrypted" feature in the SQL 2016 db to perform the deterministic encryption on one subscription with few columns. ...Proposed | 4 Replies | 655 Views | Created by Abhishesh Pandey - Wednesday, January 10, 2018 2:11 PM | Last reply by Abhishesh Pandey - Monday, January 15, 2018 11:00 AM - Items 1 to 20 of 5271 Next ›
