Sets DB connection parameters.

Syntax:

property ConnectOptions: TConnectOptions;
type
TConnectOption = (coCompress,
                  coFoundRows,
                  coIgnoreSpaces,
                  coInteractive,
                  coNoSchema,
                  coODBC,
                  coSSL);
TConnectOptions = set of TConnectOption;

Description:

The value of ConnectOptions is usually empty set [], but can be set to a combination of the following flags in very special circumstances:

coCompress

Use compression protocol.

coFoundRows

Return the number of found (matched) rows, not the number of affected rows.

coIgnoreSpaces

Allow spaces after function names. Makes all functions names reserved words.

coNoSchema

Don't allow the db_name.tbl_name.col_name syntax. This is for ODBC. It causes the parser to generate an error if you use that syntax, which is useful for trapping bugs in some ODBC programs.

coODBC

The client is an ODBC client.

coInteractive

Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection.

coSSL

Use SSL (encrypted protocol).

Example of usage:

Use the following code to enable SSL usage at run-time:

mySQLDatabase1.ConnectOptions := mySQLDatabase1.ConnectOptions + [coSSL];

Don't forget to add MySQLTypes to your uses section.