Connection String Editor (ADO)

Use this dialog box to specify the connection string used to connect an ADO data component to an ADO data store. You can type the connection string, build it using an ADO-supplied dialog box, or place the string in a file.

Item	Description
Use Data Link File	Select or enter the name of a data link file, or click the Browse button to locate the file.
Use Connection String	Enter the connection string with the connection information in the edit box. Alternatively, click the Build button to display the Data Link Properties dialog to guide you through setting up and testing the connection.

Tip: ADO supports the following four arguments for connection strings: provider, file name, remote provider, and remote server. Any other arguments are passed on to the provider. Such parameters might include user ID, login password, the name of a default database, persistent security information, ODBC data source names, connection time-out values, and locale identifiers. These parameters and their values are specific to particular providers, servers, and ODBC drivers and not to either ADO or Delphi. For specific information on them, consult the documentation for the provider, server, or ODBC driver.

What do you think about this topic? Send feedback!