Micro Focus Studio Enterprise Edition Test Server > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > BIND CONNECTION

BIND CONNECTION

Enables the pair of ADO.NET connection and transaction objects to be shared with OpenESQL.

Syntax:

>>--EXEC ADO--BIND CONNECTION--.-----------------.-TO :conn_obj_hv---->
                               +-connection_name-+
                               +- :conn_name_hv -+

 >------------------WITH +-TRANSACTION-+ :tran_obj_hv-----------------> 
                         +-TRAN       -+
              
 >--END-EXEC----><

Parameters:

`connection_name`	The connection name OpenESQL uses to refer to the ADO.NET connection object.
`conn_name_hv`	Host variable which contains the connection name OpenESQL uses to refer to the ADO.NET connection object.
`conn_obj_hv`	Host variable where the ADO.NET connection object is specified.
`tran_obj_hv`	Host variable where the ADO.NET transaction object is specified.

Comments:

The named OpenESQL connection can use the existing ADO.NET connection and transaction objects in further EXEC SQL and EXEC ADO processing.

Example:

     EXEC ADO 
        BIND CONNECTION fred TO :con WITH TRANSACTION :tran
     END-EXEC