Firebird support

[RodMG]

Hi,

¿Does any one has experience ussing Firebird?

I'm evaluating RunRev and I'm looking for a multiplatform. I have an app wich works in single and multiuser, now I want to develope it ussing RunRev but I need to get building a single install wich installs the app and the database in a single process.

Any idea is wellcome.

Regards,

Rodolfo MG

[Mark]

Hi Rodolfo,

It looks like you want to embed Firebird in your app. Why do you want to use Firebird? Can you use an alternative database?

You need to install Firebird separately, after which you can access it from your software. You could create an installer, which installs both Firebird and your own application. People will still notice that the Firebird installer runs, unless you compile your own Firebird software + installer.

Although LiveCode doesn't support Firebird, it is possible to connect to it through sockets (very complicated) or the iSQL command line utility (relatively easy but still difficult).

If your multi-user application needs to connect to Firebird on a server, I'd use PHP as a layer between LiveCode and Firebird. This is pretty much a fail-safe way to make LiveCode talk to Firebird. Naturally, PHP will need to be configured to communicate with Firebird. Once PHP has been configure correctly, you can use PHP's native Firebird/Interbase commands to communicate with the database. This is extremely useful.

As far as I know, the ONLY existing database driver that is supported by LiveCode and can be included with your standalone without needing additional software is SQLite. All other databases are located on a (local) server and need additional software to be installed.

Kind regards,

Mark

[bangkok]

Although LiveCode doesn't support Firebird, it is possible to connect to it through sockets (very complicated) or the iSQL command line utility (relatively easy but still difficult).

I wouldn't be so sure...

Firebird has ODBC drivers.... Therefore, LiveCode should be able to access the DB, thanks to the ODBC driver.

You need to give it a try.

(I use LiveCode to connect to FileMaker database, through ODBC. It's working fine)

[Mark]

Hi Bkk,

Is the ODBC feature installed with Firebird by default?

Mark

[bangkok]

Is the ODBC feature installed with Firebird by default?
Mark

i've got no idea. I just was on their website that you can download ODBC drivers.

http://www.firebirdsql.org/en/odbc-driver/

[Mark]

Hi,

I saw those too, but I haven't tried them. The default option seems to be to connect to Firebird through a local access point or through sockets. The ODBC driver seems to be an intermediate that connects an ODBC client to either one.

Kind regards,

Mark