"Can't find PInvoke DLL 'sqlceme35.dll"

Question

Exception:"Can't find PInvoke DLL 'sqlceme35.dll"

When I run the application in emulator the above exception message is shown.


should I install any SQL Server Compact in the device or emulator?
If Yes,please provide the links for for the setup files.

Thanks,
bharathi

Answer 1

yes you need to install Compact on the device. 

Path: C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i
Cabs: 
1. sqlce.ppc.wce5.armv4i.CAB
2. sqlce.repl.ppc.wce5.armv4i.CAB
3. sqlce.dev.ENU.ppc.wce5.armv4i.CAB
 
I hope this helps:

http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/can-t-find-p-invoke-dll-sqlcemenn-dll.aspx


Thanks & regards,
Devesh Anand

---

Please click Yes, if my post was helpful.

Answer 2

Anand,

problem solved.

thanks,

bharathi

Answer 3

Hi Anand,

THANK YOU A LOT!!!!!!!!!!!!!!

you are great.. I was strugling with this error for more than a month. i was not able to fix it. 

Thanks a lot.

Suggestion for people who tried all other link and no luck:

Please try this. This worked for me.

Shiva.

---

shiva

Answer 4

shiva. said:

Hi Anand,

THANK YOU A LOT!!!!!!!!!!!!!!

you are great.. I was strugling with this error for more than a month. i was not able to fix it. 

Thanks a lot.

Suggestion for people who tried all other link and no luck:

Please try this. This worked for me.

Shiva.

---

shiva

 You r welcome shiva.

also try to understand why those CAb's should be installed.

They are the setup's That shold be installed in the mobile device

sqlce.repl.ppc.wce5.armv4i.CAB

repl-for replication purpose

 sqlce.dev.ENU.ppc.wce5.armv4i.CAB

dev- for development purpose in mobile
**************************************************************************************
Anand,

please try to make this thread' solution available as permanent page as

"http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/can-t-find-p-invoke-dll-sqlcemenn-dll.aspx"

because ,I too  spend lot of time to solve this problem

---

Thanks, Bharathi

Answer 5

Hi Anand

If I'm working only with emulator (not a real device) and I'm getting this error, where to put the cabs files for the emulator?

Regards

Baruch

Answer 6

Baruch,

You need to copy these cab files on your emulator and then deply these cabs by clicking on them manually. The process is same for devices and emulators.

To know how to copy cab files on the emulator, read this:

http://community.opennetcf.com/forums/t/199.aspx

or

Use Remote File Viewer to copy files to emulator:

http://msdn.microsoft.com/en-us/library/ms894566.aspx


You may also deploy cab files on the Emulator by using VS08 Sp1.

1. Create a project which references to System.Data.SqlServerCe.dll (3.5.1)
2. Press F5 on the project and choose the emulator you want the Cabs to be deployed

You may also read this article:

http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/can-t-find-p-invoke-dll-sqlcemenn-dll.aspx


Please let me know if you have any issues.


Thanks & Regards,
Devesh Anand

---

Please click Yes, if my post was helpful.

Answer 7

Hi Anand Thanks for your answer. If I make reference to this directory its working fine: C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll (dll File Version 3.0.5206.0) But, if I make reference to this directory I get the error ("Can't find PInvoke DLL 'sqlceme35.dll"): C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\ System.Data.SqlServerCe.dll (dll File Version 3.5.5692.0) What's wrong with the new dll path? Regards Baruch

Answer 8

As I understand from the above information you are using Visual Studio 2005.

Build Version 5206 is SQL Server Mobile 3.0 integrated with Visual Studio 2005.
Build Version 5692 is SQL Server Compact 3.5 Sp1 integrated with Visual Studio 2008 Sp1. (3.5 Sp1 Devices msi needs to be installed seprately)  

'F5' Deployment of "Sql Server Mobile 3.0" Cabs will work only with Visual Studio 2005.
'F5' Deployment of "Sql Server Compact 3.5 Sp1" Cabs will work only with Visual Studio 2008 Sp1.

Thanks & Regards,
Devesh Anand

---

Please click Yes, if my post was helpful.

Answer 9

can you explain this better then me..
i have this problem a few days and i can't resolve this.
thanks a lot.

Answer 10

HI Xevits,

Please let me know which version of Mobile Device\Emulator you are using?
Which version of SQL Compact?
Which version of Visual Studio?

What are the exact steps are you facing.

Thanks & Regards,
Devesh Anand

---

Please click Yes, if my post was helpful.

Answer 11

Hi Anand,

I have the same error. I have included the following CAB files

1. sqlce.ppc.wce5.armv4i.CAB
2. sqlce.repl.ppc.wce5.armv4i.CAB
3. sqlce.dev.ENU.ppc.wce5.armv4i.CAB

My SQl CE version is 3.5.1.0 and I am using VS 2008 for development. Windows Mobile 6 Professional Emulator is used for development.

The error is thrown when the SqlCeConnection object is created.

the exception details are below.

System.MissingMethodException was unhandled

  Message="Can't find PInvoke DLL 'sqlceme35.dll'."

  StackTrace:

       at System.Data.SqlServerCe.SqlCeConnection..ctor()

       at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)

       at xxxxx.SupplyAndReceipt.Next_Click(Object sender, EventArgs e)

       at System.Windows.Forms.Control.OnClick(EventArgs e)

       at System.Windows.Forms.Button.OnClick(EventArgs e)

       at System.Windows.Forms.ButtonBase.WnProc(WM wm, Int32 wParam, Int32 lParam)

       at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)

       at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)

       at System.Windows.Forms.Application.Run(Form fm)

       at xxxxx.Program.Main()

Answer 12

Thanks a lot man.. that works for me .. i have deployed the application successfully....

 

---

Zalak Shah

Answer 13

Hi,

 

The problem is that the native DLL is not installed. I tried various solutions to no avail, and the only one that worked for me was to install the missing DLL manually. It is included in a CAB file located under C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\<platform>\<processor>, but which platform and processor is the right one? I found the answer here: http://forums.microsoft.com/technet/showpost.aspx?postid=2594381&siteid=17. All Windows Mobile 5 and above devices are usingsqlce.phone.wce5.armv4i.cab, so that’s the one you need to install. (So platform is wce500 and processor is armv4i.)

---

Joe

Answer 14

A pesar que he recorrido mil foros, la respuesta correcta no está.

LA RESPUESTA ESTA AQUI:

ms-help://MS.SSC.v35/MS.SSC.v35.ES/sscprog/html/f3127502-44d2-4cc8-9189-40900b26e8fe.htm

EN  LA SECCION Agregar SQL Server Compact 3.5 al proyecto y Configurar SQL Server Compact para la implementación privada

LUEGO DE ÉSTO TE FUNCIONA TODO A MIL........

Answer 15

check this blog

http://holsson.wordpress.com/2008/09/15/cant-find-pinvoke-dll-sqlceme35-dll/