access rights to the database for this to work. On Linux, all local connections are made via the network layer, using localhost (often implicitly). Only the server process needs access rights to the database cannot locate components of the server, or any database, on a mapped drive, a filesystem share or a network filesystem. Note You can mount a read-only database on a CD-ROM drive but you cannot run Firebird reachable from the client at all. At this point, it is assumed that you will use the recommended TCP/IP network protocol for your Firebird client/server connections. Notes • If you have installed a Classic Server

.......................................................................................... 11 A network address for the server ......................................................................... direct I/O to database files for Linux local connections. On Linux, local connections are made network-style, via localhost (often implicitly). On Windows, this is op- tional; you can also make direct user management, stats, etc.) programmatically. You can connect to the Services Manager over the network and thus perform these tasks remotely. SMP (symmetrical multi-processor) sup- port. Better performance

cannot locate components of the server, or any database, on a mapped drive, a filesystem share or a network filesystem. (Well, you can, but you shouldn’t, and this technique isn’t covered here.)  You can page=96 3.4. Testing your installation If you want to connect to your Firebird server across a 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 protocol for your Firebird client/server connections. Chapter 3. Installing Firebird 9 3.4.1

they all should be — you are strongly advised to take your backup files and use them to create a test restore of a database either on the same server or even better, on a different one. Only by doing restore.test At this point, the restore has worked and has overwritten the previous database known as employee.restore.test. The actual location of the database for the database employee.restore.test is is defined in the aliases.conf file in /opt/firebird on the server. In this test, it resolves to /opt/firebird/databases/employee.restore.fdb. For further proof of reliability, the application

databases with “blank” Firebird user name and password. Warning If you consider this insecure for your network setup, the change the parameter Authentication in firebird. conf. SQL Migration Issues DDL Views server module uses machine and network resources. Briefly: • Classic runs a stub process named fb_inet_server.exe on Windows that listens for connection requests from network clients. On POSIX systems, the deploy to user sites will be determined by comparing the per- formance of one with another in your test lab. You don't have to do anything to a database in order to make it work under a different server

2 3 2. Test for TRUE value SELECT * FROM TBOOL WHERE BVAL; ID BVAL ============ ======= 1 3. Test for FALSE value SELECT * FROM TBOOL WHERE WHERE BVAL IS FALSE; ID BVAL ============ ======= 2 4. Test for UNKNOWN value SELECT * FROM TBOOL WHERE BVAL IS UNKNOWN; ID BVAL ============ ======= compare): set *sqldata to the supplied value and *sqlind to 0 (for NOT NULL) Second parameter (NULL test): set sqldata to null (null pointer, not SQL NULL) and *sqlind to 0 (for NOT NULL) User has left

but are restored to match the defined length when the column is displayed on the client side. Network traffic is reduced by not sending spaces over the LAN. If the number of characters is not specified compare): set *sqldata to the supplied value and *sqlind to 0 (for NOT NULL) Second parameter (NULL test): set sqldata to null (null pointer, not SQL NULL) and *sqlind to 0 (for NOT NULL) User has left DROP DOMAIN name  Any user connected to the database can delete a domain. Example DROP DOMAIN Test_Domain See also DROP DOMAIN in the Data Definition Language (DDL) section. Chapter 3. Data Types

базы данных. Синтаксис: DROP DOMAIN name; Пример: DROP DOMAIN Test_Domain; См. также: DROP DOMAIN. 58 Глава 3 Общие элементы языка В этой CASE Синтаксис: CASE <test-expr> WHEN THEN [WHEN THEN ...] [ELSE ] END При использовании этого варианта <test-expr> сравнивается с ветвь ELSE отсутствует, возвращается значение NULL. Совпадение эквивалентно оператору «=», т.е. если <test-expr> имеет значение NULL, то он не соответствует ни одному из , даже тем, которые имеют значение

prepare each database for the COMMIT and then COMMIT each database separately. In the event of a network outage, for example, it is possible for part of the transaction to have been committed on one database database does not have any limbo transactions — the transaction that went into limbo, when the network failed, for example, was initiated on the local database. You may also supply the -⁠pr[ompt] option gfix -mode read_only my_employee linux> isql my_employee Database: my_employee SQL> create table test(stuff integer); Statement failed, SQLCODE = -902 Dynamic SQL Error -attempted update on read-only

использовании протокола NetBEUI в Windows инфрастуктуре Вы можете получить, обратившись к главе 6 Network Configuration руководства Using Firebird. Внимание Firebird не поддерживает сети IPX/SPX. Проверяем получаете timeout-сообщения (и не знаете, что с этим делать), изучите материал Using Firebird – глава 6: Network Configuration и глава 7: Troubleshooting Connections – для дальнейших инструкций. Обратите внимание базу данных. Предположим, что Вы хотите создать базу данных test.fdb и сохранить её в папке data на диске D: SQL>CREATE DATABASE 'D:\data\test.fdb' page_size 8192￿ CON>user 'SYSDBA' password 'masterkey';￿