Now that you have created your ODBC DSN entries, you can use this with the Xojo ODBC plugin to connect to the database. If so, you are now ready to connect using Xojo. Click the “Test Connection” button to verify that everything is correct. Use “SYSDBA” for the Database Account and “masterkey” as the password. After installing the ODBC drivers, you can go to the ODBC Control Panel and add a data source by selecting the Firebird/Interbase driver from the list.įor the DSN name, use “FirebirdEmbeddedTest”.įirebird includes a sample database, which should be located here:Ĭ:\Program Files\Firebird\Firebird_3_0\examples\empbuild\EMPLOYEE.FDBĬopy this file to the Desktop.
Xojo database example install#
If you did not already install the ODBC drivers from above, you will need to do so now. This code supplies a blank DataSource property, which prompts the user for the DSN using the system dialog: You can have your app prompt the user to choose a DSN using the operating system browser for selecting a DSN or you can supply the name of the DSN manually. You can use the DSN to connect to the database in conjunction with the ODBCDatabase class in two ways. This results in a DSN (Data Source Name). Consulting the docs for your Linux distribution. On Linux, you may have to edit configuration files. In this tool you install the ODBC driver and enter the necessary credentials to connect to the database. On Mac, you use the ODBC Administrator app in the Application/Utilities folder. On Windows you use the ODBC Data Source Administrator in the Control Panel or Settings. The first thing you need to do is configure the ODBC driver using the appropriate ODBC configuration tool for your operating system.
How you connect to an ODBC database depends on the database you are using.