Writing a SQL CE 3.0 desktop repair application that will repair databases from the field.

[Jay]

Hello All,

I am writing a desktop application to use when an RMA comes in from
the field with a database corruption.
I first do a engine.verify() that the DB is corrupted, that returns
accurate information.

as a proof of concept I wrote the desktop application to use the
SQLServerCe libraries ( as recommeneded on a forum website) to use
this dll

Desktop Version:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies
\System.Data.SqlServerCe.dll
RT Version: v2.0.50727
Version: 9.0.242.0

when I try to do a engine.Repair() or engine.Compact() the desktop app
throws this error. NOTE: my databases do not have passwords.

System.Data.SqlServerCe.SqlCeException was unhandled
Message="The specified password does not match the database
password."
Source="SQL Server Compact Edition ADO.NET Data Provider"
HResult=-2147467259
NativeError=25028
StackTrace:
at System.Data.SqlServerCe.SqlCeEngine.ProcessResults(IntPtr
pError, Int32 hr)
at System.Data.SqlServerCe.SqlCeEngine.Repair(SEFIXOPTION
option, String dstConnStr, RepairOption repairOption)
at System.Data.SqlServerCe.SqlCeEngine.Repair(String
connectionString, RepairOption options)
at Desktop.SQL.SqlChecker.AttemptRepair(String destinationPath,
RepairOption option) in C:\dev\test\DesktopSQLCEtester\SQL
\SqlChecker.cs:line 59
at Desktop.SQL.SqlChecker.AttemptRepair(String destinationPath)
in C:\dev\test\DesktopSQLCEtester\SQL\SqlChecker.cs:line 40
at DesktopSQLCEtester.frmSQLCeTester.CheckDB(Object state) in C:
\dev\test\DesktopSQLCEtester\DesktopSQLCEtester\frmMain.cs:line 48
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context
(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
at
System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal
(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback
(Object state)

here is the microsoft native error:
25028 SSCE_M_INVALIDPASSWORD The specified password does not match
the database password.

the From and To connectionStrings
Data Source = C:\dev\test\DesktopSQLCEtester\TestData\6232\6232pn.sdf
Data Source = C:\dev\test\DesktopSQLCEtester\TestData\6232\6232pn.sdf.
2.sdf

Engine that created the database:
Mobile device version:
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server
\Mobile\v3.0\System.Data.SqlServerCe.dll
RT Version: v2.0.50727
Version: 3.0.3600.0

Thanks in advance.