Specifications

Configuring ODBC Data Exchange Reports
PlantScape Server and Client Configuration Guide 419
Specifying the SQL Database Login Details
Data Source Name
Enter the name of the data source for the database to which the report is to
connect. This name should match the Data Source Name entered when you
configured the ODBC System Data Source (see “Configuring the ODBC Data
Source” on page 417).
User Name
Enter the user login name that has permission to access the required
database. This field is optional.
Store User Password
Click this button to enter the password for the user login name that you
have specified.
Using the Report Status Information
The Report status field of the Configuration display shows one of the following
status messages:
WORKING
The report is running
GOOD
The last report completed without errors
ERROR
The last report completed with errors
Notes
1 If there are any syntax errors in the PlantScape server database references,
the report is halted, the errors recorded and no data is transferred between
the databases.
2 If an error occurs while transferring SQL commands to the ODBC driver, the
report is halted and errors recorded.
3 All syntax error messages are written to both the report output file and the
PlantScape server error log file.
4 All PlantScape server error messages are written to the PlantScape server log
file.
Making a Report Secure
Report Security Level
Use the combobox to select a report security level that will be required for a
user to demand a report.
plscpcg.book Page 419 Monday, May 28, 2001 10:11 AM