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

    Dotaz

  • 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

    9. února 2009 5:59

Odpovědi

Všechny reakce

  • 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.
    • Označen jako odpověď bharathi_m 9. února 2009 8:10
    9. února 2009 6:13
  • Anand,

    problem solved.

    thanks,

    bharathi

    9. února 2009 6:26
  • 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
    25. února 2009 10:33
  • 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
    25. února 2009 11:53
  • 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

    23. července 2009 9:20
  • 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.
    23. července 2009 13:44
  • 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
    26. července 2009 7:39
  • 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.
    26. července 2009 11:37
  • can you explain this better then me..
    i have this problem a few days and i can't resolve this.
    thanks a lot.
    2. února 2010 4:59
  • 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.
    2. února 2010 5:09
  • 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()


    11. března 2010 11:21
  • Thanks a lot man.. that works for me .. i have deployed the application successfully....

     


    Zalak Shah
    28. dubna 2011 12:40
  • 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
    12. října 2011 7:39
  • 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........

    18. března 2012 11:30