Download Multitech MT1932ZDXI System information

5.1 Database Support with ODBC Drivers
This section shows the new ability of TME 10 NetFinity to use the ODBC
interface. ODBC drivers in Windows allows you to access many different
database products through a standardized interface.
Microsoft′s ODBC provides a common SQL (Structured Query Language) syntax
for communication between applications and database management systems
(DBMS). Depending on the DBMS, the driver interprets the SQL statement from
the application and translates it to the appropriate statement for the DBMS.
Through the appropriate driver, even non-SQL DBMS such as DBASE or even flat
files can be handled as if it were SQL data source, within applications.
With the implementation of the ODBC interface into TME 10 NetFinity, a much
wider range of databases is supported. Theoretically, every database that
provides an ODBC driver for Windows NT is accessible from TME 10 NetFinity.
There is still the possibility to export the data to the IBM DB2 database directly
in the same way as in NetFinity for OS/2.
5.2 TME 10 NetFinity with IBM DB2 for Windows NT Using ODBC
This section leads you through the steps required to enable data to be exported
from TME 10 NetFinity into an IBM DB2 for Windows NT database through the
ODBC Interface Driver.
5.2.1 Setup DB2 for Windows NT and Create Database
Before you start the installation, make sure you are logged on to Windows
NT with administrators rights and with a user ID that is less then 8
characters. Therefore, using the Administrator user ID would not be a valid
choice. You may need to create a new ID with administrator rights.
1. Install IBM DB2 for Windows NT on the TME 10 NetFinity Manager System.
You can either install from diskettes, CD ROM or a LAN drive. For detailed
information about installing DB2 refer to IBM Database 2 for Windows NT,
Installation and Operation Guide, Version 2 , S33H-0312-00.
2. Create the database instance.
For starting the database automatically on a server, it must be defined as a
unique instance to the system. Use the DB2ICRT.EXE tool in the \SQLLIB\BIN
directory to create this instance with the instance name. This name must not
interfere with Windows NT service names and must follow the directory
name convention (without extension). Use the format DB2nnnnn, where
nnnnn is your chosen name. The following command will create a DB2
instance with the name DB2NETFS:
DB2ICRT DB2NETFS
3. Configure DB services to start automatically.
For productive environments the DB Services must start automatically. To
achieve this, set the Startup Type in the NT Service Manager for the Services
DB2 - Instance name and DB2 Security Server to Automatic.
124
Systems Management from an NT Server Point of View