Для доступу до баз даних сервіс використовує компоненти UniDAC від Devart. Налаштування за замовчуванням підійдуть більшості користувачів, але якщо ви маєте проблеми з роботою або підключенням до бази, то ви можете відредагувати параметри вручну. Додаткові налаштування підключення до баз даних знаходяться у файлі Connection.ini у папці, куди ви встановили ваш портал Fox24.
Редагувати налаштування у файлі Connection.ini можна, наприклад, у блокноті. Після збереження змін, сервіс порталу Fox24 потрібно перезапустити. Деякі зміни (наприклад, використання Unicode) можуть вимагати видалення всіх даних із бази даних або створення бази повторно.
Опис параметрів підключення з посібника користувача UniDAC.
DB2-specific options
| Option name | Description |
| ColumnWiseBinding | If set to True, the option enables Column-Wise Binding mode. The fefault value is False. Note: Row-Wise Binding mode is enabled by default. However, some ODBC drivers don’t support this mode. In such case, set the ColumnWiseBinding option to True. |
| ConnectionTimeout | The time to wait for a connection to open before raising an exception. |
| FunctionPath | Use the FunctionPath property to change the current function path of the connection to the specified value. You can specify several names separated by comma. This option can be used to call stored procedures from a schema other than that of the current user without having to qualify the objects with the schema name. |
| Schema | Use the Schema property to change the current schema of the connection to the specified schema. This setting offers a convenient way to perform operations on objects in a schema other than that of the current user without having to qualify the objects with the schema name. |
| UseUnicode | Enables or disables Unicode support. Affects character data fetched from the server. When set to True, all character data is stored as WideStrings, and TStringField is replaced by TWideStringFiled. |
InterBase/Firebird-specific options
| Option name | Description |
| CharLength | Specifies the size in bytes of a single character. Set this option with the number in range [0..6] to reflect InterBase support for the national languages. Setting CharLength to zero will instruct TUniConnection to interrogate InterBase server for the actual character length. The default value is 1. |
| Charset | Sets character set that IBDAC uses to read and write character data. |
| ClientLibrary | Use the ClientLibrary option to set or get the client library location. |
| EnableMemos | If set to True, TMemoField and TWideMemoField will be created for BLOB subtype 1 fields. The default value is False. |
| ForceUnloadClientLibrary | Use the option to force unloading of the client library after the connection is closed. The default value is False. |
| IPVersion | Use the IPVersion property to specify Internet Protocol Version. Supported values: ivIPBoth (default) Specifies that either Internet Protocol Version 6 (IPv6) or Version 4 (IPv4) will be used. ivIPv4 Specifies that Internet Protocol Version 4 (IPv4) will be used. ivIPv6 Specifies that Internet Protocol Version 6 (IPv6) will be used. Note: Internet Protocol Version support has been added in Firebird 3. To use the IPVersion option, your client library version must be version 3 or higher. When the TIPVersion property is set to ivIPBoth, a connection attempt will be made via IPv6 if it is enabled on the operating system. If the connection attempt fails, a new connection attempt will be made via IPv4. |
| NoDBTriggers | Use the option to enable or disable all database triggers. By default, all triggers are enabled. |
| Params | The option allows specifying custom parameters of the transaction. Refer to the InterBase API guide for more information on the parameters. Custom parameters will be used only when the TUniTransaction.IsolationLevel property is set to ilCustom. Multiple parameters can be separated either with the CRLF or with the “;” character. |
| Protocol | Network protocol of connection with InterBase server. The default value is TCP. |
| Role | InterBase connection role. |
| SQLDialect | Use SQLDialect to set or return SQL Dialect used by InterBase client. The SQLDialect property cannot be set to a value greater than the database SQL dialect when the connection is active. If the connection is inactive, the SQLDialect option will be downgraded to match the database SQL dialect. |
| SSLClientCertFile | The name and location of the client certificate file. The file must be in the PEM format and contain both the client certificate and the private key. |
| SSLClientPassPhrase | The private key passphrase. You can use either this option or the SSLClientPassPhraseFile option. |
| SSLClientPassPhraseFile | The name and location of the text file containing the client private key passphrase. You can use either this option or the SSLClientPassPhrase option. |
| SSLServerPublicFile | The name and location of the CA certificate file in the PEM format. |
| SSLServerPublicPath | The location of the directory with the CA certificate files in the PEM format. Each file in the directory must contain only a single CA certificate and the files must be named by the hash of the subject name and extension of “.0”. It is recommended that you use SSLServerPublicFile instead. If you specify both, SSLServerPublicFile will be used. |
| TrustedAuthentication | Windows “Trusted User” security can be applied for authenticating Firebird users on a Windows host. When the option is set to True, the Firebird security database is ignored during establishing a connection, and only Windows authentication is used. The default value is False |
| UseSSL | Enables or diables SSL connections. The default value is False. |
| UseUnicode | Enables or disables Unicode support. Affects on the character data fetched from the server. When set to True all character data is stored as WideStrings, and TStringField is replaced with TWideStringFiled. |
| SimpleNumericMap | Used to create ftBCD fields. When it is set to “False” and EnableBCD to “True”, fields like DECIMAL(14, 4) are mapped as ftBCD. The option default value is “True”. |
| WireCompression | Enables or disables compression of data over the wire at global or individual database level. Use Params to pass this connection parameter, for example WireCompression=True. Disabled by default. Note: You should place zlib1.dll in the same location as fbclient.dll. |
MySQL-specific options
Якщо вам не вдається встановити підключення до БД MySQL версії 8.x або новіше, встановіть у налаштуваннях сервера MySQL 8 опцію Use Legacy Authentication Method. Іноді для цього потрібно запустити інсталяцію сервера і вибрати Reconfigure на сторінці установки/конфігурації.
| Option name | Description |
| Charset | Setups the character set used by the client. |
| Compress | Use compression on transferring data. Setting this property to True is quite effective on transferring big volume data through slow connection. This property is ignored under CLR. The default value is False. |
| ConnectionTimeout | Specifies the amount of time in seconds that can be expired before an attempt to make a connection is considered unsuccessful. |
| Embedded | If True, connects to Embedded MySQL server. If False, connects to MySQL server. The default value is False. |
| EmbeddedParams | Allows to set such parameters of embedded connection as –basedir, –datadir, etc. Parameters should be separated with newline characters (#13#10), for example: UniConnection.SpecificOptions.Values[‘MySQL.EmbeddedPrams’] := ‘–basedir=.’#13#10′–datadir=data’; The default value is ” |
| HttpTrustServerCertificate | This option specifies whether or not the driver should trust the server certificate when connecting to the server. The default value is False – the driver won’t trust the server certificate and will verify validity of the server certificate instead. If set to True, the driver will trust the server certificate. |
| Interactive | Determines the inactivity timeout before the server breaks the connection. If true, the server breaks the connection after number of seconds specified in interactive_timeout sever variable, otherwise wait_timeout is used. The default value is false. The interactive_timeout and wait_timeout variables can be set in my.ini file. |
| IPVersion | Use the IPVersion property to specify Internet Protocol Version. Supported values: ivIPBoth Specifies that either Internet Protocol Version 6 (IPv6) or Version 4 (IPv4) will be used. ivIPv4 (default) Specifies that Internet Protocol Version 4 (IPv4) will be used. ivIPv6 Specifies that Internet Protocol Version 6 (IPv6) will be used. Note: When the TIPVersion property is set to ivIPBoth, a connection attempt will be made via IPv6 if it is enabled on the operating system. If the connection attempt fails, a new connection attempt will be made via IPv4. |
| NullForZeroDelphiDate | Use the NullForZeroDelphiDate property to hide the ’30-12-1899′ dates. If NullForZeroDelphiDate is set to True, the values of all datetime fields will be changed to Null. If the property is set to False, the ’30-12-1899′ value will be used as an ordinary date. The default value is false. |
| OptimizedBigint | Setting this option converts all fields with field length less than 11 of TLargeIntField type into TIntegerField. This allows to process fields that are results of numeric function or cast values as usual Integer fields. The default value is False. |
| Protocol | Specifies which protocol to use when connecting to the server: mpDefault Similar to mpTCP, except the cases when you connect to a local server and the OS supports sockets (Unix) or named pipes (Windows), they are used instead of TCP/IP to connect to the server. mpTCP Use TCP/IP to connect to the server. mpSocket Uses sockets to connect to the server. Can be used with Direct set to False and libmysql.dll 4.1. mpPipe Use NamedPipes to connect to the server. mpMemory To connect to the server using SharedMem. Can be used with Direct set to False and libmysql.dll 4.1. mpSSL Use protected SSL connection with the server. mpHttp Uses HTTP Network Tunneling to connect to the server. |
| HttpUrl | Holds the url of the tunneling PHP script. |
| HttpUsername | Holds the user name for HTTP authorization. |
| HttpPassword | Holds the password for HTTP authorization. |
| ProxyHostname | Holds the host name or IP address to connect to proxy server. |
| ProxyPort | Used to specify the port number for TCP/IP connection with proxy server. |
| ProxyUsername | Holds the proxy server account name. |
| ProxyPassword | Holds the password for the proxy server account. |
| SSLCACert | CACert is the pathname to the certificate authority file. |
| SSLCert | Cert is the pathname to the certificate file. |
| SSLChipherList | ChipherList is a list of allowable ciphers to use for SSL encryption. |
| SSLKey | Key is the pathname to the key file. |
| UseUnicode | Informs server that all data between client and server sides will be passed in UTF-8 coding. Setting this option converts all fields of TStringField type into TWideStringField that allows to work correctly with symbols of almost all languages simultaneously. On the other hand, it causes a delay in working. The default value is False. |
SQL Server-specific options
| Option name | Description |
| ApplicationIntent | Specifies the application workload type when connecting to a server. |
| ApplicationName | The name of a client application. The default value is the name of the executable file of your application |
| Authentication | Use the Authentication property to specify authentication service used by the database server to identify a user. The Authentication property accepts one of the following values: auWindows Uses Windows NT/2000/XP integrated security, or “SSPI” (Security Support Provider Interface). Username, Password and LoginPrompt properties are ignored. auServer (default) An alternative way of identifying users by database server. To establish a connection valid Username and Password either hardcoded into application or provided in server login prompt fields are required. |
| AutoTranslate | When set to True, character strings sent between the client and server are translated by converting through Unicode to minimize problems in matching extended characters between the code pages on the client and the server. |
| CompactAutoShrinkThreshold | Specifies the amount of free space in the database file before automatic shrink will start. Measured in percents. The default value is 60. |
| CompactDefaultLockEscalation | Specifies how many locks should be performed before trying escalation from row to page or from page to table. The default value is 100. |
| Compact FlushInterval | Specifies the interval at which committed transactions are flushed to disk. Measured in seconds. The default value is 10. |
| CompactInitMode | Use this property to specify the file mode that will be used to open the database file. The InitMode property accepts one of the following values: imExclusive Database file is opened for exclusive use. This mode prevents others from opening this database file. imReadOnly Database file is opened for reading. All operations that write to database are unallowable. imReadWrite (default) Both read and write operations are allowed. imShareRead Opens a database file preventing others from opening the same file in the read mode. |
| CompactLocaleIdentifier | Specifies the locale ID. The default value is the system default locale on Windows systems and 0 on other systems. |
| CompaLockEscalation | Specifies how many locks should be performed before trying escalation from row to page or from page to table. Measured in milliseconds. The default value is 100. |
| CompactLockTimeout | Specifies how much time a transaction will wait for a lock. Measured in milliseconds. The default value is 2000. |
| CompactMaxBufferSize | Specifies how much memory SQL Server Compact Edition can use before flushing changes to disc. Measured in kilobytes. The default value is 640. |
| CompactMaxDatabaseSize | Specified maximum size of the main database file. Measured in megabytes. The default value is 128. |
| CompactTempFileDirectory | Specifies the temp file directory. If this option is not assigned, the current database is used as a temporary database. |
| CompactTempFileMaxSize | Specified maximum size of the temporary database file. Measured in megabytes. The default value is 128. |
| CompactTransactionCommitMode | Specifies in what way the buffer pool will be flushed on transaction commit. The following two values are allowed: cmAsynchCommit Asynchronous commit to disk. cmSynchCommit (default) Synchronous commit to disk. |
| CompactVersion | Specifies which version of SQL Server Compact Edition will be used. cvAuto (default) Version of SQL Server Compact Edition will be chosen automatically depending on database version. If database is not provided, the higher available server version will be chosen. cv30 Uses SQL Server Compact Edition Version 3.0 or 3.1. cv35 Uses SQL Server Compact Edition Version 3.5. |
| ConnectionTimeout | Use ConnectionTimeout to specify the amount of time, in seconds, that can expire before an attempt to consider a connection unsuccessful. The default value is 15 seconds. |
| Encrypt | Specifies if data should be encrypted before sending it over the network. The default value is False. |
| FailoverPartner | Specifies the SQL Server name to which SQL Native Client will reconnect when a failover of the principal SQL Server occurs. This option is supported only for SQL Server 2005 using SQL Native Client as an OLE DB provider. |
| ForceCreateDatabase | Used to force TLiteConnection to create a new database before opening a connection, if the database does not exist. |
| IPVersion | Use the IPVersion property to specify Internet Protocol Version. Supported values: ivIPBoth Specifies that either Internet Protocol Version 6 (IPv6) or Version 4 (IPv4) will be used. ivIPv4 (default) Specifies that Internet Protocol Version 4 (IPv4) will be used. ivIPv6 Specifies that Internet Protocol Version 6 (IPv6) will be used. Note: When the TIPVersion property is set to ivIPBoth, a connection attempt will be made via IPv6 if it is enabled on the operating system. If the connection attempt fails, a new connection attempt will be made via IPv4. |
| InitialFileName | Specifies the name of the main database file. This database will be default database for the connection. SQL Server attaches the database to the server if it has not been attached to the server yet. So, this property can be used to connect to the database that has not been attached to the server yet. |
| Language | A SQL Server language name. Identifies the language used for system message selection and formatting. The language must be installed on the computer running an instance of SQL Server otherwise the connection will fail. |
| LockTimeout | Specifies the number of milliseconds that a transaction will wait to obtain a lock to avoid global deadlocks. The default value is 2000. |
| MultipleActiveResultSets | Enables support for SQL Server 2005 Multiple Active Result Sets (MARS) technology. It allows applications to have more than one pending request per connection, and in particular, to have more than one active default result set per connection. Current session is not blocked when using FetchAll = False, and it is not necessary for OLE DB to create additional sessions for any query executing. MARS is only supported by SQL Server 2005 with using SQL Native Client as OLE DB provider. |
| MultipleConnections | Enables or disables the creation of additional connections to support concurrent sessions, commands and rowset objects. |
| MultiSubnetFailover | Use the MultiSubnetFailover option to configure the prNativeClient or prMSOLEDB provider to faster detect and connect to the currently active server by making simultaneous connection attempts to all IP addresses associated with the group listener of a SQL Server AlwaysOn Availability Group or a SQL Server Failover Cluster Instance. The default value is False. |
| NativeClientVersion | Specifies which version of SQL Native Client will be used. The default value is ncAuto. NativeClientVersion is applied when the Provider property is set to prNativeClient or prAuto. |
| NetworkLibrary | The name of the Net-Library (DLL) used to communicate with an instance of SQL Server. The name should not include the path or the .dll file name extension. The default name is provided by the SQL Server Client Network Utility. |
| PacketSize | Network packet size in bytes. The packet size property value must be between 512 and 32,767. The default network packet size is 4,096. |
| PersistSecurityInfo | The data source object is allowed to persist sensitive authentication information such as password along with other authentication information. |
| Provider | This property allows you to specify a provider from the list of supported providers or use the Direct mode. Some features added to SQL Server 2005 require the SQL Native Client (prNativeClient) provider to be used. If chosen provider is not installed, an exception is raised. Supported values: prAuto (default) prAuto is the default value of the Provider property. With default value, UniDAC will use the most recent version of one of the supported providers in the following order: 1. prNativeClient 2. prMSOLEDB 3. prSQL First UniDAC checks whether SQL Server Native Client is installed in the system. If SQL Server Native Client is not found, UniDAC looks for Microsoft OLE DB Driver for SQL Server. If neither SQLNCLI nor MSOLEDBSQL is installed in the system, the driver will use Microsoft OLE DB Provider for SQL Server. prSQL Uses the provider preinstalled with Windows that has limited functionality. prMSOLEDB Uses Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). You need to have the driver installed on your system to use this value for Provider. prNativeClient Uses the SQL Native Client. It should be installed on the computer to use this Provider value. This provider offers the maximum functionality set. prCompact SQL Server Compact Edition provider. prDirect Connect to SQL Server directly via TCP/IP. |
| QuotedIdentifier | Causes Microsoft® SQL Server™ to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings. Identifiers delimited by double quotation marks can be either Transact-SQL reserved keywords or can contain characters not usually allowed by the Transact-SQL syntax rules for identifiers. QuotedIdentifier must be True when creating or manipulating indexes on computed columns or indexed views. If QuotedIdentifier is False, CREATE, UPDATE, INSERT, and DELETE statements on tables with indexes on computed columns or indexed views will fail. True (default) Identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. All strings delimited by double quotation marks are interpreted as object identifiers. Therefore, quoted identifiers do not have to follow the Transact-SQL rules for identifiers. They can be reserved keywords and can include characters not usually allowed in Transact-SQL identifiers. Double quotation marks cannot be used to delimit literal string expressions; single quotation marks must be used to enclose literal strings. If a single quotation mark (‘) is a part of the literal string, it can be represented by two single quotation marks (“). QuotedIdentifier must be True when reserved keywords are used for object names in the database. False (BDE compatibility) Identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers. Literals can be delimited by either single or double quotation marks. If a literal string is delimited by double quotation marks, the string can contain embedded single quotation marks, such as apostrophes. |
| UseWideMemos | Use the option to manage the field type that will be created for the NTEXT data type. If True (default), TWideMemo fields will be created for the NTEXT data type. If False, TMemo fields will be created. |
| UuidWithBraces | Use the UuidWithBraces option to specify whether the values of UUID fields are returned with braces. The default value is True. |
| TrustServerCertificate | Lets enabling traffic encryption without validation. The default value is False. This option is only supported by SQL Server 2005 with using SQL Native Client as OLE DB provider. |
| WorkstationID | A string identifying the workstation. The default value is the name of your machine. |
Oracle-specific options
| Option | Description |
| CharLength | The size of characters in bytes for national language support. The range of allowed values is between 0 and 6. The default value is 0 — the actual character length is determined by an Oracle server. |
| Charset | The character set for the character data transferred between the client and server. Supported with Oracle 8 client only. |
| ClientIdentifier | The client identifier in the session. The client identifier can be set in the session handle at any time in the session. Then, on the next request to the server, the information is propagated and stored in the server session. The first character of the ClientIdentifier must not be ‘:’. If it is, an exception will be raised. This property has no effect if you use the version of the server earlier than Oracle 9. |
| ConnectionTimeout | The time to wait for a connection to open before raising an exception. Works only when Direct is set to True. The default value is 0. |
| ConnectMode | The system privilege for the user who connects to the server.cmNormalThe default value. Connect as a normal user. cmSysOperConnect with the SYSOPER privilege.cmSysDBAConnect with the SYSDBA privilege.cmSysASMConnect with the SYSASM privilege.cmSysBackupConnect with the SysBackup privilege.cmSysDGConnect with the SysDG privilege.cmSysKMConnect with the SYSKM privilege.The privilege must be granted to the user before connecting to the server. ConnectMode is not supported for OCI 7. |
| DateFormat | The default date format used when Oracle makes conversions from internal date format into string values and vice versa. An example of a valid expression is MM/DD/YYYY. |
| DateLanguage | The default language used when Oracle parses internal date format into strings and vice versa. Examples of valid expressions include French, German, etc. |
| Direct | Enables the Direct mode. When True, connection is performed directly over TCP/IP, without involving Oracle client software. When False, the Oracle provider connects in the Client mode. The default value is False. |
| EnableIntegers | Represents Oracle NUMBER fields with precision less than 10. When True, fields are represented as TIntegerField. When False, fields are represented as TFloatField. The default value is True. |
| EnableLargeint | Represents Oracle NUMBER fields with precision more than 9 and less than 18. When True, fields are represented as TIntegerField. When False, fields are represented as TFloatField. The default value is False. |
| HomeName | Specifies which Oracle client to use when two ore more Oracle clients are present on the machine. The Oracle provider searches for available homes in the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE registry folder. When the option is set to an empty string, the provider uses the first directory from the list of homes found in the PATH environment variable as the default Oracle home. |
| HttpPassword | The password for the password-protected directory that contains the HTTP tunneling script. |
| HttpTrustServerCertificate | Specifies whether to verify the server certificate during an SSL handshake. When True, ODAC bypasses walking the certificate chain to verify the certificate. The default value is False. |
| HttpUrl | The URL of the PHP script for HTTP tunneling. |
| HttpUsername | The username for the password-protected directory that contains the HTTP tunneling script. |
| IPVersion | The Internet Protocol Version.ivIPBothEither Internet Protocol Version 6 (IPv6) or Version 4 (IPv4) is used. ivIPv4The default value. Internet Protocol Version 4 (IPv4) is used. ivIPv6Internet Protocol Version 6 (IPv6) is used. Note: When the property is set to ivIPBoth, a connection attempt is made via IPv6 if it is enabled in the operating system. If the connection attempt fails, a new connection attempt is made via IPv4. |
| OptimizerMode | The default optimizer mode for the connection.omDefaultThe session optimizer mode remains unchanged. omFirstRowsNThe optimizer chooses the execution plan that returns the first N rows as quickly as possible. If you use Oracle 9.0 or earlier, these options have the same effect as omFirstRows.omFirstRowsThis mode is retained for backward compatibility and plan stability. It optimizes for the best execution plan to return the first row as soon as possible. omAllRowsThe optimizer explicitly chooses the cost-based approach to optimize a statement block with a goal of best throughput (that is, minimum total resource consumption). omChooseThe optimizer chooses between the rule-based and cost-based approaches for an SQL statement. The choice of the optimizer depends on the presence of statistics for the tables accessed by the statement: if the data dictionary has statistics for at least one of the tables, the optimizer uses the cost-based approach and optimizes with the goal of the best throughput. Otherwise, it uses the rule-based approach. omRuleThe optimizer chooses rule-based optimization (RBO). Any other value causes the optimizer to choose cost-based optimization (CBO). The rule-based optimizer is the archaic optimizer mode from the earliest releases of Oracle Database. |
| PoolingType | The connection pooling implementation.optLocalThe default value. Our own connection pooling implementation. optOCIOCI connection pooling. optMTSShared server (MTS) connection pooling. |
| PrecisionBCD | Represents Oracle NUMBER fields as TBCDField when their precision and scale are less than or equal to the precision and scale in PrecisionBCD, specified as two comma-separated values (BCD precision and scale). PrecisionBCD cannot be greater than 14,4. The default value is 14,4. |
| PrecisionFloat | Represents Oracle NUMBER fields as TFloatField when their precision is less than or equal to the precision in PrecisionFloat. The default value is 0. |
| PrecisionFMTBCD | Represents Oracle NUMBER fields as TFMTBCDField when their precision and scale are less than or equal to the precision and scale in PrecisionFMTBCD, specified as two comma-separated values (FMTBCD precision and scale). The default value is 39,39. |
| PrecisionInteger | Represents Oracle NUMBER fields as TIntegerField when their precision is less than or equal to the precision in PrecisionInteger. The default value is 9. |
| PrecisionLargeint | Represents Oracle NUMBER fields as TLargeintField when their precision is less than or equal to the precision in PrecisionLargeint. The default value is 18. |
| PrecisionSmallint | Represents Oracle NUMBER fields as TSmallintField when their precision is less than or equal to the precision in PrecisionSmallint. The default value is 4. |
| ProxyHostname | The proxy hostname or IP address. |
| ProxyPassword | The proxy password. |
| ProxyPort | The proxy port. |
| ProxyUsername | The proxy username. |
| Schema | Changes the current schema of the session to the specified schema. This option offers a convenient way to perform operations on objects in a schema other than that of the current user, without having to qualify the objects with the schema name. It changes the current schema, but it does not change the session user or the current user, nor does it give you any additional system or object privileges for the session. If TUniConnection.Connected is True, read this property to get the name of the current schema. |
| SSLCACert | The server CA certificate. |
| SSLCert | The client certificate. |
| SSLCipherList | The list of allowed SSL ciphers. |
| SSLServerCertDN | The server’s distinguished name (DN) to enable server DN matching. It checks whether the server is genuine by matching the server’s global database name against the DN from the server certificate. |
| StatementCache | Enables statement caching. The default value is False. |
| StatementCacheSize | The size of statement cache. The default value is 20. |
| ThreadSafety | Enables the use of OCI in a multithreaded environment. This option must be set to True before any non-blocking fetch of rows or SQL statement execution takes place. The default value is True. |
| UnicodeEnvironment | Enables the use of OCI Unicode Environment. When True, Unicode characters can be used in SQL statements. Set the option to False if you encounter some issues with Unicode Environment. The default value is False. |
| UseOCI7 | Forces TUniConnection to use the OCI 7 call style only. The default value is False. |
| UseUnicode | Enables Unicode support. The option affects character data fetched from the server. When True, all character data is stored as WideString, and TStringField is replaced with TWideStringField. Supported starting with Oracle 8. The default value is False. |
PostgreSQL-specific options
| Option name | Description |
| ApplicationName | The name of a client application. The default value is the name of the executable file of your application. |
| Charset | Setups the character set which will be used to transfer character data between client and server. |
| ConnectionTimeout | The time to wait for a connection to open before raising an exception. |
| HttpPassword | Use the HttpPassword option to specify the password for HTTP authorization. |
| HttpTrustServerCertificate | This option specifies whether or not the driver should trust the server certificate when connecting to the server. The default value is False – the driver won’t trust the server certificate and will verify validity of the server certificate instead. If set to True, the driver will trust the server certificate. |
| HttpUrl | Use the HttpUrl option to specify the URL of the PHP tunneling script. |
| HttpUsername | Use the HttpUsername option to specify the username for HTTP authorization. |
| IPVersion | Use the IPVersion property to specify Internet Protocol Version. Supported values: ivIPBoth Specifies that either Internet Protocol Version 6 (IPv6) or Version 4 (IPv4) will be used. ivIPv4 (default) Specifies that Internet Protocol Version 4 (IPv4) will be used. ivIPv6 Specifies that Internet Protocol Version 6 (IPv6) will be used. Note: When the TIPVersion property is set to ivIPBoth, a connection attempt will be made via IPv6 if it is enabled on the operating system. If the connection attempt fails, a new connection attempt will be made via IPv4. |
| MessagesCharset | Specifies the character set that will be used to transfer error messages from the server to the client. |
| MultipleConnections | Enables or disables the creation of an additional internal connection for TUniQuery, when necessary. The default value is True. |
| ProtocolVersion | Specifies protocol version to be used when several versions are available. Supported values: pv20 Set ProtocolVersion to pv20 to work with PostgreSQL server version 7.3 or older that don’t support protocol version 3.0. pv30 Set ProtocolVersion to pv30 to enforce protocol version 3.0. pvAuto (default) Set ProtocolVersion to pvAuto to automatically select between protocol versions depending on the specific query for the best possible performance. |
| ProxyHostname | Use the ProxyHostName option to specify the host name or IP address to connect to the proxy server. |
| ProxyPassword | Use the ProxyPassword option to specify the password for the proxy server. |
| ProxyPort | Use the ProxyPort option to specify the port for a TCP/IP connection with the proxy server. |
| ProxyUsername | Use the ProxyUsername option to specify the username for the proxy server. |
| Schema | Use the Schema property to set the search path for the connection to the specified schema. This setting offers a convenient way to perform operations on objects in a schema other than that of the current user without having to qualify the objects with the schema name. |
| SSLCACert | The pathname to the certificate authority file. |
| SSLCert | The pathname to the certificate file. |
| SSLCipherList | The list of allowable ciphers to use for SSL encryption. |
| SSLKey | The pathname to the key file. |
| SSLMode | This option determines whether or with what priority an SSL connection will be negotiated with the server. Supported values: smAllow Negotiates trying first a non-SSL connection, then if that fails, tries an SSL connection. smDisable (default) Only an unencrypted SSL connection will be attempted. smPrefer Negotiates trying first an SSL connection, then if that fails, tries a regular non-SSL connection. smRequire Tries only an SSL connection. smVerifyCA Verifies server identity by validating the server certificate chain up to the root certificate installed on the client machine. smVerifyFull Verifies server identity by validating the server certificate chain up to the root certificate installed on the client machine and validates that the server hostname matches the server certificate. Note: If PostgreSQL is compiled without SSL support, using option smRequire will cause an error, while options smAllow and smPrefer will be accepted, but PgDAC will not in fact attempt an SSL connection. |
| UseHttp | The UseHttp option enables the use of HTTP tunneling to connect to the server. The default value is False. |
| UseUnicode | Enables or disables Unicode support. Affects character data fetched from the server. When set to True, all character data is stored as WideStrings, and TStringField is replaced by TWideStringFiled. |
| UuidWithBraces | Use the UuidWithBraces option to specify whether the values of UUID fields are returned with braces. The default value is True. |
SQLite-specific options
| Option | Description |
| ASCIIDataBase | Enables or disables ASCII support. The default value is False.Note: Set the UseUnicode option to False before enabling ASCII support. |
| BusyTimeout | Sets the timeout in milliseconds for a locked resource (database or table). If the resource is not unlocked during this time, SQLite returns the SQLITE_BUSY error. The default value is 0. |
| CipherLicense | Holds a license key for SQLCipher Commercial Edition. Note that SQLCipher is not supported in the Direct mode. |
| ConnectMode | The connection mode.cmDefaultThe default value. The database is opened for reading and writing. Corresponds to the SQLite default behavior. cmReadWriteThe database is opened for reading and writing. cmReadOnlyThe database is opened in read-only mode. Note that the ForceCreateDatabase option can be used to enable the automatic creation of the database when it doesn’t already exist. |
| ClientLibrary | Use the ClientLibrary option to set or get the location of the client library. |
| DateFormat | The format for storing dates in the database. If no format is specified, the default format yyyy-mm-dd is used. The default value is an empty string. |
| DefaultCollations | Enables or disables automatic default collations registration on connection establishing. |
| Direct | When True, UniDAC connects to the database directly using the embedded SQLite3 engine, without the SQLite3 client library. The Direct mode also enables you to work with an encrypted database using the EncryptionAlgorithm and EncryptionKey options and the EncryptDatabase method. |
| EnableLoadExtension | Enables loading and using an SQLite extension:UniConnection.ExecSQL('SELECT load_extension(''C:\ext.dll'', ''sqlite3_ext_init'');'); |
| EnableSharedCache | Enables or disables the SQLite shared-cache mode. The default value is False. |
| EncryptionAlgorithm | Used to specify the encryption algorithm for an encrypted database. |
| EncryptionKey | This property is used for password input and for working with encrypted database. Password can be set or changed using EncryptDatabase method. |
| ForceCreateDatabase | Forces TLiteConnection to create a new database before opening a connection, if the database doesn’t already exist. |
| ForeignKeys | Enables or disables foreign keys constraints without explicitly executing the “PRAGMA foreign_keys = ON;” and “PRAGMA foreign_keys = OFF;” statements. The default value if True. |
| IntegerAsLargeInt | Maps INT (INTEGER) columns to TLargeIntField fields. If True, INT (INTEGER) columns are mapped to TLargeIntField fields. If False, INT (INTEGER) columns are mapped to TIntegerField fields. The default value is False. |
| JournalMode | The journal mode.jmDeleteThe rollback journal is deleted at the conclusion of each transaction. jmTruncateThe rollback journal is stored in volatile RAM. It reduces disk I/O, but decreases database safety and integrity. If the application using SQLite crashes in the middle of a transaction, the database file may become corrupt. jmPersistThe rollback journal file is not deleted when the transaction is commited. The header of the journal is filled with zeroes to prevent other connections rolling back from the journal. This mode optimizes performance on platforms where deleting or truncating a file is much more expensive than overwriting the first block of a file with zeros. jmMemoryThe rollback journal is stored in volatile RAM. This reduces the disk I/O, but decreases database safety and integrity. If the application using SQLite crashes in the middle of a transaction in this mode, the database file is likely to become corrupt. jmWALA write-ahead log is used instead of a rollback journal to implement transactions. When data database is updated, the original content is preserved in the database file and the changes are appended in a separate WAL file. All the transactions that are appended in the WAL file are eventually transferred back into the original database. jmOffThe rollback journal is completely disabled. No rollback journal is created, thus there is no rollback journal to delete. The ROLLBACK command does not work — it behaves in an undefined way. Avoid using the ROLLBACK command when the journal mode is disabled. jmDefaultThe default value. If the database was previously opened in the WAL mode, then Default will open the database in the WAL mode; otherwise, the database will be opened in the Delete mode. |
| LockingMode | The database locking mode.lmExclusiveThe database connection never releases file locks. The first time the database is read or written in this mode, a shared lock is obtained and held. Use this mode if you want to prevent other processes from accessing the database file, reduce the number of filesystem operations, or access WAL databases without using the shared memory. lmNormalThe database connection unlocks the database file at the conclusion of each read or write transaction. Note: Keep the default LockingMode=lmExclusive and Synchronous=smOff for the best perfomance. |
| NativeDate | If the option is set to True, the date and time values will be stored in the database in the native SQLite format, and when retrieved, they will be converted to the TDateTime type. If set to False, no conversion to the TDateTime type will be made. The default value is True. |
| ReadUncommitted | Enables or disables the Read Uncommitted isolation mode. A database connection in this mode doesn’t attempt to acquire a read lock on the table before reading from it. This can lead to inconsistent query results if another database connection modifies data in the table while it is being read, but it also means that a read transaction opened by a connection in the Read Uncommitted mode can neither block nor be blocked by another connection. The default value is False. |
| Synchronous | The database synchronization mode when writing to disk.smOffThe database engine continues without syncing after handing data off to the operating system. If the application running SQLite crashes, the data will safe, unless the operating system crashes or the computer loses power before data has been written to disk, in which case the database might become corrupted. This is the fastest mode. smNormalThe database engine still syncs at the most critical moments, but less often than in the FULL mode. The Normal mode is faster than the Full mode. When using the WAL mode (and probably the DELETE mode) with synchronous=NORMAL, data is safe from corruption. The synchronous=NORMAL setting is a reasonable choice for most applications running in the WAL mode. smFullThe database engine ensures that all content is safely written to disk before continuing. This preserves database integrity even in case of an operating system failure or power outage. It is a safe, but slower mode, and is most commonly used when not in the WAL mode. smExtraThis mode is similar to the FULL mode, but in the DELETE mode, the directory containing the rollback journal is synced after that journal is unlinked to commit a transaction. This provides additional durability if a power outage occurs right after the commit. Note: Keep the default Synchronous=smOff and LockingMode=lmExclusive for the best perfomance. |
| TimeFormat | The format for storing time in the database. If no format is specified, the default format hh24:mi:ss will be used. The default value is an empty string. |
| UseUnicode | Enables or disables Unicode support. When set to True, all character data is stored as WideString, and TStringField is used instead of TWideStringField. The default value is False. |