Hi Leonardo.

I will try to support you in the best way I can, but please keep in mind that I'm a noob both with lazarus and delphi.

The first thing you have to understand, is that lazarus itself is not able to do everything on a system, sometimes it uses (like it's supposed to be) external libraries for external program-use.

For example, if you want to use SQLdb on a machine, YOU MUST HAVE libmysql.dll (or .so for linux) correctly installed in the system.

I don't know how ZEOSDBO works on Lazarus, but I use them on windows and also mysqlclient.dll have to be installed on the system... So... cause for Windows Mobile there is no mysqlclient.dll, there is also no way to connect to a mysql database. I already writed at mysql stuff 7 months ago and they said me there was no solution, you will easily find my emails/posts with google.

I also don't know how does sqllite work, but if it's possible to connect to it remotely, maybe also mysqlclient.dll is used for that purpose.

So, my only solution for you is to use php scripts to select and update the data into the database (it's also very simple and the querys remain phisically on the server while your client is elsewere) and interrogate the database with an http connection.

For example, to get the data from a table you will use a xml parsing function like: data_array;=parse_the_xml_data(http_get( 'http://myserveraddress/myapplication/table1.php?key=1' ));

You can use the http_POST to give to apache/php data to insert into the database with other php scripts. So, php/apache will be able to handle the mysql data (they do it greatly) while on your application you will just need to do the forms and to parse xml stuff with the DOM functions.

That is a workaround to make a web-based application that will work both on WinCE and all other systems doing the client with lazarus and using the same code for each client you compile.

However, if you manage to use ZeosDB on WinCE someway, you're more skilled than I thought ;)

Alvise

P.S. Are you already using a working lazarus with cross-compiler, or you're still trying the base-ide? Cause things are a little different using a crosscompiler and you will encounter a lot of more problems using external components. For example neither SQLdb can be used on WinCE and Joost (it's creator) said there is no reason to make them compilable on that system due to the fact that no mysqlclient.dll exists for that kind of OS.

The only way to make that work would be to cross-compile mysqlclient.dll for ARM architecture, the dll should be open source like the software, but honestly I don't know if that is possible and with wich kind of software, nor I know if it could just... work.


I have found the ZEOSDBO-6.6.1_beta <http://garr.dl.sourceforge.net/sourceforge/zeoslib/ZEOSDBO-6.6.1_beta.zip> package.

With this package you can to connect to the remote database (I am not sure).

But it do not compiles under WinCE :(



2007/11/12, "Leonardo M. Ramé" <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>:

    Daniel Rincón García escribió:
    > I already know how to connect to the database if it is in the
    hard disk,
    > but I do not know how to connect to the database if it is in the web
    > server.

    Sorry, but you can't. Sqlite isn't a database server, its a
    local/embedded database.

    Leonardo.


    _________________________________________________________________
         To unsubscribe: mail [EMAIL PROTECTED]
    <mailto:[EMAIL PROTECTED]> with
                    "unsubscribe" as the Subject
       archives at http://www.lazarus.freepascal.org/mailarchives


------------------------------------------------------------------------

No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.30/1125 - Release Date: 11/11/2007 21.50

_________________________________________________________________
    To unsubscribe: mail [EMAIL PROTECTED] with
               "unsubscribe" as the Subject
  archives at http://www.lazarus.freepascal.org/mailarchives

Reply via email to