. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 536 11.1. CURRENT_CONNECTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 751 Using MON$ATTACHMENTS to Kill a Connection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 753 accessing a database. SQL dialects can be defined at the database level and specified at the connection level. Three dialects are available: • Dialect 1 is intended solely to allow backward comptibility

29 6.1. Connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 6.1.1. Local connection strings . 29 6.1.2. TCP/IP connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 6.1.3. XNET connection strings. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 6.1.4. NetBEUI connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 371 9.1. CURRENT_CONNECTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 502 Using MON$ATTACHMENTS to Kill a Connection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 503 accessing a database. SQL dialects can be defined at the database level and specified at the connection level. Three dialects are available: • Dialect 1 is intended solely to allow backward comptibility

........................................................................................... 20 Connection strings ...................................................................................... Superserver Classic Server Superserver Processes Creates a separate process for every client connection, each with its own cache. Less resource use if the number of connections is low. A single process the local server, without using a network layer. If you intend to use Firebird for this type of connection only, you can skip the “Pinging the server” section below. • For information about using the NetBEUI

........................................................... 366 Особенности пула подключений (Connection pooling) ............................... 367 Особенности пула транзакций (Transaction pooling) .................................................................................. 389 CURRENT_CONNECTION ............................................................................................ 389 password Пароль. Может быть строкой или переменной. role Роль. Может быть строкой или переменной. connection_string Строка соединения. Может быть строкой или переменной. filepath Путь к первичному файлу

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 8.1. Connection Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 8.1.2. Legacy Connection Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . bail on) -c(ache) number of cache buffers -ch(arset) connection charset (set names) -d(atabase) database name to put in script creation

управления пользователями CREATE USER ALTER USER DROP USER 11. Контекстные переменные CURRENT_CONNECTION 6 Руководство по языку SQL CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION Зарезервированные слова, добавленные в Firebird: BIGINT BIT_LENGTH BOTH CASE CLOSE CONNECT CROSS CURRENT_CONNECTION CURRENT_ROLE CURRENT_TRANSACTION CURRENT_USER DISCONNECT FETCH GLOBAL INSENSITIVE LEADING LOWER MON$SERVER_PID, M_A.MON$REMOTE_PID FROM MON$ATTACHMENTS M_A WHERE M_A.MON$ATTACHMENT_ID = CURRENT_CONNECTION INTO :REMOTE_PROTOCOL, :APP_NAME, :SERVER_PID, :PC_PID; INSERT INTO USER_CONNECTED ( USER_LOGIN

exception occurred during the execution of a user defined function. -901 335544741 lost_db_connection Connection lost to database -901 335544742 no_write_user_priv User cannot write to RDB$USER_PRIVILEGES -902 335544722 net_connect_err Failed to establish a connection. -902 335544723 net_connect_listen_err Error while listening for an incoming connection. Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL net_event_connect_err Failed to establish a secondary connection for event processing. -902 335544725 net_event_listen_err Error while listening for an incoming event connection request. -902 335544726 net_read_err

exception occurred during the execution of a user defined function. -901 335544741 lost_db_connection Connection lost to database -901 335544742 no_write_user_priv User cannot write to RDB$USER_PRIVILEGES establish a connection. -902 335544723 net_connect_listen_err Error while listening for an incoming connection. -902 335544724 net_event_connect_err Failed to establish a secondary connection for event for an incoming event connection request. -902 335544726 net_read_err Error reading data from the connection. -902 335544727 net_write_err Error writing data to the connection. -902 335544732 unsup

exception occurred during the execution of a user defined function. -901 335544741 lost_db_connection Connection lost to database -901 335544742 no_write_user_priv User cannot write to RDB$USER_PRIVILEGES establish a connection. -902 335544723 net_connect_listen_err Error while listening for an incoming connection. -902 335544724 net_event_connect_err Failed to establish a secondary connection for event for an incoming event connection request. -902 335544726 net_read_err Error reading data from the connection. -902 335544727 net_write_err Error writing data to the connection. -902 335544732 unsup