Re: RDA and encryption

• Previous message: Darren Shaffer: "Re: insert ntext greater than 8000 chrs using vb.net or c#.net?"
• In reply to: Rob C: "RDA and encryption"
• Messages sorted by: [ date ] [ thread ]

Date: Sat, 20 Nov 2004 16:07:36 -0700

Rob,

You can password protect your SQL CE database and/or encrypt the contents
of your SQL CE database. An encrypted and/or password protected database
can play without issue in an RDA or Merge setup as long as you include any
required password in the connection string in your code. Using SQL CE Query
Analyzer on a password-protected database will simply prompt you for the
password
when you select the database. You can use SQL CE Query Analyzer on an
encrypted database as well.

-Darren Shaffer

"Rob C" <RobC@discussions.microsoft.com> wrote in message
news:EEB13AB9-8D32-4FFF-A56A-519448AEE3CD@microsoft.com...
> We are using RDA to read and write data between the SQL CE and backend SQL
> database (using SQL Server AGent). We use RDA.Pull to read data and
> RDA.SubmitSql to write records.
>
> We are looking into encrypting the SQLCE database. Once I do this, will
> RDA
> and the SQL Server Agent do all the work to deal with the encryption as
> long
> as I provide the password in the connection string or is there something
> that
> I have to manage in my code. Does it matter that the backend SQL Server
> DB
> is not encrypted?
>
> I was also wondering if I will still be able to run queries through SQLCE
> Query on the PocketPC?
>
> ALso, on a slightly realted matter, does anyone know if the Object Store
> DB
> on the PocketPC supports any type of encryption?
>
> Thanks for your help.
>
> Regards,
>
> -Rob

• Previous message: Darren Shaffer: "Re: insert ntext greater than 8000 chrs using vb.net or c#.net?"
• In reply to: Rob C: "RDA and encryption"
• Messages sorted by: [ date ] [ thread ]