Previous Topic Next topic Print topic


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
Previous Topic Next topic Print topic