ADO Connection

ADO Connection. The component is used for connection with various sources of ADO data.

Properties of a component: Active, Connection timeout, Login prompt, Keep connection, Connection string.

Active - defines whether connection is active or not, and allows to change its condition.

Value by default for property is False, meaning that the given connection is closed. Specifying the value of the given property equal True opens the given connection.  

Connection timeout - specifies a waiting time in seconds of that moment after which the command will be considered unsuccessful. Value by default for the given property is 15 seconds. If value of this property is equal 0, the provider will wait until the command will not be executed or cancelled.

Login prompt - is used for displaying the dialog window intended for input of the identifier of user and its password at connection with a database.

Keep connection - defines, whether it is necessary to close connection if there is no active component working with data through ADO. Value by default for the given property is True, that means, that the given connection will be kept for those appendices, which use the removed servers of databases or often opened and closed data sets. It allows to lower loading of a network and to raise speed of work of the appendix.

Connection string - is used to indicate the detailed information on connections with a source of data. Connection string or can be loaded from a file, or received by means of standard Microsoft dialog for setting the provider of connection. For example, below the standard value of property for ODBC provider intended for connection with a dBASE database is presented:

'Provider=MSDASQL.1;Persist Security Info=False;Data Source=Files dBASE;Initial Catalog=C:\Panorama9\DATA\Cadastre\DataBase'.

For provider of SQL Server:

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source= NameServer'.

Form of Connection settings: