Rockwell Automation 9301 Series RSView32 Users Guide - Manual (Page 219)

Configuring data logging

7–19
To set up the ODBC data tables:
You must have access to the SQL Server to log in and create the
tables.
1. Double-click Microsoft Query in the MSOffice directory and
choose Table Definition from the File menu.
2. In the Select Data Source dialog box, specify the data source you
just created and click Use. Enter your login ID and password.
3. Click New in the Select Table dialog box.
4. Enter information to set up the first field in a table called
TagTable:
Table Name: TagTable
Field Name: TagName
Type: char
Length: 255
5. Click Add.
6. Enter the following to set up the second field in the table.
Field Name: TagIndex
Type: smallint
In the Type field, choose the type that most closely matches the
SQL Data Type for the field you are adding, as listed in the tables
beginning on page 16-17.
7. Enter the following to set up the third field in the table.
Field Name: TagType
Type: smallint