Troubleshoot odbc data sets, Trace odbc calls – Rockwell Automation FactoryTalk Historian SE ProcessBook 3.2 User Guide User Manual

Page 295

Advertising
background image

7

Data Streams

277

An ODBC data set is created with a set of default placeholders. When it is
attached to a specific symbol, the query's placeholders can be customized
for that symbol, without affecting the placeholders defined for other
symbols using that data set.

For example, you can create a query for a database of laboratory data using
a text placeholder for the sample name. You can then use a different
sample name for every trend, bar, or value, rather than defining a new data
set query for each sample name.

Troubleshoot ODBC Data Sets

Data sets may be added, deleted, copied, or edited by selecting the New,
Delete, Edit, or Copy buttons in the Data Sets dialog box.

Columns are defined by the data set query. To see the columns returned by
the query, select the dataset when configuring a symbol to use it. The
dialog box shown from the Data Sets dialog box opened from the Tools
menu does not show the columns.

The Show Use button opens a dialog box that indicates what displays and
symbols include data from this data set.

Trace ODBC Calls

The ODBC Driver Manger provides an option for recording a log of all
calls to the Driver Manager from all ODBC clients. The default options for
ODBC are set to omit tracing and logging ODBC calls

If you choose to trace ODBC calls, you may suffer some degradation in
system performance.

Advertising