IBM Netfinity 5100 8658 21Y, Manual

Page: 144 / 246

– ODBC support for one or more of the following
database management systems:
- IBM DB2
- Microsoft SQL Server
v OS/2
– Microsoft SQL Server (using the Visigenic driver
provided with Microsoft SQL Server)
or
– IBM DB2
For detailed information about supported ODBC
platforms, see Table 19 on page 137.
Note: The ODBC database name must not be longer than
8 characters.
ODBC database configuration
This section describes the procedures you must complete
before Netfinity Manager can create the Netfinity Database
Tables using ODBC.
1. Define the NETFIN ID so the Netfinity Database
Administration can create the Netfinity Database tables
with a table qualifier of NETFIN.
Attention: NETFIN is a restricted user ID. The
password is not retained by Netfinity Database
Administration after use. Do not use this ID for exports.
Notes:
a. In OS/2 and Windows 95, NETFIN must either be
the owner of the database or must be given
administrator authority.
b. In Windows NT, when exporting to DB2, NETFIN
must either be the owner of the database or be
defined as a system administrator through the NT
User Manager for Domains or the NT User
Manager.
In Windows NT, when exporting to MS SQL,
NETFIN must be the owner of the database or be
given table create rights.
2. Create the database with the appropriate relationship
with the NETFIN ID.
3. Make a database ODBC source either using the ODBC
tools shipped with the operating system or the
database.
4. On Windows NT, configure the Netfinity Support
Program to export data using the ODBC database.
a. Open Services from the Control Panel.
b. Click Netfinity Support Program from the
Services field, then click Startup .
134
: Netfinity 5100 Type 8658 Models 11Y, 21Y, 31Y,
41Y, 51Y, 1RY, 2RY, 3RY, 4RY, 5RY