Specifies the connection information for the database.
property ConnectionString: WideString;
__property BSTR ConnectionString;
Set ConnectionString to specify the information needed to connect the command component to the data store. The value used for ConnectionString consists of one or more arguments ADO uses to establish the connection. Specify multiple arguments as a list with individual arguments separated by semicolons.
ADOCommand1.ConnectionString := 'Provider=YourProviderName;Remote Server=YourServerName';
ADOCommand1->ConnectionString = "Provider=YourProviderName;Remote Server=YourServerName";
At design-time, select from the list of available ADO database connections invoked from the Object Inspector.
A connection string may be saved to file for later use. Specify only the name of such a file in ConnectionString to reuse a saved connection string.
The connection string may also contain login information such as user ID and password, for automated logins.
ADO supports the following four arguments for connection strings. Any other arguments (such as a user ID and password) are not processed by ADO and simply passed on to the provider.
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!