Privacy policy. Thank you. Microsoft makes no warranties, express or implied, with respect to the information provided here. The OLE DB provider connection string that includes the data source name, and other parameters needed to establish the initial connection.
The default value is an empty string. An invalid connection string argument has been supplied or a required connection string argument has not been supplied. The following example creates an OleDbConnection and sets some of its properties in the connection string.
Odbc namespace. To maintain a high level of security, it is strongly recommended that you use the Integrated Security keyword with Persist Security Info set to false. You can use the ConnectionString property to connect to a variety of data sources.
The following example illustrates several possible connection strings. If the Data Source keyword is not specified in the connection string, the provider will try to connect to the local server if one is available. Enforces read only at connection time, and also for USE database statements. The result of using ApplicationIntent depends on database configuration. See read-only routing. The default for ApplicationIntent is ReadWrite.
You can either use an availability group listener for Server OR the read-only instance name to enforce a specific read-only instance. Authentication 1. Valid values are: not set : Authentication mode determined by other keywords.
This method supports Azure multi-factor authentication MFA. For a user-assigned identity, the user ID should be set to the object ID of the user identity. The user ID should be set to the application client ID.
The password should be set to the application client secret. SqlPassword: Authentication using user ID and password. NOTE: It's recommended that applications using SQL Server authentication set the value of the Authentication keyword or its corresponding property to SqlPassword to enable new encryption and certificate validation behavior.
Recognized values are yes and no. Controls the number of reconnection attempts in the case of connection loss. Valid values range from 0 to The default value is 1. A value of 0 would result in no attempt to reconnect.
For more information, see Idle Connection Resiliency. Specifies the number of seconds between each connection retry attempt in the case of connection loss. Valid values range from 1 to The default value is Specifies the mode of data type handling to use. Recognized values are 0 for provider data types and 80 for SQL Server data types. Encrypt 1. Specifies whether data should be encrypted before sending it over the network. Possible values are yes and no.
The default value is no. The SPN for the failover partner. The default value is an empty string. Possible values are Yes and No. The default is No. This also applies to ADO; so for an ADO programmer, a connection string is a similar concept but the way the provider looks at it is frequently misunderstood. What makes the situation especially confusing is that one of the properties is similar to a connection string. Use of this property implies that the consumer knows how this string will be interpreted and used by the provider.
0コメント