LiteDAC

TCustomDAConnection.ConnectString Property

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

Class

TCustomDAConnection

Syntax

property ConnectString: string stored False;

Remarks

LiteDAC 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.
ClientLibrary Used to set or get the SQLite client library location.
Database Used to specify the name of the database to be used once a connection is open.
UseUnicode Used to enable or disable Unicode support.
Direct Used to connect to the database directly and without using SQLite3 client library.
ForceCreateDatabase Used to force TLiteConnection to create a new database before opening a connection, if the database is not exists.

See Also

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback