Hi to all, and excuse me if i'm writing to the wrong list but i just subrscibed ;)

I got a problem that i'm not able to resolve... i'm using lazarus and freepascal compiler tools to cross-compile a software i'm developing to a Pocket PC with Windows 2003 inside.

The system is winCe (widget) and ARM (architecture). Thanks to lazarus all works, but i got a problem...

The sqldb component have no libraries to (cross)compile in wince-arm architecture...
I need the sqldb component files:
registersqldb.o
sqldblaz.o
registersqldb.ppu
sqldblaz.ppu

Compiled for arm-wince.

I got the i386-win32 version under:
C:\apps\lazarus\components\sqldb\lib\i386-win32\

But the arm-wince directory (in the lib directory) is empty.

I write to you cause this component should be open source, but i'm not able neither to compile it or to find the source, and i know that Joost van der Sluis that should be the component author write in that mailing list.

I apologize if i wrote something wrong and if i'm asking for help, but i'm in a bit hurry and i have to discover if i can make my Pocket PC connect to a local mysql database as soon as possible, or i'll be forced to use .net (bleah).

Actually i have no problems to compile an executable application that works on it, but if i add SQLdb components i get, of course, compiling errors.

The sqldb-components in sqldblaz are just a simple wrapper around the real sqldb-components. This wrapper is used by Lazarus, so you can drop the components on a form.

Your problem isn't that the sqldblaz.ppu isn't there, but that sqldb isn't compiled at all on a wince-target. So it's not available, and thus Lazarus can't build the wrapper.

What you need is sqldb.ppu and mysqlconnXX.ppu. Now they aren't compiled for wince, because no-one tested it. But in principle, it should work.

I think that you already compiled fpc by yourself. You can enable sqldb for wince by doing the following:

1: Edit fcl/db/Makefile.fpc and add sqldb to dirs_wince 2: Edit fcl/db/sqldb/Makefile.fpc and add mysql to dirs_wince 3: go to fcl/db and run the command 'fpcmake -r -Tall' 4: recompile fpc and see what happens.

Maybe that you're lucky and that it will compile. If so, also compile the sqldblaz-package in lazarus. And then: try

And for all: report your findings here. ;)

Your problem isn't that the sqldblaz.ppu isn't there, but that sqldb isn't compiled at all on a wince-target. So it's not available, and thus Lazarus can't build the wrapper.

BTW.: Is sqldb available for Linux on PC and ARM ?

-Michael

I did the 3 points you said, and got a lot rows like this from windows command line:
Processing unmaintained/mysql/Makefile.fpc
i386-linux requires: rtl,mysql
i386-go32v2 requires: rtl,mysql
i386-win32 requires: rtl,mysql
i386-os2 requires: rtl,mysql
i386-freebsd requires: rtl,mysql
i386-beos requires: rtl,mysql
i386-netbsd requires: rtl,mysql
i386-solaris requires: rtl,mysql
i386-qnx requires: rtl,mysql
i386-netware requires: rtl,mysql
i386-openbsd requires: rtl,mysql
i386-wdosx requires: rtl,mysql
i386-darwin requires: rtl,mysql
i386-emx requires: rtl,mysql
i386-watcom requires: rtl,mysql
i386-netwlibc requires: rtl,mysql
i386-wince requires: rtl,mysql
m68k-linux requires: rtl,mysql
m68k-freebsd requires: rtl,mysql
m68k-netbsd requires: rtl,mysql
m68k-amiga requires: rtl,mysql
m68k-atari requires: rtl,mysql
m68k-openbsd requires: rtl,mysql
m68k-palmos requires: rtl,mysql
powerpc-linux requires: rtl,mysql
powerpc-netbsd requires: rtl,mysql
powerpc-amiga requires: rtl,mysql
powerpc-macos requires: rtl,mysql
powerpc-darwin requires: rtl,mysql
powerpc-morphos requires: rtl,mysql
sparc-linux requires: rtl,mysql
sparc-netbsd requires: rtl,mysql
sparc-solaris requires: rtl,mysql
x86_64-linux requires: rtl,mysql
x86_64-freebsd requires: rtl,mysql
x86_64-win64 requires: rtl,mysql
arm-linux requires: rtl,mysql
arm-palmos requires: rtl,mysql
arm-wince requires: rtl,mysql
arm-gba requires: rtl,mysql
powerpc64-linux requires: rtl,mysql
Writing Makefile

After that i did a "make" having this errors:
Error makefile 2676: Command syntax error
Error makefile 2681: Command syntax error
Error makefile 2682: Command syntax error
Error makefile 2689: Command syntax error
Error makefile 2690: Command syntax error
Error makefile 2734: Command syntax error
Error makefile 2735: Command syntax error
Error makefile 2779: Command syntax error
Error makefile 2780: Command syntax error
Error makefile 2824: Command syntax error
Error makefile 2825: Command syntax error
Error makefile 2869: Command syntax error
Error makefile 2870: Command syntax error
Error makefile 2914: Command syntax error
Error makefile 2915: Command syntax error
Error makefile 2959: Command syntax error
Error makefile 2981: Command syntax error
Error makefile 2982: Command syntax error
Error makefile 2983: Command syntax error
*** 1426 errors during make ***

I'm using lazarus "recompiled for wince", found on that link: http://wiki.lazarus.freepascal.org/index.php/Windows_CE_Interface ftp://ftp.freepascal.org/pub/fpc/contrib/cross/gdb-6.4-win32-arm-wince.zip

I didn't compiled it myself, i'm not that good ;)

About the second part of your mail, in components\sqldb i found in the makefile.fpc "LCL_PLATFORM=win32"
Is it good to modify it at hand and try to "make" it?

If someone of you think that the compiled libraries would solve my problem, and have all the stuff
used to compile them, please give me a little hand and send me them, i can spend a month to try it without success.
I use linux at home and i know how to compile from makefiles, but here at work i'm using windows.

Thank you for any help.. in the meantime i'll go ahead with other tasks of that PocketPC application, hoping
that there is a solution to use mysql directly from it. If not, it would be so hard but i'll have to do a server/client
application to wrap the database data through other tcp protocols :'(

Bye,
Alvise

I want it to be. And I think it should work, but I have no possibilities to test it.

Joost.

Those are normal

After that i did a "make" having this errors: Error makefile 2676: Command syntax error Error makefile 2983: Command syntax error *** 1426 errors during make ***

Those also, if you use the make version from 'Borland', but you have to use the make provided by fpc. You can (temporarily) remove delphi from your part-settings, or place the directory of fpc before delphi in your path-string. Or you could simply remove the make.exe (or rename it) from Borland, as you'll probably never use(d) it.

I'm using lazarus "recompiled for wince", found on that link: http://wiki.lazarus.freepascal.org/index.php/Windows_CE_Interface

In this page you can also find out how to compile fpc and lazarus yourself. The step where you are now, is step 3 in thin link: http://www.freepascal.org/wiki/index.php/WinCE_port

I didn't compiled it myself, i'm not that good ;)

Well, you have to learn. It's not that hard, you can find a lot on information about it on the wiki.

About the second part of your mail, in components\sqldb i found in the makefile.fpc "LCL_PLATFORM=win32" Is it good to modify it at hand and try to "make" it?

That's useless as long as fpc isn't recompiled. But you can do that afterwards, yes.

Regards,
Joost.

Sorry but I didn't understand the procedure to compile... ... and the Borland make? How i used it? by default (it's in the "bash" paths)?

Can't someone, maybe who worked to it, cross-compile for me those libraries? It would be very appreciated...

And... are you sure that that them will work with my wince application? I have to decide how to take data from Mysql, if that component works i'll try with that...
... differently i'll have to use some html-xml wrapper or client/server sockets :(

However i'm making a lot of confusion with Lazarus' paths.

thanks

Sorry but I didn't understand the procedure to compile... ... and the Borland make? How i used it? by default (it's in the "bash" paths)?

Try to rename Borland's Make to BMake or something, at least when compiling FPC code to avoid incompatibilities.

Leonardo M. Ramé
http://leonardorame.blogspot.com

__________________________________________________ Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Can't someone, maybe who worked to it, cross-compile for me those libraries? It would be very appreciated...

Well, if you want this, you have to put some efford into it. If you can come online on IRC at freenode - #fpc - the people there can probably help you. And there's a big chance that I'm there also.

And... are you sure that that them will work with my wince application? I have to decide how to take data from Mysql, if that component works i'll try with that...

No, but someone has to test it.

... differently i'll have to use some html-xml wrapper or client/server sockets :(

Another alternative is to acces the mysql-client directly. But that's also not tested.

Joost.