Re: Can't find PInvoke DLL 'sqlceme30.dll' (VS2005/SQLMobile)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Mika,

Here are few things to note:
1) A WIN32 Binary or DLL can not work on a device. Similarly, a device
binary or DLL can not work on a WIN32/DESKTOP machine.
2) SQL Mobile will not work on a desktop (or in a WIN32 Application).
It works on desktop only when either SQL Server 2005 or Visual Studio 2005
is installed.

From the error description, I see that you have copied the installed DLL
from device to desktop and trying to do load library on it. Which obviously
would fail with the error you listed out.

And, why are you using the System.Data.SqlServerCe.dll from Microsoft
Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0. You should have a
separate directory for device binaries/dlls.

Hope this helps!

Thanks,
--
Laxmi NRO, SQL Mobile, Microsoft Design Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.


"Mika Laaksonen" <MikaLaaksonen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF419596-5D1C-487A-BF6B-F27B62F2E6B2@xxxxxxxxxxxxxxxx
>I tried the included Query Analyser and it does not work. It says "Failed
>to
> initialize the provider. Please make sure that SQL Server Mobile Edition
> is
> properly installed"
>
> Probably some dlls are not properly isntalled. I havn't manage to register
> the dlls. I tried to do it by code but LoadLibrary() return NULL and
> GetLastError() return 193 = "not a valid Win32 application".
> HMODULE hLib = ::LoadLibrary(L"sqlceca30.dll");
> if(hLib == 0)
> lastError = GetLastError();
>
> /Mika
>
> "Laxmi Narsimha Rao ORUGANTI (MSFT)" wrote:
>
>> Hi Mika,
>>
>> SQL CE 2.0 Database format is not compatible with SQL Mobile 3.0 Database
>> format.
>>
>> UPGRADE.EXE - Converts SQL CE 2.0 Database to SQL Mobile 3.0 Database
>>
>> The registerable DLLs are: sqlceoledb30.dll, sqlceca30.dll
>>
>> The GAC entry System.Data.SqlServerCe_v3_0_3600_0_cneutral_1.dll means
>> that you have got a GAC-ed System.Data.SqlServerCe.dll
>>
>> If things are not going ahead for you, try hard-resetting the device and
>> reinstall the CABs.
>>
>> Also, which VS 2005 version are you using? Beta1, Beta2..etc?
>>
>> What is SQL Mobile DLL version?
>>
>> Thanks,
>>
>> --
>> Laxmi NRO, SQL Mobile, Microsoft Design Engineer
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>>
>> "Mika Laaksonen" <MikaLaaksonen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:8A25B085-67CE-44FF-A690-DC69DB7E66AE@xxxxxxxxxxxxxxxx
>> >I have all sqlce*30.dlls in /Windows!
>> >
>> > and I have
>> > - GAC-ed: System.Data.SqlServerCe_v3_0_3600_0_cneutral_1.dll
>> > - GAC-ed: System.Data.SqlServerCe.resources_v3_0_3600_0_cen_1.dll
>> > I do not have
>> > - GAC-ed: System.Data.SqlServerCe.dll
>> > Maybe this is the problem!?
>> >
>> > * In SQL CE 2.0 you need to call a dllregister.exe. Maybe you need to
>> > register some dlls in SQL Mobile too? I havn't tried since I do not
>> > know how
>> > to register dlls in WinCE 5.0.
>> >
>> > * There's an upgrade.exe in "Microsoft Visual Studio
>> > 8\SmartDevices\SDK\SQL
>> > Server\Mobile\v3.0\wce500\armv4i" that I'm not using, do you know if
>> > it's
>> > needed? If needed, do you know what it is and how to use it?
>> >
>> > Thanks
>> > /Mika
>> >
>> > "Laxmi Narsimha Rao ORUGANTI (MSFT)" wrote:
>> >
>> >> Can you make sure that you have the following DLLs in respected
>> >> directories:
>> >>
>> >> Windows\
>> >>
>> >> sqlcese30.dll, sqlceqp30.dll, sqlceme30.dll, sqlceca30.dll,
>> >> sqlceoledb30.dll
>> >> GAC-ed: System.Data.SqlServerCe.dll
>> >>
>> >> Let me know whether all the DLLs are there on Devices in Windows Dir.
>> >>
>> >> Thanks,
>> >> --
>> >> Laxmi NRO, SQL Mobile, Microsoft Design Engineer
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Mika Laaksonen" <MikaLaaksonen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> >> message
>> >> news:A3541FA0-B914-4DEE-A61E-A529B886EC15@xxxxxxxxxxxxxxxx
>> >> > Thanks for answering...
>> >> >
>> >> > I have one device:
>> >> > target: Samsung ARMV4i processor (like evaluation board)
>> >> > OS: Windows CE 5.0
>> >> > Target Device: Windows CE 5.0 Device
>> >> > (SDK: STANDARDSDK_500)
>> >> >
>> >> > The application (C#/Smart Device/Windows CE 5.0/Device Application)
>> >> > automatically installs the following CAB-files
>> >> > sqlce30.wce5.armv4i.CAB
>> >> > sqlce30.repl.wce5.armv4i.CAB
>> >> > sqlce30.dev.ENU.wce5.armv4i.CAB
>> >> > from Microsoft Visual Studio 8\SmartDevices\SDK\SQL
>> >> > Server\Mobile\v3.0\wce500\armv4i when deploying the application (if
>> >> > you're
>> >> > using System.Data.SqlServerCe).
>> >> > I doesn't work!
>> >> >
>> >> > I have tried to manually copy and install the CAB files to the
>> >> > device
>> >> > /Windows folder and to the application folder but it still does not
>> >> > work!
>> >> >
>> >> > Error:
>> >> > Can't find PInvoke DLL 'sqlceme30.dll'
>> >> > at
>> >> > System.Data.SQLServerCe.SqlCeReplication..cstor()
>> >> > at
>> >> > applicationname.Form1.Sync()
>> >> > ...
>> >> >
>> >> > /Mika Laaksonen
>> >> >
>> >> > "Laxmi Narsimha Rao ORUGANTI (MSFT)" wrote:
>> >> >
>> >> >> Hi Mika,
>> >> >>
>> >> >> I hope your target is a device and not a desktop! If so, read
>> >> >> below.
>> >> >>
>> >> >> You need to install the required cabs on the device, just copy
>> >> >> ing
>> >> >> the
>> >> >> DLLs into device's windows folder wont work.
>> >> >>
>> >> >> To let you know what are the cabs you are supposed to install,
>> >> >> first
>> >> >> let
>> >> >> us know the following details:
>> >> >> 1) What is your device type Pocket PC/Smart Phone/ Pocket PC
>> >> >> Phone
>> >> >> Edition?
>> >> >> 2) You have one device or different devices. From mail, it is
>> >> >> understood
>> >> >> that you are using WCE 5.0 ARMv4i Device. All devices are of this
>> >> >> type
>> >> >> or
>> >> >> different types?
>> >> >>
>> >> >> Hope this helps!
>> >> >>
>> >> >> Thanks
>> >> >> --
>> >> >> Laxmi NRO, SQL Mobile, Microsoft Design Engineer
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Mika Laaksonen" <Mika Laaksonen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
>> >> >> in
>> >> >> message
>> >> >> news:80B98EA7-D623-47DE-A2AA-76B57D3FC31F@xxxxxxxxxxxxxxxx
>> >> >> > I've tried the tutorial "Creating a Mobile Application with SQL
>> >> >> > Server
>> >> >> > Mobile" in "SQL Server 2005 Mobile Edition Books Online" on a
>> >> >> > Windows
>> >> >> > CE
>> >> >> > 5.0
>> >> >> > (ARMV4i) device.
>> >> >> >
>> >> >> > But when I execute the application on target I get "Can't find
>> >> >> > PInvoke
>> >> >> > DLL
>> >> >> > 'sqlceme30.dll'" !
>> >> >> >
>> >> >> > I using the namespace System.Data.SqlServerCe
>> >> >> > (C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
>> >> >> > Server\Mobile\v3.0\System.Data.SqlServerCe.dll)
>> >> >> >
>> >> >> > I've tried to manually copy sqlceca30.dll, sqlcecompact30.dll,
>> >> >> > sqlceer30en.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll,
>> >> >> > sqlcese30.dll from Microsoft Visual Studio 8\SmartDevices\SDK\SQL
>> >> >> > Server\Mobile\v3.0\wce500\armv4i to my application folder and to
>> >> >> > /Windows
>> >> >> > folder on my target but still I get Can't find PInvoke DLL
>> >> >> > 'sqlceme30.dll'
>> >> >> >
>> >> >> > Thanks
>> >> >> > Mika Laaksonen
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>


.

Relevant Pages

  • Re: Cant find PInvoke DLL sqlceme30.dll (VS2005/SQLMobile)
    ... Probably some dlls are not properly isntalled. ... > SQL CE 2.0 Database format is not compatible with SQL Mobile 3.0 Database format. ... > The registerable DLLs are: ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Mobile dll corruption
    ... is not enough memory to load them. ... Are the DLLs present? ... A SQL Mobile DLL could not be loaded. ...
    (microsoft.public.sqlserver.ce)
  • Sql Mobile HELP!!!!
    ... thought was Sql Mobile and downloaded and installed ... when I run ISQL on the PDA and try to contect to a database it tells me the ... I have also tried to copy the following dlls to the device manually ... DllregisterServer entry point was not found ...
    (microsoft.public.sqlserver.ce)