[RESOLVED] Windows CE 5.0 and SqlCe - Can't PInvoke DLL 'sqlceme30.dll

[easymoney]

So far my development testing of my mobile app has been strictly with Emulator Images in VS2005. I can add/edit data to a SqlCe Db on my desktop, but cannot get SqlCe working on my mobile device.

My mobile app loads on my handheld, but when I try to access the SqlCe db I get the following error.

Can't PInvoke DLL 'sqlceme30.dll.

I thought CF 2.0 supported SqlCe on Windows CE 5.0. What am I doing wrong?

[petevick]

Hi,
sounds like you haven't installed SqlCe on your device - you either need to install the cab, or run VS2005, and run your code on the device, and SqlCe will install

Pete

[easymoney]

Okay, finally figured out the issue.

I had Microsoft SQL Server listed under Remove Programs on my Mobile device. It installed sqlce30 in the windows directory, but not the correct version. So uninstalled it from the Control Panel.

Then I installed the following software, fixing the PInvoke error. I can now create SqlCe databases complete with tables and data.

Copied the following file to my Mobile Device and installed:

sqlce30.wce5.armv4i.CAB

from

C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\wce500\armv4i