Firebird usage notes

Windows
After installation:
Manager preset: Name: sysdba, password: masterkey

Firebird. conf
TCP/IP Settings
Remoteservicename = gds_db
Remoteserviceport = 3050
Online alias method: aliases. conf
SERVER_NAME: aliasname

Bin directory command set
C: // gsec-user sysdba-Password masterkey
Change the password (8 characters in length): Modify sysdba-PW ********
Add User: Add user1-PW ******
Delete user1
Go to the SQL console:ISQL-User sysdba-Password masterkey

PHP connection Firebird
Firebird PHP newsgroup: http://tech.groups.yahoo.com/group/firebird-php/

Gds32.dll (Firebird server) copy to C:/Windows/system32

PHP. ini
Extension = php_pdo.dll
Extension = php_interbase.dll

$ Strconnect = 'H:/bin/Firebird/test. fdb ';
If (! ($ Link = ibase_connect ($ strconnect, 'sysdb', 'pass000000', 'iso8859 _ 1', 0, 1 )))
Die ('could not connect: '. ibase_errmsg ());
$ Query = ibase_prepare ($ link, 'insert into data (ID) values (?) ');
$ Newid = 3;
Ibase_execute ($ query, $ newid );
$ SQL = "select * from data ";
$ Results = ibase_query ($ link, $ SQL) or die (ibase_errmsg ());
While ($ ROW = ibase_fetch_assoc ($ results )){
Echo $ row ['id']. '<br> ';
}
Ibase_free_result ($ results );
Ibase_close ($ link );

Delphi