Firebird

From HTML5 Builder
Jump to: navigation, search

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:

Installation

Client

  1. Download the server package (as a .zip archive) from here.
  2. 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.dllextension=php_pdo_firebird.dll

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.dllextension=php_interbase.dll

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.

See Also

Personal tools