SDAC

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

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