the Firebird server: • The Firebird server executable. • A client library located on the server machine. • The command-line tools. • The standard user-defined function libraries. • A sample database InterBase. Hence, it is not possible to run both a Firebird server and an In- terBase server on the same machine with these versions - at least not at the same time. This restric- tion has been removed in Firebird you create or connect to – must reside on a hard drive that is phys- ically connected to the host machine. You cannot locate components of the server, or any database, on a mapped drive, a filesystem share

you create or connect to – must reside on a hard drive that is physically connected to the host machine. You cannot locate components of the server, or any database, on a mapped drive, a filesystem share 11 Installing multiple servers Firebird 2 allows the operation of multiple servers on a single machine. It can also run concurrently with Firebird 1.x or InterBase servers. Setting this up is not a beginner's installation If everything works as designed, the Firebird server process will be running on your server machine upon com- pletion of the installation. It will also start up automatically whenever you restart your

you create or connect to — must reside on a hard drive that is physically connected to the host machine. You cannot locate components of the server, or any database, on a mapped drive, a filesystem share a single machine. It can also run concurrently with Firebird 1.x or InterBase servers. Setting this up is not a beginner’s task though. If you need to run multiple servers on the same machine, the second network, then before testing the Firebird server itself, you may want to verify that the server machine is reachable from the client at all. At this point, it is assumed that you will use the TCP/IP network

Embedded are all the same Firebird engine. The differences are in the ways the server module uses machine and network resources. Briefly: • Classic runs a stub process named fb_inet_server.exe on Windows key to locate the correct version of Firebird that they wish to use. The new key is: HKEY_LOCAL_MACHINE\SOFTWARE\Firebird Project\Firebird Server\Instances Firebird will guarantee that one entry Manual or automatic? With the automatic option, Firebird will start up whenever you boot the host machine. With the manual option you can start the server on demand from the Services applet in the Settings/Control

defined as an external table must be located on a storage device that is physically present on the machine where the Firebird server runs and, if the parameter ExternalFileAccess in the firebird.conf configuration SET STATISTICS INDEX IDX_UPDATER; See also CREATE INDEX, ALTER INDEX 5.6. VIEW A view is a virtual table that is actually a stored and named SELECT query for retrieving data of any complexity. Data optionally followed by a table alias and/or column aliases. The result set of the statement acts as a virtual table which the enclosing statement can query. Syntax () [[AS] derived-table-alias]

file %s Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -901 335740993 gfix_mem_exhausted Virtual memory exhausted -901 336330818 gbak_open_error Cannot open status and error output file %s -901 %s does not have an associated executable -901 335544704 net_lookup_err Failed to locate host machine. -901 335544705 service_unknown Undefined service %s/%s. -901 335544706 host_unknown The specified filter. -901 335544768 exception_access_violation Access violation.The code attempted to access a virtual address without privilege to do so. -901 335544769 exception_datatype_missalignme nt Datatype misalignment

exceeds maximum size -901 335740992 gfix_corrupt_pool Corrupt pool -901 335740993 gfix_mem_exhausted Virtual memory exhausted -901 336330817 gbak_open_bkup_error Cannot open backup file @1 -901 335740994 Service @1 does not have an associated executable -901 335544704 net_lookup_err Failed to locate host machine. -901 335544705 service_unknown Undefined service @1/@2. -901 335544706 host_unknown The specified filter. -901 335544768 exception_access_violation Access violation.The code attempted to access a virtual address without privilege to do so. -901 335544769 exception_datatype_missalignment Datatype misalignment

Firebird 4.0 provides a number of features to discover time zone information. Virtual table RDB$TIME_ZONES A virtual table listing time zones supported in the engine. See also RDB$TIME_ZONES in System defined as an external table must be located on a storage device that is physically present on the machine where the Firebird server runs and, if the parameter ExternalFileAccess in the firebird.conf configuration SET STATISTICS INDEX IDX_UPDATER; See also CREATE INDEX, ALTER INDEX 5.6. VIEW A view is a virtual table that is actually a stored and named SELECT query for retrieving data of any complexity. Data

-901 335740992 gfix_corrupt_pool Corrupt pool. Разрушение пула. -901 335740993 gfix_mem_exhausted Virtual memory exhausted. Виртуальная память исчерпана. -901 336330817 gbak_open_bkup_error Cannot open Сервис @1 не имеет связанного исполнителя -901 335544704 net_lookup_err Failed to locate host machine. Не удалось найти хост машины -901 335544705 service_unknown Undefined service @1/@2. Неопределенная фильтра. -901 335544768 exception_access_violation Access violation.The code attempted to access a virtual address without privilege to do so. Ошибка доступа. Код попытался получить доступ к виртуальному