Creating a new odbc data source, Creating a new odbc data source -10 – Rockwell Automation 9301 Series RSView32 Users Guide User Manual
Page 210
7–10
RSView32 User’s Guide
To use the tables in an existing ODBC data source:
1.
Add fields for the data log data to the tables in the ODBC
database. See the example on page 7-16 for information about
adding fields to an existing table.
“Data log—ODBC format” on page 16-17 describes the order and
type of fields needed to log data to an ODBC database. Edit the
tables as described in the documentation for the ODBC relational
database you are using.
2.
Set up your data log model, as described in “Setting up a model”
on page 7-11. Specify the existing ODBC database as the ODBC
Data Source, and specify the tables you edited.
To create new tables in an existing ODBC data source:
1.
Specify the name of the existing ODBC data source in the ODBC
Data Source field of the Data Log Setup editor. See “Setting up a
model” on page 7-11 for more information.
2.
Click Create Tables. RSView32 automatically creates new data log
tables in the existing database. You can also create tables manually,
as described in the example on page 7-16.
3.
Set up the rest of your data log model, as described in “Setting up a
model” on page 7-11.
Creating a new ODBC data source
You can also create a new ODBC data source when you set up your
data log model, as described in “Setting up a model” on page 7-11.
RSView32 can create the ODBC tables automatically, or you can
create the tables manually. See page 7-16 for an example of how to
create a new ODBC data source.