If the FetchOption.Mode is either fmAll or fmExactRecsMax, then "Store", otherwise "Use".Ĭontrols the TINYINT(1) representation. Choose - FireDAC automatically chooses a mode.It allows you to reduce memory usage on very big result sets. Until all rows from the result set are fetched, the server cannot handle new requests. Use - rows are fetched on demand from a client.Store - fetches all rows right after query execution and stores them on a client, making the server process ready for new requests.By default, it is not set.Ĭontrols the fetching of a result set to a client. This option works only for TCP/IP connections and, prior to MySQL 5.1.12, only for Windows. Each attempt uses this time-out value and there are net_retry_count retrials if necessary, so the total effective time-out value is net_retry_count times the option value. ![]() The time-out in seconds for attempts to write to the server. You can set the value so that a lost connection can be detected earlier than the TCP/IP Close_Wait_Timeout value of 10 minutes. Each attempt uses this time-out value and there are retrials if necessary, so the total effective time-out value is three times the option value. The time-out in seconds for attempts to read from the server. SSL_cipher - is a list of permissible ciphers to use for SSL encryption.įor additional details, see the MySQL Documentation:Ĭontrols the amount of time, in seconds, before an application times out while attempting to establish a connection.SSL_capath - is the path name to a directory that contains trusted SSL CA certificates in pem format.SSL_ca - is the path name to the certificate authority file.SSL_cert - is the path name to the certificate file.SSL_key - is the path name to the key file.Setting UseSSL=True requires you to additionally specify the connection definition parameters: Specify True to enable network traffic compression. For details, see the SET NAMES statement. The connection collation becomes the default collation of the character set. The default character set for the connection. If the Database is not specified, no current database is set up. Name of the current database for the connection. The TCP/IP port on which the MySQL server is listening. The TCP/IP address or host name of the server running a MySQL server. To connect to a MySQL DBMS, most applications require that you specify DriverID, Server, Database, User_Name, Password, and CharacterSet (see Defining Connection (FireDAC) for details). or include the unit in the uses clause. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |