Used to specify the connection information, such as: UserName, Password, Server, etc.
property ConnectString: string stored False;
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
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. |