Hi!

We are trying to make a simple version of our app (currently using DBISAM
database engine) for iOS and MacOS and we have discovered that Delphi XE4
includes FireDAC, which allows to connect to whatever database engine
natively or through ODBC driver.

As DBISAM has its own ODBC driver, I'm hoping it is possible to make an
iOS/MacOS application which connects with FireDAC to a remote ODBC
driver/server.

Do anyone know if this is possible? We are interested in upgrading to XE4,
but only if this is true.
I have read that FireDAC can even connect to DBase files using ODBC, so I
think it's the same!

Thanks!

Luis C.
www.SimplyGest.es

On 7/31/2013 8:13 AM, Luis Conception Gonzalez wrote:
> As DBISAM has its own ODBC driver, I'm hoping it is possible to make an
> iOS/MacOS application which connects with FireDAC to a remote ODBC
> driver/server.
> Do anyone know if this is possible? We are interested in upgrading to
> XE4, but only if this is true.
> I have read that FireDAC can even connect to DBase files using ODBC, so
> I think it's the same!

I'm not using it so have no first hand experience so rest are just some
educated guesses.

I'd say this is bit more complex than that. Yes, firedac does include
odbc bridge drivers but clearly those are windows only so those cannot
be run on iOS (firedac on iOS can obviouly talk to sqlite but that's
local DBs).

Hence the question on iOS is how would the firedac communicate with the
windows server? As far as i know there is no firedac generic bridge
server available nor can you can run dbisam server since you'd still
need the odbc there somewhere.

The way to us it is likely to use datasnap back end talking to dbisam
over odbc bridge (e.g. iOS+firedac<-> datasnap <-> firemonkey odbc
bridge <-> dbisam). I know there is some datasnap support in firedac but
i'd say you should try it out before you buy as it's little muddy in my
view.

Using a also a more generic approach so you could use RemObjects DA or
even custom back end - that likely would not be as seamless though if
you intent to witch fully to firemonkey+firedac both both exsiting app
and iOS app.

Raul