.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server Compact 3.5 Encryption Questions

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
If I create a database (.sdf file) on a server and set it to be encrypted, should it be able to be opened on a device or other PC?  In other words, is there anything in the encryption that is machine specific?  Or is it really that the password is what lets me connect and the encryption prevents it from being read by some other tool like a hex file viewer as one post suggested. I've read through lots of posts and documentation and I'm just trying to understand how encryption works and if there are any limitations or considerations and haven't found a good source. Thanks

View Complete Post

More Related Resource Links

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

Go Mobile: Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework


Developers have myriad options when it comes to creating solutions for mobile devices. One of the greatest challenges facing mobile developers is finding a compact yet robust local storage solution. SQL Server CE 2.0 promises to deliver on both fronts. This new release represents a tremendous leap in terms of features and performance over its predecessor. This article will review some of the platform and tools choices developers have today. The authors will compare and contrast the significant new features in SQL Server CE 2.0 with the previous release. Following that, they will build a sample app for illustration.

Mark Brown and David Meunier

MSDN Magazine January 2003

Getting Started with SQL Server Compact 4.0 and ASP.NET 4

The article Getting Started with SQL Server Compact 4.0 and ASP.NET 4 was added by tmorton on Monday, August 09, 2010.

While professional developers are waiting for the Visual Studio Tools and Designers for SQL Server Compact 4.0, I will show how impatient developers can include SQL Server Compact with ASP.NET applications, and use it from ASP.NET pages. Previously, you

Symmetric Key Encryption on the Compact Framework

There are two main types of encryption algorithms available within the .NET Compact Framework - symmetric and asymmetric encryption. This blog entry will discuss how to utilise symmetric key encryption, but first we have to outline the difference between Symmetric and Asymmetric encryption (I will discuss asymmetric key encryption in a future blog entry).

Symmetric and Asymmetric Key Encryption
Symmetric encryption algorithms (also known as ciphers) process plain text with a secret encryption key to create encrypted data (called cipher text). The same secret key is used to decrypt the cipher text back to plain text.

Asymmetric encryption (also known as public-key encryption) is a cryptography technique that uses public and private key pairs to encrypt and decrypt data respectably. The private key is a closely guarded secret, while the public key can be freely distributed over untrusted networks. You do not worry who has your public key (you could print it on a 100foot tall banner if you so desired), but you must keep your private key secret.

Creating a recordset using VBA in Excel with SQL Server Compact

I have create a SQL Server Compact database from VBA in Excel.  So far so good.  Now I want to access the database via a recordset.  here is my code.        Set recSet = New ADODB.Recordset        recSet.LockType = adLockBatchOptimistic     recSet.CursorType = adOpenKeyset     Call recSet.Open("SELECT * FROM SPAR", dbConn)   When I run this I get and error in Call recSet.Open("SELECT * FROM SPAR", dbConn):Errors Occurred, [,,,,]  I have search many forums about his problem, but I still can't see where the error is from.  I am using Excel 2003, and SQL Server Compact 3.5   Regards, Peter

ODBC Driver for SQL Server Compact Edition

I know that there is no ODBC driver available for SQL Server Compact Edition version 3.5.  Do you plan to add an ODBC driver in future release? If yes, is it high in your priority list?   The scenario why I am looking for an ODBC driver is to connect an MS Access application to a SDF file instead of MDB file.  This will enable me to easily sync the SDF file with SQL server repository using the new Data Sync Services.   Mario Cardinal MVP Solutions Architect

SQL Server Compact 4 replication library bug ?

I get the subscriber connection string from a SqlCeReplication object like so: public string GetFullConnectionString(string connectionString) { using (SqlCeReplication repl = new SqlCeReplication()) { repl.SubscriberConnectionString = connectionString; return repl.SubscriberConnectionString; } } With a connection string of: "Data Source=C:\data\nw(40).sdf" I get this from 3.5.8081: ssce:default lock timeout="5000";data source="C:\Data\nw.sdf";ssce:max database size="256";ssce:max buffer size="4096";ssce:temp file max size="256";ssce:enlist="True";ssce:default lock escalation="100";ssce:autoshrink threshold="60";ssce:flush interval="10"; But I get this from 4.0 CTP 1: "Autoshrink Threshold=\"60\";Case Sensitive=\"False\";Data Source=\"C:\\data\\nw40.sdf\";Default Lock Escalation=\"100\";Default Lock Timeout=\"5000\";Encrypt Database=\"False\";Encryption Mode=\"\";Enlist=\"True\";Mode=\"Read Write\";Flush Interval=\"10\";Locale Identifier=\"-1\";Max Buffer Size=\"4096\";Max Database Size=\"256\";Password=\"\";Persist Security Info=\"False\";Temp File Max Size=\"256\";Temp File Directory=\"

SQL Server Compact loses change tracking anchors when copied to device

I have a device app that use SQL Compact and uses sync framework to synchronize to a SQL Server 2008 instance.  In order to speed up the initial synchronization of my device app, I'm creating the database (.sdf) using the sync framework on the server based on the suggestion in this article: http://msdn.microsoft.com/en-us/library/dd938879.aspx#HandlingInitialSynchronizationandExpiredSubscriptions Then I get it via a WCF service down to the device app.  I'm able to download the db and it has data.  When I sync however, the database doesn't seem to think it is syncronized.  It seems to have lost it's anchors.   The following code returns an anchor for my State table on the server, but not after copying it to the device. Any suggestions are appreciated.  Thanks FPASQLCeClientSyncProvider).GetTableReceivedAnchor("State")

Chunking to ntext / image columns in SQL Server Compact 3.5

Hi all! I'm trying to store (potentially) large files in a SDF, via a table with an image column.  Image columns hold up to 2GB. Every SQL CE example I've found which does this reads the whole file into a Byte array, then passes the array in a SqlCeParameter.   This is fine assuming that the file is small, or the code is run on a machine with plenty of memory.  But if, for example, you're trying to store a 1GB file on a PC with 512Mb, the whole file cannot be buffered in one go (without paging). What I want to be able to do is read and store "chunks" of a file into an image col.  E.g. http://support.microsoft.com/kb/317034    I think this approach is both faster and more mem efficient.   It is possible on SQL Server 2008 etc., using either UPDATETEXT or UPDATE ... [column name].write( ..., ..., ...).   However, SQL CE doesn't appear to support either syntax. So, I guess my question boils down to: is it possible to store a 2Gb file in an SQL CE image column on a PC with 1GB of mem. (without spending ages paging) Thanks in advance, Ben.

SQL Server to SQL Server Compact Edition Database Copy

I recently switched from XP to Win 7 and am getting an error when using the SQL Server to SQL Server Compact Edition Database Copy wizard from johnnycantcode.com (link). I suspect that the problem is with the configuration of the path for the DQL CE dll. 1) Does anyone know where the configuration is set? It isn't in the GLT.SqlCopy.exe.config file in the local directory. 2) Has anyone got the program to run under Win 7? Thanks marc  

SQL server compact deployment help

I have a very simple windows desktop app I am trying to deploy using windows installer. I also have a SQL Server compact database file or (Local Database). When I deploy the app and try installing it on my test computer, I get an error saying the database was not found and then it displays the connection string that was set originally in Visual Studio. The application runs but all the database in not there. I don't understand why there is even a connection string there if the database in embedded in the application. Which is one of the benefits of SQL Server  Compact. What should change the connection string to?? Anyone have experience using SQl Server Compact for Win Forms?

SQL Compact Questions...

Hi, I have a few basic questions on SQL Compact - and hope I can get some clarification. 1. Versions. There seems to be a few difference versions that are referenced. SQL Compact 3.5 SQL Compact 2005 and SQL 2008 Compact?  What is the correct name of the current product? 2. Visual Studio 2008 compatibility. Which one(s) will Visual Studio 2008 happily work with. 4. Size limitation. It seems that there is a 4GB size limitation. I assume that is the total sum of all tables or is that a single table. What happens if I want to go larger than that can I say create a new instance etc. Please clarify. 5. Remote access. Do these allow for any form of remote connectivity. Can say 2 remote machine connect to a SQL Compact database - what are the limits here? 6. Management. Is there an program I can use outside of Visual Studio to manage these. 7. Future Direction. Can I assume from what I am reading that this is way we should be developing in the future. So it is like the replacement for desktop databases (a jet replacement)? Any help much appreciated - hope I have not exceeded my question limit :) Thanks, Ward.

Will SQL Server Compact feature an updated and more capable OLEDB driver

Hi, Earlier, we found problems with using SQL CE 3.5 via OLEDB. While some limited functionality was available and data can be accessed via commands and recordset via OLEDB/ADO from, say, Excel or Access, we were unable to access SQL CE directly from other data-driven packages that nominally support OLEDB, most importantly SAS and SPSS. So our question is whether SQL Server Compact will feature an updated and more capable OLEDB driver? Thx and regards, Ralph

how can I open a sql compact 4.0 DB from VS 2010 server explorer ?

Hi, I've downloaded the latest sql compact 4.0 beta, and I follow the Scott Guthrie sample (http://weblogs.asp.net/scottgu/archive/2010/07/16/code-first-development-with-entity-framework-4.aspx). It is working as expected, the DB is created. However, I cannot open the DB in the server explorer of VS (neither from sql management studio). An error telling me the version of the file is not supported is thrown. Note that I only have the 3.5 version in the provider list in the add connection wizard. What is missing ? thanks in advance for the help. stevePaying back the community for its help by writing articles : Have a Nice Day.Net Blog

Questions on Multi-Tenant Data Architecture for SQL Server Database and ASP.NET application

My company wants me to make the same asp.net application and sql server database be sharable amongst different clients. Clients will use the database for their own business use, will have their own data, we will have our own data. How can I share the same SQL Server database amongst different clients having same ASP.NET application (but somehow be able to differentiate which client user is logging in) ? Do I need to use ApplicationID and how will I detect at login which one to use ? I know I will need to add another field in all tables to differentiate client's data from ours.  

SQL Server 2008 R2 Clustering Questions?

Hi All, I have got bit Idea for my question from http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/bff2b555-f25e-4644-a58f-264611818971 I have several questions 1. We have two Serves with Different Configuration (Server Model, CPU, Memory, etc.). Can we do Active-Active Failover Clustering on the same? 2. Can we do Database Level Clustering in SQL Serve 2008 R2 3. Where I will get Documentation for Clustering SQL Serve 2008 R2? Thanks, Ashish K India  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend