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

7–16

RSView32 User’s Guide
Example: Creating a new ODBC data source
This example shows how to create a new ODBC data source that
connects to an SQL Server database called Bakery. The SQL Server is
called Athena. The new data source will be called Bakery_Stats.
The data source will be used on the current computer only, but will be
used by multiple users at the computer. In this example, you will set up
the ODBC data log tables manually using Microsoft Query.
First, create the ODBC data source. Then set up the ODBC tables.
To create the ODBC data source:
1. In the Setup page of the Data Log Setup editor, choose the ODBC
storage format and click ... beside the ODBC Data Source field.
2. In the Select Data Source dialog box, click the Machine Data
Source tab and click New.
3. In the Create New Data Source dialog box, select System Data
Source, then click Next.