94 Net finity 3500 -M20 – T ype 8657 Mod els 21 Y, 2 2Y, 31Y, 32Y ,
— ODBC support for on e or mo re of the f ollowing
dat abas e managem en t systems (DBMS):
– IBM DB2
– Micro soft SQ L Serve r
• Windows 95, with:
—ODBC
— ODBC support for on e or mo re of the f ollowing
database management systems:
– IBM DB2
– Micro soft SQ L Serve r
•OS/2
— Microsoft SQL Server (using the Visigenic driver
provided with Microsoft SQL Server)
or
— I BM DB2
For detailed informati on about supported O DBC pl at-
forms, see Table 15 on page 97 and Table 16 on page
98.
Note: The OD BC da ta base nam e mu st not be lo ng er t ha n 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 i s not retain ed 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 o f the databa se or must be given
administr ator authority.
b. In Windows NT, when exporting to DB2, NETFIN
mus t eit her be the owner of the database or be
defined as a system administrator through the NT
User Manager for Domains or the NT User Man-
ager.
In Windows NT, when exporting to MS SQ L, NET-
FIN 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. Mak e a data bas e OD BC sour ce eith er us ing t he ODBC
tools shi pped with the operating system o r the data-
base.
4. On Windows NT, configure the Netfinity Support Pro-
gram to export data usi ng the ODBC database.
a. Open Services from the Control Panel.
b. Click Netfinity Support Program from the Ser-
vices field, then click Startup.