SQL Server Compact -- how to check for encrypted SDF file?

Posted by Vikram on Stack Overflow See other posts from Stack Overflow or by Vikram
Published on 2010-04-24T06:41:19Z Indexed on 2010/04/24 6:43 UTC
Read the original article Hit count: 228

Filed under:

sql-server-ce

Is there a way to check if an SDF file is encrypted before calling SqlCeConnection.Open()? Or do you just try to open it without a password and catch a specific error -- maybe SSCE_M_INVALIDSRCPASSWORD?

Related posts about sql-server-ce

How programically check if SqlServerCe is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How programically check if SqlServerCe is installer (System.data.sqlserverce exist) in c# .Net 3.5. Can I get the version on SqlServerCe? >>> More
How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I programmatically check whether SQL Server CE is installed (System.data.sqlserverce exist) in C# .Net 3.5. Can I get the version on SQL Server CE? >>> More
Slow Update/insert into SQL Server CE using LinqToDatasets

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a mobile app that is using LinqToDatasets to update/insert into a SQL Server CE 3.5 File. My Code looks like this: // All the MyClass Updates MyTableAdapter myTableAdapter = new MyTableAdapter(); foreach (MyClassToInsert myClass in updates.MyClassChanges) { // Update the row if it is… >>> More
SQL Server CE, Visual Studio 2008/2010 RC, and Linq-to-Sql

as seen on Stack Overflow - Search for 'Stack Overflow'
I added an .sdf to my project, added a table, added a Linq-to-Sql dmbl, and tried to add the table to the dbml. The result was an error: "The selected object(s) are an unsupported data provider" This happens in both VS 2008 Professional SP1 and 2010 RC Ultimate. I found someone talking about… >>> More
SQL Server 2005 Merge Replication to SQL Server CE 3.5

as seen on Server Fault - Search for 'Server Fault'
Hi, In my organization, we have a SQL Server 2005 database server (DBServer). Users of an application will normally be connected to DBServer, but, occasionally, would like to disconnect and continue their work on a laptop using SQL Server Compact Edition 3.5 (SQLCE). Due to this, we have been looking… >>> More

Developer IT

SQL Server Compact -- how to check for encrypted SDF file? - Developer IT

SQL Server Compact -- how to check for encrypted SDF file?

sql-server-ce

Related posts about sql-server-ce

How programically check if SqlServerCe is installer (System.data.sqlserverce exist)

How programically check if SQL Server CE is installer (System.data.sqlserverce exist)

Slow Update/insert into SQL Server CE using LinqToDatasets

SQL Server CE, Visual Studio 2008/2010 RC, and Linq-to-Sql

SQL Server 2005 Merge Replication to SQL Server CE 3.5

Categories cloud