Setting up Firebird RDBMS under Windows 64

Download the latest installer ( https://www.firebirdsql.org/en/firebird-3-0/#Win64 )

And then the ODBC driver ( https://firebirdsql.org/en/odbc-driver/ )

Create a database using the ISQL command line tool ( https://www.firebirdsql.org/pdfmanual/html/isql-create-database.html )

C:\Program Files\Firebird\Firebird_3_0\isql

Use CONNECT or CREATE DATABASE to specify a database
To create a database named monkey.fdb and store it in a directory named test on your C drive:

SQL>CREATE DATABASE 'C:\Users\Graham\Documents\rebol.fdb' page_size 8192
CON>user 'SYSDBA' password 'masterkey';

Note

In the CREATE DATABASE statement it is mandatory to place quote characters (single or double) around path, user name and password.

When running Classic Server on Linux, if the database is not started with a host name, the database file will be created with the Linux login name as the owner. This may cause access rights to others who may want to connect at a later stage. By prepending the localhost: to the path, the server process, with Firebird 2.0 running as user firebird, will create and own the file.

To test the newly created database type:

SQL>SELECT RDB$RELATION_ID FROM RDB$DATABASE;

RDB$RELATION_ID
===============
128

SQL> commit;

To get back to the command prompt type quit; or exit; .

ODBC

Substitute your own account name for Graham :slight_smile:

Create a user DSN in the ODBC Data Source Administrator (64bit)
Select the Firebird/Interbase Driver
Use rebol in the DSN
And c:\Users\Graham\Documents\REBOL.FDB for the Database
Database account is SYSDBA and password is masterkey

Click on Test Connection to make sure it's all working. Then click on OK to save it.