WinCE:what DB are supported ?

[mirce.vladimirov]

Which databases are supported on WinCE ?
Is SQLite the only supported DB to work with Lazarus on WinCE ?
Is it possible to connect to a DB server in a LAN via Wi-Fi (perhaps with ODBC) ?
Is it possible to connect to a DB server in a WAN via Wi-Fi or GSM (perhaps with ODBC) ?
This would be great if want real-time transactions.

[goodname]

Have gotten SQLite to work on WinCE. There are memory databases such as TBufDataSet and TMemDataset that work. The file based TDbf and TSDFDataSet will likely work but have not tried them.

Don't know if it is possible to connect directly to a database server such as FireBird or PostgreSQL. Know that it is possible to build a middle ware program to connect to both.

[Tankard]

http://libpqwce.projects.pgfoundry.org/

for postgres support

[BigChimp]

Couldn't find anything for Firebird; unfortunately this:
http://web.firebirdsql.org/dotnetfirebird/embedded-firebird-in-dotnet-faq.html
seems to indicate nobody has ported the client to Windows CE...

Edit:

The file based TDbf and TSDFDataSet will likely work but have not tried them.

SDFDataset will likely not work:
http://bugs.freepascal.org/view.php?id=17871
Haven't looked for bugs with TDBF on Windows CE/Windows Mobile.

[dago71]

little offtopic, but i think that for realtime from wince, webservices is the way to go.

ODBC is too unreliable with weak connections and usually (at least me) we develop for wince on motorola/symbol devices to be used in a warehouse... wifi doesn't always work there, so you want to be on the safe side when dealing with the customer databases.

just my 2 cents.