SQLCE Encrypt Database problem - database creates but doesn't encrypt?

  • Thread starter Thread starter Jim Wilson [eMVP]
  • Start date Start date
Hi all,

I have been having a heck of a time getting my sqlce database to
encrypt. Here's the create database string I am using:

Dim SQLEngine As System.Data.SqlServerCe.SqlCeEngine

SQLEngine = New
System.Data.SqlServerCe.SqlCeEngine("provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
Source = \My Documents\ssce.sdf;password=secret;SSCE:Encrypt
Database=TRUE")

SQLEngine.CreateDatabase()

This actually DOES create the database just fine and I can insert data
all I want, but when I close the program, copy the database to my
desktop machine and open the database with NOTEPAD, you can actually
read some of the data! :-(

Any ideas on what I am doing wrong?

Many Thanks,
Brad
 
Thanks Jim,

I do not have that file. Can you give me an overview of what I am supposed
to do to get that dll installed?

I am compiling directly to a Windows Mobile 2003 device.

Thanks again,
Brad


Jim Wilson said:
Do you have the rasenh.dll installed? That's required to actually do
encryption.

Jim Wilson, eMVP
http://www.jwh.com
http://www.develop.com

Brad Isaac said:
Hi all,

I have been having a heck of a time getting my sqlce database to
encrypt. Here's the create database string I am using:

Dim SQLEngine As System.Data.SqlServerCe.SqlCeEngine

SQLEngine = New
Click to expand...
System.Data.SqlServerCe.SqlCeEngine("provider=Microsoft.SQLSERVER.OLEDB.CE.2
Click to expand...
 
Back
Top