Laz4Android Firebird

[SteenJorgensen]

I have build a app. in Laz4android and this works fine. Now i must have a connection to my Firebird SQl  server, and this give me trouble.
When i try to connect to the sql-server with "IBConnection1.Connected := True" the app. crash.

Have any one done this before? Or even better if there is a persoen out there who have a litle slip of code?

Thanks
Steen

[Leledumbo]

To do this, your app must open a socket connection. Did you write the permission in AndroidManifest.xml?

[SteenJorgensen]

My Manifest.xml allow internet with:
    <uses-permission android:name="android.permission.INTERNET" />
I think this is ok?.

When i try to connection := true i get:
InOutError with the tekst "Can not load default Firebird client (libfbclient.so.2.5) or (......"

I can see that i must have the fb-client (as i windows), but can't find this client on internet. and where am i going to put this?

As you can see i a novice in this Android 

[Leledumbo]

I think this is ok?

Yes, your problem is not there.

I can see that i must have the fb-client (as i windows), but can't find this client on internet. and where am i going to put this?

Guess you have to build one from source yourself, as Firebird doesn't provide official binaries. I'm not sure whether they support Android or not anyway. You'll have to put the libraries in the same directory as your app .so.

[LA.Center]

You would have to build Firebird client for your Android device. Instead I would suggest that you create a middle-bridge for your Android.

Android -> XML/HTTP Server -> Firebird Server
Firebird Server -> XML/HTTP Server -> Android

[SteenJorgensen]

uhhhhhh 

There most be someone who have this libfbclient.so file i can use?

[BigChimp]

Perhaps. AFAIU porting efforts to Android may have started; I've never heard that they were finished.

Let us know when you found it so we can update the wiki page http://wiki.lazarus.freepascal.org/Firebird_in_action#Overview

I would go with PlusPlus' advice (or use JSON instead of XML but it's much the same thing); you can use e.g. fcl-web or brook framework server-side. It's better not to expose database ports directly to the internet anyway, especially because of Firebird's 8 character password limit and default plain text protocol.

[LA.Center]

absolutely correct BigChimp, firebird should be behind the DMZ, firebird in that sense has not the most secure login structure.

I have used this model myself, and once you have the middle bridge running you can connect anything that supports http protocol, including legacy mobile devices.

Just as a info:

I have actually only two commands.
1. SQL_QUERY that returns a xml data packet
2. SQL_EXECUTE which is for sql statement that don't return a dataset

Plus a very simple error checking. which returns SQL_OK or SQL_ERROR and the message.

works perfect, and the main advantage is you don't have to distribute any client software.

[SteenJorgensen]

Hi, and thanks for answer.

I can see the idea of ​​using a bridge. Mostly due to the safety!

But i am not quite sure about how this code should be built up. Do you have a bite of code for examble?

[mariuz]

I think this is ok?

Yes, your problem is not there.

I can see that i must have the fb-client (as i windows), but can't find this client on internet. and where am i going to put this?

Guess you have to build one from source yourself, as Firebird doesn't provide official binaries. I'm not sure whether they support Android or not anyway. You'll have to put the libraries in the same directory as your app .so.

You can download now Firebird Client 3.0 Alpha 2 for Android and include it in your project
http://www.firebirdnews.org/?p=9283
I need some testers   

[looksmallthinkbig]

Hey mariuz, I'd love to test your software! It's actually exactly in line with what I've recently been trying to do. My only question is, your source code doesn't seem to be on that site anymore. Is there anywhere else I might be able to find it?

[mariuz]

I have moved my server to a better location , now is up and can be tested