Connect firebird with android mobile system

505 views
Skip to first unread message

Learn Softwares

unread,
Feb 14, 2024, 7:19:54 PM2/14/24
to firebird-support
Is there any component in Delphi to make this connection? OR how can it be done by code?

Dimitry Sibiryakov

unread,
Feb 15, 2024, 4:38:53 AM2/15/24
to firebird...@googlegroups.com
Learn Softwares wrote 15.02.2024 1:19:
> Is there any component in Delphi to make this connection? OR how can it be done
> by code?

FireDac:
http://docwiki.embarcadero.com/RADStudio/Alexandria/en/Mobile_Tutorial:_Using_FireDAC_in_Mobile_Applications_(iOS_and_Android)
ISC API: http://www.ibphoenix.com/files/60ApiGuide.zip
Firebird OO API:
https://github.com/FirebirdSQL/firebird/blob/master/doc/Using_OO_API.html

--
WBR, SD.

Learn Softwares

unread,
Feb 15, 2024, 4:56:05 AM2/15/24
to firebird...@googlegroups.com
thanks, but i need to connect using Drive ID = FB not SQLite...

For FB is not working...

I have tried looking in internet a solution but i could not find it.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/5def9c6f-2983-4671-b779-73fd4ec6900b%40ibphoenix.com.


--

Atenciosamente,

Learn Softwares ®

Dimitry Sibiryakov

unread,
Feb 15, 2024, 4:59:51 AM2/15/24
to firebird...@googlegroups.com
Learn Softwares wrote 15.02.2024 10:55:
> thanks, but i need to connect using Drive ID = FB not SQLite...

Did you try exactly the same approach as in desktop environment? I supposed
you was able to install Firebird client on Android and tested isql connection
successfully.

--
WBR, SD.

Learn Softwares

unread,
Feb 15, 2024, 11:05:52 AM2/15/24
to firebird...@googlegroups.com
the Firebird database will be localhost and android will just insert data. How to make?

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.


--

Atenciosamente,

Learn Softwares ®

Dimitry Sibiryakov

unread,
Feb 15, 2024, 11:08:44 AM2/15/24
to firebird...@googlegroups.com
Learn Softwares wrote 15.02.2024 17:05:
> the Firebird database will be localhost and android will just insert data. How
> to make?

Doesn't matter. There is no difference between Firebird usage from any
platform. Just do what you have done on PC.

--
WBR, SD.

Karol Bieniaszewski

unread,
Feb 15, 2024, 11:20:07 AM2/15/24
to firebird...@googlegroups.com

I'm not at work right now, but when I return and if I don't forget, I'll check how I do it.

If I remember correctly, you need to disable InterbaseToGo in one ini file of Firedac and set the Firebird environment variable.

I don't remember off the top of my head which ini file it is and what the variable is, but maybe this will give you a lead before I can check.

 

Regards,

Karol Bieniaszewski

Piergiorgio Valli

unread,
Feb 15, 2024, 2:10:26 PM2/15/24
to firebird...@googlegroups.com
Hi,

I used Qt c++ to test Firebird 5 on Android 13 but for Delphi

three environment variable are important.

1. FIREBIRD
2. FIREBIRD_TMP  //writable location
3. FIREBIRD_LOCK //writable location

The libs folder of Android is read only so it copies configuration file in an writable  location.

Symbolic link are not necessary.
Pier


Learn Softwares

unread,
Feb 16, 2024, 4:22:04 AM2/16/24
to firebird...@googlegroups.com
please verify to me... i could not to do that... tks



--

Atenciosamente,

Learn Softwares ®

Karol Bieniaszewski

unread,
Mar 2, 2024, 3:43:24 AM3/2/24
to firebird...@googlegroups.com

I forgot about you. Below are the steps you need to take to be able to connect from Delphi + Firedac to Firebird. I use Firebird 3, but it will probably be similar.

 

  1. Setup FDPhysFBDriverLink1.VendorLib to libfbclientembed.so (it is renamed fbclient).
  2. Setup environment variable FIREBIRD_LOCK to point to Firebird directory.
  3. Look for Firedac.inc and dissable static linking look for „IbTogo”

 

I name firebird dir as „fb” and point to „........fb/lib/libfbclientembed.so”. Remember about full paths.

 

Below my deployment tree:

Marsupilami79

unread,
Mar 2, 2024, 6:37:58 AM3/2/24
to firebird...@googlegroups.com
Hello,

the upcoming Zeos 8 supports connecting to Firebird from Delphi on Android.
- checkout Zeos 8 from https://svn.code.sf.net/p/zeoslib/code-0/branches/8.0-patches
- alternate: use th 8.0-patches branch from https://github.com/marsupilami79/zeoslib
- check the Android example in the examples directory
- see https://sourceforge.net/p/zeoslib/wiki/How%20to%20use%20Firebird%204.0%20with%20Zeos%20on%20Android/

best regards,

Jan



Am 15.02.2024 um 01:19 schrieb Learn Softwares:
Is there any component in Delphi to make this connection? OR how can it be done by code?
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

Learn Softwares

unread,
Mar 2, 2024, 11:09:02 AM3/2/24
to firebird...@googlegroups.com
Connect to mobile, isnt it?

De: 'Karol Bieniaszewski' via firebird-support <firebird...@googlegroups.com>
Enviado: Saturday, March 2, 2024 5:43:15 AM
Para: firebird...@googlegroups.com <firebird...@googlegroups.com>
Assunto: [firebird-support] Connect firebird with android mobile system
 

Karol Bieniaszewski

unread,
Mar 2, 2024, 12:40:17 PM3/2/24
to firebird...@googlegroups.com

>> Connect to mobile, isnt it?

 

I do not understand your question. You can connect to Firebird embedded on the e.g. phone and db is also on the phone.

You can also connect to remote Firebird, but from phone it is rather unusual.

 

Regards,

Karol Bieniaszewski

 

Od: Learn Softwares
Wysłano: sobota, 2 marca 2024 17:08
Do: firebird...@googlegroups.com
Temat: Re: [firebird-support] Connect firebird with android mobile system

 

Connect to mobile, isnt it?

Learn Softwares

unread,
Mar 3, 2024, 5:52:35 AM3/3/24
to firebird...@googlegroups.com
DB on the phone i know. I want the DB outside phone, for instance in a remote server and de app on the phone (app designed by delphi)
De: 'Karol Bieniaszewski' via firebird-support <firebird...@googlegroups.com>
Enviado: Saturday, March 2, 2024 2:40:10 PM
Para: firebird...@googlegroups.com <firebird...@googlegroups.com>
Assunto: ODP: [firebird-support] Connect firebird with android mobile system
 

>> Connect to mobile, isnt it?

 

I do not understand your question. You can connect to Firebird embedded on the e.g. phone and db is also on the phone.

You can also connect to remote Firebird, but from phone it is rather unusual.

 

Regards,

Karol Bieniaszewski

 

Od: Learn Softwares
Wysłano: sobota, 2 marca 2024 17:08
Do: firebird...@googlegroups.com
Temat: Re: [firebird-support] Connect firebird with android mobile system

 

Connect to mobile, isnt it?

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

Learn Softwares

unread,
Mar 3, 2024, 7:23:54 AM3/3/24
to firebird...@googlegroups.com
And using Firedac connectiion? DB not on the phone… DB on a remote server
De: 'Marsupilami79' via firebird-support <firebird...@googlegroups.com>
Enviado: Saturday, March 2, 2024 8:35:51 AM
Para: firebird...@googlegroups.com <firebird...@googlegroups.com>
Assunto: Re: [firebird-support] Connect firebird with android mobile system
 

Dimitry Sibiryakov

unread,
Mar 3, 2024, 7:25:59 AM3/3/24
to firebird...@googlegroups.com
Learn Softwares wrote 03.03.2024 13:23:
> And using Firedac connectiion? DB not on the phone… DB on a remote server

It doesn't matter. The only difference is in connection string that includes
TCP/IP address or host name.

--
WBR, SD.

Learn Softwares

unread,
Mar 3, 2024, 7:34:41 AM3/3/24
to firebird...@googlegroups.com
Using Firedac connection ok when you deploy on a desktop/notebook. Using deploy on a phone the DB not Connect and not appear on a phone screen.
De: 'Dimitry Sibiryakov' via firebird-support <firebird...@googlegroups.com>
Enviado: Sunday, March 3, 2024 9:25:56 AM

Para: firebird...@googlegroups.com <firebird...@googlegroups.com>
Assunto: Re: [firebird-support] Connect firebird with android mobile system
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

Karol Bieniaszewski

unread,
Mar 3, 2024, 9:09:51 AM3/3/24
to firebird...@googlegroups.com

To connect to db on phone i post previously what to do.

 

Regards,

Karol Bieniaszewski

 

Od: Learn Softwares
Wysłano: niedziela, 3 marca 2024 13:34
Do: firebird...@googlegroups.com
Temat: Re: [firebird-support] Connect firebird with android mobile system

 

Using Firedac connection ok when you deploy on a desktop/notebook. Using deploy on a phone the DB not Connect and not appear on a phone screen.

De: 'Dimitry Sibiryakov' via firebird-support <firebird...@googlegroups.com>
Enviado: Sunday, March 3, 2024 9:25:56 AM
Para: firebird...@googlegroups.com <firebird...@googlegroups.com>
Assunto: Re: [firebird-support] Connect firebird with android mobile system

 

Learn Softwares wrote 03.03.2024 13:23:
> And using Firedac connectiion? DB not on the phone… DB on a remote server

   It doesn't matter. The only difference is in connection string that includes
TCP/IP address or host name.

--
   WBR, SD.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/ed96973a-5995-4819-9e65-e09b97a96ca3%40ibphoenix.com.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

Reply all
Reply to author
Forward
0 new messages