Rockwell Automation FactoryTalk Transaction Manager User Guide - Manual (Page 144)

●
●
●
●
●
FactoryTalk Transaction Manager User Guide
144
 Three sample programs: one each in Microsoft Visual Basic, C
Language, and Microsoft Visual C++ allow you to trigger a transaction
by entering a transaction name.
Running the Application
1. Open the ExternalTriggerSample.xls Excel spreadsheet and enter an
integer value in cell A1. This is the data value used by the transaction.
2. Create the ExternalTriggerSample table using the provided
ExternalApplication.sql script.
3. Create a System DSN (use ODBC Data Sources on the Microsoft
Windows 2003/XP/Vista/2008 R2 Control Panel) named ExtTrigger
that points to the Microsoft SQL table (ExternalTriggerSample).
4. Restore the FactoryTalk Transaction Manager configuration contained
in the ExternalTrigger.rsq file using correct host name paths. Start the
configuration, and wait for all traffic light indicators to turn green.
5. Select the programming environment that you will use, and open the
corresponding sample program from its appropriate subdirectory
(VB_Example.vbp, C_Example.dsw, Visual_CPP_Example.dsw).
6. Run the program and enter the ExternalTriggerTransaction transaction
name.
If you are using the Visual_CPP_Example.dsw, click Trigger to trigger the
transaction.
7. View the records that have been created in the database. A new row will
be created each time a transaction is triggered.
8. You can change the data value in the Excel spreadsheet or select another
option on the sample application screen.
If you are using the Visual_CPP_Example.dsw, you can continue to click Trigger.