TCustomDAConnection.ConnectString Property

Used to specify the connection information, such as: UserName, Password, Server, etc.

Class

TCustomDAConnection

Syntax

property ConnectString: string stored False;

Remarks

MyDAC recognizes an ODBC-like syntax in provider string property values. Within the string, elements are delimited by using a semicolon. Each element consists of a keyword, an equal sign character, and the value passed on initialization. For example:

Server=London1;User ID=nancyd

Connection parameters

The following connection parameters can be used to customize connection:

Parameter Name	Description
LoginPrompt	Specifies whether a login dialog appears immediately before opening a new connection.
Pooling	Enables or disables using connection pool.
ConnectionLifeTime	Used to specify the maximum time during which an opened connection can be used by connection pool.
MaxPoolSize	Used to specify the maximum number of connections that can be opened in connection pool.
MinPoolSize	Used to specify the minimum number of connections that can be opened in connection pool.
Validate Connection	Used for a connection to be validated when it is returned from the pool.
Server	Serves to supply the server name for login.
Username	Used to supply a user name for login.
Password	Used to supply a user name for login.
Database	Used to set the name of the database to associate with TMyConnection component.
Charset	Used to set the character set that MyDAC uses to read and write character data.
Protocol	Used to specify the Network protocol of connection with MySQL server.
UseUnicode	Used to enable or disable Unicode support.
Port	Used to specify the port number for the connection.
ConnectionTimeout	Used to specify the amount of time before an attempt to make a connection is considered unsuccessful.
Compress	Used to apply compression on transferring data.
Embedded	Used to specify the server that will be used to connect.
Direct	Used to work without using MySQL client library (libmysql.dll).
IPVersion	Used to specify the version of the Internet Protocol.
P:Devart.Mydac.TMyConnectionSSLOptions.CACert	Holds the pathname to the certificate authority file.
P:Devart.Mydac.TMyConnectionSSLOptions.Cert	Holds the pathname to the certificate file.
P:Devart.Mydac.TMyConnectionSSLOptions.ChipherList	Holds the list of allowed ciphers to use for SSL encryption.
P:Devart.Mydac.TMyConnectionSSLOptions.Key	Holds the pathname to the key file.
Username	Holds the user name for HTTP authorization.
Password	Holds the password for HTTP authorization.
URL	Holds the url of the tunneling PHP script.
Hostname	Holds the host name or IP address to connect to proxy server.
Username	Holds the proxy server account name.
Password	Holds the password for the proxy server account.
Port	Used to specify the port number for TCP/IP connection with proxy server.

See Also

• Password
• Username
• Server
• Connect