SQl Server compact

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

patchirajan - 14 Jul 2008 08:26 GMT

i created a program to convert mdb to sdf with encryption. And then VB.net
compact program will retrieve the datas from it.

it works fine in SQl compact server 3.5 in Windows Mobile 5 (HP ipaq)

When i run the same in Windows Mobile 2003 SE, the uploading goes ok. but
when i want to open it in sql server 3.5 analyzer it say
Error : 0x80004005 E_FAIL
Native Error : (25080)
Description: The Operating system does not support encryption mode provided
[,,,,,]
Interfacing Defining Error: IID_IDBInitialize
param 0-2:0
param 3-5:

Reply to this Message

Christopher Fairbairn [MVP] - 14 Jul 2008 10:32 GMT

Hi,

> it works fine in SQl compact server 3.5 in Windows Mobile 5 (HP ipaq)
> When i run the same in Windows Mobile 2003 SE, the uploading goes ok. but
> when i want to open it in sql server 3.5 analyzer it say
> Error : 0x80004005 E_FAIL

One of the features in SQL Server Compact 3.5 is improved encryption
functionality. The default encryption mode when the database is created on a
newer operating system is not compatible with older Windows CE 4.2 (and
Windows Mobile 2003) devices.

If you need to support PPC2003 you will need to alter your SQL Server
Compact 3.5 connection string and specify the optional Encryption Mode
property (set it to the value 'PPC2003 Compatibility').

For example:

Data Source=\test.sdf;encryption mode=ppc2003
compatibility;password=abc123

For more detail the blog post available at
http://blogs.msdn.com/sqlservercompact/archive/2007/06/13/connection-string-data
base-creation-time-only-options.aspx
may be of interest.

Hope this helps,
Christopher Fairbairn

Reply to this Message

patchirajan - 15 Jul 2008 01:49 GMT

Hi chris,

Thanks for your post. It really helps me a lot

Regards
Patchirajan

> Hi,
>
[quoted text clipped - 23 lines]
> Hope this helps,
> Christopher Fairbairn

Reply to this Message