[RESOLVED] VB.Net CF 2.0 And SQL CE 3.0

[JuniorProgrammer]

I have a Pocket PC App running under WM5.0 which uses SQL CE 3.0 as its database. I don't have any problems running the ppc app on the emulator but when i tried transferring it to my ppc device, an error occurs which states that SQL CE 3.0 is not installed in my ppc device.

When running my app thru active sync, I can see the status that it's installing the sql ce cab file. But it still gives me the error that sql ce is not installed. I've checked if my ppc device have a query analyzer and tried doing queries against my database and it works fine.

Anyone knows why this is happening and how can i resolve this problem?

Thanks in advance.

[petevick]

Hi,
are you sure it is 3.0 being installed on the device?

There should be dll's in the windows folder such as sqlceca30.dll

On the query analyser, what version do you see when you do 'About'?

[JuniorProgrammer]

I've read that once I deploy the ppc app to the device when debugging, it will automatically send and install all the necessary cab files. So i think that it's already installed on the device. In case that sql ce is not getting installed, how can I install it?

[petevick]

Hi,
there are cab files to deploy look in C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\ - but have you checked what I asked about the dll's and the version number?

[JuniorProgrammer]

It seems that the cab files are not installed on the ppc even during deployment... I had to copy the sqlce cab file to the ppc and do the installation in it... Aftr that, everything works fine... Thanks for the help...