Spatialite and windows mobile

[Thibaut]

Hy,

I have to develop a mobile application in VB.net (Compact Framework 2)
with a little GIS part. I use SQLite as database. I have tried to use
SpatiaLite to make some basic spatial operations. But when I load the
extension with the "SELECT load_extension('filename')" instruction, I
get the error message "OsError 0x7e (126)". I use "System.Data.SQLite"
as ADO.net provider (http://sqlite.phxsoftware.com/) and the dll
available on the SpatiaLite download page. Is it possible to use
SpatiaLite in mobile application ? Is there others specific dll to
mobile platform ?

Best regards,
Thibaut Gheysen.

[Alessandro Furieri]

Hi Thibaut,

I'm completely unfamiliar with both VB.net and
mobile platforms, so I cannot say you for sure
what kind of problem this one can be.

From a first quick glance, the 0x7e (126)
error seems to be closely related to some
generic problem arising whilst trying to load
an external DLL, but it's very generic because
it can be caused by:

- wrong DLL path
- wrong access permissions / security settings
- wrong DLL version

Let me know any further new on this topic

bye
Sandro

[Keith]

Thibaut,

Did you copy the 6 spatialite dll's to the C:\windows\systems32
folder? It may fix your problem.

Keith

[Thibaut]

Hi,

I have tried the solution of Keith : copy the 6 dll's to the system
path of windows mobile device (.\windows\system) instead of the
program folder. I always have an error but, now, it's the "OsError
0xc1 (193)"...

Thibaut.

[DavidL]

You have to build spatialite for ARM processor (and Windows Mobile
limitation).
It's a bit tricky but possible.

CE adaptations of proj4 and geos are there:
http://mateusz.loskot.net/

Sqlite and Spatialite do not need modifications

libiconv is the hardest part

[Alessandro Furieri]

Hi David,

finally anything is clear to me:
- windows mobile doesn't runs on Intel x86,
but on ARM processors
- so, simply copying the x86 DLLs will
obviously produce a failure, because they
use the "wrong" machine op-codes.

Call for duty:
==============================================
"is anyone in this List interested in building
an ARM precompiled SpatiaLite ?"
==============================================

If YES, I can easily host this too on the
www.gaia-gis.it SpatiaLite's web site.

Any collaboration self-candidature will be
warmly welcomed.

bye, Sandro

[blubb...@googlemail.com]

Hello David,

do you have any hints on the toolchain you used?

[Thibaut]

Hi,

Unfortunately, I don't have the knowledge to build spatialite for ARM
processor but I found someone that have successfully ported libiconv
to windows ce (http://www2s.biglobe.ne.jp/~dat/java/project/jvm/
diary_en.html).

I hope it can help,
Thibaut.

On 26 mar, 11:29, Alessandro Furieri <a.furi...@lqt.it> wrote:
> Hi David,
>
> finally anything is clear to me:
> - windows mobile doesn't runs on Intel x86,
>   but on ARM processors
> - so, simply copying the x86 DLLs will
>   obviously produce a failure, because they
>   use the "wrong" machine op-codes.
>
> Call for duty:
> ==============================================
> "is anyone in this List interested in building
> an ARM precompiled SpatiaLite ?"
> ==============================================
>

> If YES, I can easily host this too on thewww.gaia-gis.itSpatiaLite's web site.

[DavidL]

Hi,

Many thanks for your link Thibaut.

What i basically did to build spatalite on WinCE is:

- built proj4 ce port with visual studio from (http://
mateusz.loskot.net/, project file are available there)
- built geos ce port with visual studio from (http://
mateusz.loskot.net/, project file are available there)
- made my own port of libiconv and made a visual studio project from
scratch to build it (now we have a nice port of libiconv)
- Same for spatialite extension

I would be happy to share but it's not a clean work, i only have
visual studio 2005 projetcs to build a static library
A better way to do that is to grab cegcc (http://
cegcc.sourceforge.net/) and use the standard building process

> > If YES, I can easily host this too on thewww.gaia-gis.itSpatiaLite'sweb site.

[Thibaut]

Hi,

Thank you very much David.

Is it possible that you add the result dll to this group I c

[Thibaut]

Hi,

Thanks you very much David. Can you post the result dll on this
group ? I'm very impatient to test it on my application.

Best regards,
Thibaut.

On 3 avr, 13:55, DavidL <David.Lil...@gmail.com> wrote:

[blubb...@googlemail.com]

Hi Thibaut,

did you make any progress on the issue?

[Thibaut Gheysen]

No, I'm waiting news from David.

2009/4/7 blubb...@googlemail.com <blubb...@googlemail.com>