Instruction Manual

Application notes for FactoryTalk Transaction Manager Appendix D
The Database Connection Definition dialog box appears.
18. Make sure that the user and password boxes are blank.
The following data types are supported by SQL Server:
•
bigint
• binary
• bit
• char
• datetime
• datetime2
• decimal
• float
• image
• int
• money
•
numeric
• real
• smalldatetime
• smallint
• smallmoney
• sysname
• text
• tinyint
• varbinary
• varchar
• varchar
Keep the following behaviors in mind when you are specifying
substitution options for FactoryTalk data points.
NOTE
The following behaviors assume that the device is properly connected
when the transaction executes.
If you select this option:
And the device is off at startup,
then the transaction:
And the device is on at startup, then
the transaction:
No Substitution Fails because a required data point was not
available.
For corrective action information, see the
possible solution section for error 33080.
Fails because a required data point was not
available.
For corrective action information, see the
possible solution section for error 33080.
Substitute Value Uses the specified substitute value and
quality is set to 1.
Uses the specified substitute value and
quality is set to 1.
Data types supported by SQL
Server
Behaviors when setting
substitution options for
FactoryTalk data points
Rockwell Automation Publication BZWARE-IN001M-EN-P-June 2014 289