In some tasks we need to know how many users are connected to the database. And even which users are connected… There is an interesting piece of code with which you may achieve this this. It is an additional source file written for ZeosDBO 6.1.3 library. It only works with Firebird 1.5. But it can be easy modified for another Firebird/Interbase server.
This little article shows how to access Firebird databases by using the ZEOS component Library in version 6.1.5 (including Patches 1&2) and how to use these components in database applications. It does not matter if you use the “real” SQL-Server or the embedded version which is restricted to local held databases. A couple of examples (also migrated Delphi-BDE demos) shall explain how to use the ZEOS components.
I was very surprised realizing that my Win 32 Lazarus+Firebird embedded application can be installed and running on PCBSD (www.pcbsd.org) OS under Wine. Although I couldn’t install Win32 Firebird server, it seems that embedded server (consists of .dll files) works OK! One more option for multiplatform pograming…
Here are some steps needed for developing on that platform
fb_embedded2.pas is a Pascal unit that can be included in a Lazarus project to enable embedding of Firebird database server into an .exe file. It reads lib from memory stream. No installation is required. Just copy the content of this folder into your project directory and include fb_embedded2.pas into your application.
Here is the poll on Lazarus web site