Firebird
Firebird is an open source relational database management system.
There are different technologies you can use to access Firebird from web applications developed with HTML5 Builder:
- The Database component, documented below. Requirements: client and PHP PDO extension.
- PHP functions, documented here. Requirements: client and PHP extension.
Contents
Installation
Client
- Download the server package (as a .zip archive) from here.
- Extract the fbclient.dll file into the following paths of the installation directory, replacing the existing files:
- For HTML5 Builder’s internal server, so you can run the application from HTML5 Builder: php\fbclient.dll, apache\bin\fbclient.dll.
- For the Data Explorer: bin\fbclient.dll.
Warning: HTML5 Builder supports both Firebird and InterBase, but it cannot support both at the same time. By installing the Firebird client, you are disabling InterBase. To enable back InterBase, replace the fbclient.dll instances with a copy of the InterBase library.
PHP PDO Extension
Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):
;extension=php_pdo_firebird.dll→extension=php_pdo_firebird.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
PHP Extension
Enable the extension by uncommenting (removing the ; at the beginning) the following line in PHP’s configuration file (php.ini):
;extension=php_interbase.dll→extension=php_interbase.dll
- For HTML5 Builder’s internal server, apply the changes to the php.ini.template file.
Configuration
Tip: You can use the Data Explorer to configure your Firebird connections the RAD way.
To use a Database component with Firebird, configure it with the following property values:
- DriverName: firebird.
- DatabaseName: This should be filled with the database server address and database file path, separated by a colon (:). For example: localhost:C:\Users\User\Desktop\database.gdb.
Then fill the rest of the mandatory properties as required. You can ignore the Host property.
Help Resources
Documentation
Frequently Encountered Problems
Undefined service gds_db/tcp
- Warning: ibase_pconnect(): Unable to complete network request to host "<host IP>". Failed to locate host machine. Undefined service gds_db/tcp. in […]
There is an entry on the Firebird FAQ for the error message above.