Cannot open .sdf file in QA3.0

Hi,

We are using VS 2005 with SQL Server Mobile Edition. We created the .sdf file on the desktop and added this file to our VS project and set the Build Action to content. Next we deployed our app on Symbol PDA which has Windows CE 5.0 as the OS. We followed the following steps:

1. Deploy the app.

2. Install .NET CF 2.0

3. System_SR_ENU.CAB

4. sqlce30.wce5.armv4i.CAB

5. sqlce30.dev.ENU.wce5.armv4i.CAB

6. sqlce30.repl.wce5.armv4i.CAB

We now tried to double-click the .sdf file in PDA to open in QA3 but we get error.:

Error: 0x80004005 E_FAIL

Native Error (0)

Description: Interface defining error: IID_IDBInitialize

Param. 0:0

Param. 1:0

Param. 2:0

Param. 3:

Param. 4:

Param. 5:

What could be the issue?

Because of this, we unable to run the app since in our login form, this database is not available and hence we cannot proceed.

Regards,

Vilas

Please make sure that sqlceoledb30.dll is on the device and registered. The easiest way to do this is to install the repl cab (which you have done). In this case I suggest that you reinstall it and try again.

I usually install the dev cab last, but this should have no effect...

|||

I did as you said. Also found that my .sdf file was created on SQL Mobile Server and therefore did not work on PDA which has CE OS. Now I created the .sdf file on SQL CE and deployed on PDA. I can now open the .sdf file in QA 3.0 of PDA. Now when I try to access the same .sdf file via VS 2005 C# app, I get the error again. But I can run the same on Emulator without any problems. Any reason why?

Regards,

vnj

|||When you refer to a VS2005 C# application do you mean a desktop application? If so, please make sure you install SQL Compact Edition 3.1 on the desktop.