beautypg.com

Creating a new odbc data source, Creating a new odbc data source -10 – Rockwell Automation 9301 Series RSView32 Users Guide User Manual

Page 210

background image

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. Spec
ify 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 fo
r 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.