In order to use Telerik Data Access with the Firebird database server you need the following components installed and configured:
- Firebird Server (Telerik Data Access has been tested on Firebird Server Version 2.1.3). Firebird can be downloaded from its web site, under the Download section.
- Firebird ADO.Net driver 18.104.22.168. The Telerik Data Access support for Firebird relies on the ADO.Net driver.
The driver can be found here. It allows the usage of a remote Firebird server.
The server name to be specified is the name of the machine, where your server has been installed. The database name should either be the absolute path + the name of the database on the server machine for e.g., D:\Firebird_2_0\example_DB\test.fdb, or an alias defined on the server machine. Telerik Data Access uses the genericADO2 driver (default) for connecting to Firebird.
Using integrated security is not supported for Firebird. The default user name and password for Firebird is "SYSDBA" and "masterkey". You need to either specify these values or use another user name and password; the user must exist in the database then.
Telerik Data Access creates databases with the "UTF8" character set and it also connects to databases using this character set. If another character set is required, the ConnectionParams setting must include a "Charset=XXX" setting, where XXX is a character set known to Firebird. And one more thing, for Firebird only SQL Dialect 3 databases are supported with Telerik Data Access.
If you want to use the embedded version of the Firebird database, the following steps should be kept in mind:
- Download Embedded Firebird for Windows from the Firebird site.
- Instructions for installing the embedded server are present in the Firebird_v2.0.1.ReleaseNotes.pdf (Section 16. Installation Notes: Updated Notes for Windows Embedded).
- Copy the dlls mentioned in the above document into the bin/debug folder of your application.
In case of the embedded Firebird server, the server name will appear as "localhost" and the database name would either be the absolute path + the name of the database, for e.g., D:\Firebirddb\test.fdb, or an alias defined on the machine.
Telerik Data Access has been tested with the 2.1.3 version of Firebird.
In this section: