30 8.9. Stream of BLOB data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 9. Services. . . . . . . . . . . . . Reading row data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Appendix A: External Data Representation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 Appendix B: Data types. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

user, e.g. firebird. This limits the damage in case of malfunctioning (by hack or otherwise). No Services Manager. Tasks like backup/ restore, user management, stats etc. have to be performed locally using with Firebird. Features a Services Manager enabling you to perform certain tasks (backup/restore, user management, stats, etc.) programmatically. You can connect to the Services Manager over the network architecture later; your applications and databases will keep functioning (except if they call the Services Manager and you switch to Classic). Superserver download packages start with FirebirdSS, Classic

.............................................................................. 24 Protecting your data ................................................................................................. choose to let it run as an application. Non-server Windows systems – 95, 98 and ME – don't support services; running as an application is the only option there. Use the Guardian? The Firebird Guardian is convenience rather than a necessity, since these operating systems have the facility to watch and restart services. It is recommended that you keep the Guardian option on (if possible) in all other situations.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 7. Protecting your data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SuperClassic or Superserver mode. However, since Windows has the facility to watch and restart services, there is no reason to use the Guardian if Firebird runs as a service (which it should). The Guardian Use Win + R , type services.msc followed by Enter or [ OK ], or click [ Start ] (or Win ) and search for “Services” and open the “Services” app. This illustration shows the Services applet display on

Sicherungs- und Wiederherstellungsaufgaben jedoch auch remote über den Services Manager ausgeführt werden. • Wird der Services Manager nicht verwendet (ab Firebird 2.5+), erfordert das Sichern mit nbackup database [backupfile] Angenommen, die Datenbank befindet sich in C:\Data und nbackup.exe befindet sich im Windows- Suchpfad: C:\Data> nbackup -B 0 inventory.fdb inventory_1-Mar-2006.nbk Oder, wenn Firebird 5) zum Beispiel unter einem anderem Port als dem Standard läuft: C:\Data>nbackup -B 0 localhost/3051:C:\Data\inventory.fdb C:\Data\inventory-level-0- Jul-2020.nbk -user SYSDBA -pass masterkey In Firebird

Note in V.2.1 Metadata Need to be Upgraded If your databases contain text BLOBs storing non-ASCII data then the backup/restore cycle is not enough to upgrade them to ODS 11.1. Please pay attention to the • User accounts can now be configured only by using the Services API or the gsec utility. • For backing up the security database, the Services API is now the only route. You can employ the - se[rvice] (V.2.1) Malformed UTF8 strings and text blobs are no longer allowed. This affects not just user data but also the metadata stored in the system tables. There is a metadata script to enable you to upgrade

«Классический» вари- ант под Linux, кроме того, он менее надежный. В версии 1.5 частично реализован Services Manager, поддерживающий операции ти- па резервирования/восстановления, оста- нов базы данных и т пользуя отдельные утилиты, поставляемые вместе с Firebird. В версии 1.5.1 Services Manager реализован полностью. Полноценный Services Manager, позволяющий программ- но осуществлять операции по управлению останов базы данных, управление пользователями, получение статистики и т.д.). Вы можете подключиться к Services Manager по сети и, соответствен- но, выполнять эти операции удаленно. Поддерживается SMP (Symmetrical

security database. Firebird 1.5 Error Codes Updated 04/30/04 p. 2 -103 335544571 dsql_constant_err Data type for constant unknown -104 335544343 invalid_blr Invalid request BLR at offset -104 , encountered ) -171 335544618 return_mode_err Return mode by value not allowed for this data type -172 335544438 funnotdef Function is not defined -203 335544708 dyn_fld_ambiguous text_subtype Implementation of text subtype not located. -204 335544573 dsql_datatype_err Data type unknown -204 335544580 dsql_relation_err Table unknown -204 335544581 dsql_procedure_err Procedure

error_updating_sec_db An error occurred while updating the security database. -103 335544571 dsql_constant_err Data type for constant unknown -104 336003075 dsql_transitional_numeric Precision 10 to 18 changed from (expected %ld, encountered %ld) -171 335544618 return_mode_err Return mode by value not allowed for this data type -172 335544438 funnotdef Function %s is not defined -203 335544708 dyn_fld_ambiguous Ambiguous 335544568 text_subtype Implementation of text subtype %d not located. -204 335544573 dsql_datatype_err Data type unknown -204 335544580 dsql_relation_err Table unknown -204 335544581 dsql_procedure_err Procedure

while updating the security Firebird 2.1 Error Codes database. -103 335544571 dsql_constant_err Data type for constant unknown -104 336003075 dsql_transitional_numeric Precision 10 to 18 changed from -171 335544618 return_mode_err Return mode by value not allowed for this data type -171 335544873 array_max_dimensions Array data type can use up to @1 dimensions -172 335544438 funnotdef Function @1 is 335544568 text_subtype Implementation of text subtype @1 not located. -204 335544573 dsql_datatype_err Data type unknown -204 335544580 dsql_relation_err Table unknown -204 335544581 dsql_procedure_err Procedure