Error in Accessing SQL CE

Hi
iam using Pidion (BIP 500) using CE NET 5.0.
When i try to access Database (SQL CE 2005) in this Device iam Getting a error asCan't find PInvoke DLL 'sqlceme30.dll'.

I tried the same application using EMulator its working well out there but only when it's run in the device its giving me the error.

I tried to create a new SDF File using Query Analyser and it gave me a error as"Failed to Intialize the Provider. Please Make sure the SQL Server Mobile Edition is properly Installed"
Anyone can guide me on this issue.

Thanks in Advance
Biju

[890 byte] By [BijuMelayil] at [2007-12-23]

«« [OTP] VB6 and ms SQL 2005 DATETIME
»» SQL 2005 freezing unexpectedly & needing constant restarts

# 1

Please make sure that SQL CE is installed on the device. If you're using VS05 to connect and debug, VS would detect dependencies and install SQL CE.

Manav

mgaur_MSFT at 2007-8-30 >

top of Msdn Tech,Smart Device Development,Smart Devices General...

# 2

Thanks for the reply Manav.

Yes iam connecting through VS 2005 and it installs the following programs in the Device
microsoft Sql Client 2.0,
microsoft sql client 2.0[EN],
Microsoft Sql mobile,
Microsoft Sql mobile[EN]
Microsoft Sql Mobile replication.

Even after these installations iam still getting the error when accessing the Database.

Biju

BijuMelayil at 2007-8-30 >

# 3

Is your program working correctly in device emulator?

Manav

mgaur_MSFT at 2007-8-30 >

# 4

Nope my Program is working in the device (Pidion - Bip 5000) which has CE 5.0 as the Operating system.

Biju

BijuMelayil at 2007-8-30 >

# 5

If you mean your program is not working on the device (as in fails to load SQL Mobile on that device), that is probably because some OS dependencies are missing from the image. You need to contact device OEM to get it resolved.

IlyaTumanov at 2007-8-30 >

# 6

Thanks Ilya.

Got in touch with the OEM regarding this issue but they arent cleared about this.

Is there any standard or white paper which specifies these are pre requirements needed to run an .NET CF 2.0 App created in C#

Thanks

Biju

BijuMelayil at 2007-8-30 >

# 7

There's hot fix for Platform Builder (tool which is used to create Windows CE images) for NETCF V2 from which OEM can figure out required dependencies or even add NETCF V2 into the image:

http://blogs.msdn.com/netcfteam/archive/2006/06/21/642013.aspx

SQL Mobile has pretty much the same set of dependencies with notable exception of CoCreateGuid (SYSGEN_MINICOM_GUIDS). If you provide that information to OEM they should be able to verify image includes it or not. If there’s no CoCreateGuid() in your image, you can’t use SQL Mobile.

IlyaTumanov at 2007-8-30 >

Smart Device Development Hot Topic

Smart Device Development New Topic

Smart Device Development

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Error in Accessing SQL CE...'

Error in Accessing SQL CE

Smart Device Development Hot Topic

Smart Device Development New Topic

Smart Device Development

Site Classified