Recent

Author Topic: WinCE:what DB are supported ?  (Read 5878 times)

mirce.vladimirov

  • Full Member
  • ***
  • Posts: 220
WinCE:what DB are supported ?
« on: November 16, 2012, 12:03:07 am »
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

  • Sr. Member
  • ****
  • Posts: 297
Re: WinCE:what DB are supported ?
« Reply #1 on: November 16, 2012, 05:13:11 am »
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

  • New Member
  • *
  • Posts: 14
Re: WinCE:what DB are supported ?
« Reply #2 on: November 16, 2012, 10:56:17 am »

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: WinCE:what DB are supported ?
« Reply #3 on: November 16, 2012, 11:18:24 am »
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:
Quote
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.
« Last Edit: November 16, 2012, 11:23:00 am by BigChimp »
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

dago71

  • New member
  • *
  • Posts: 9
Re: WinCE:what DB are supported ?
« Reply #4 on: December 12, 2012, 01:41:36 am »
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.
Try not to become a man of success but rather to become a man of value.
Albert Einstein