TCustomDAConnection.ConnectString Property

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

Class

TCustomDAConnection

Syntax

property ConnectString: string stored False;

Remarks

SDAC 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.
Database (If prCompact)	Used to specify the database name that is a default source of data for SQL queries once a connection is established.
Username	Used to supply a user name for login.
Password	Serves to supply a password for login.
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.
Provider	Used to specify a provider from the list of supported providers.
ForceCreateDatabase	Used to force TMSConnection to create a new database before opening a connection, if the database is not exists.
Encrypt	Specifies if data should be encrypted before sending it over the network.
Integrated Security, Trusted_Connection	Used to specify the authentication service used by the database server to identify a user.
Language	Specifies the SQL Server language name.
PersistSecurityInfo	Used to allow the data source object to persist sensitive authentication information such as a password along with other authentication information.
AutoTranslate	Used to translate character strings sent between the client and server by converting through Unicode.
NetworkLibrary	Specifies the name of the Net-Library (DLL) used to communicate with an instance of SQL Server.
ApplicationName	The name of a client application. The default value is the name of the executable file of your application.
WorkstationID	A string identifying the workstation.
PacketSize	Network packet size in bytes.
InitialFileName	Specifies the name of the main database file.
MultipleActiveResultSets	Enables support for the Multiple Active Result Sets (MARS) technology.
FailoverPartner	Specifies the SQL Server name to which SQL Native Client will reconnect when a failover of the principal SQL Server occurs.
TrustServerCertificate	Used to enable traffic encryption without validation.
ApplicationIntent	Used to specify the application workload type when connecting to a server.

See Also

• Password
• Username
• Server
• Connect