Database Configuration

In the following sections you will find an overview of the databases supported by the ASCII Adapter as well as information on how to configure these databases.

The table below also contains an overview of the possible values of parameter #DBServer in parameter file CRMASCAD . This parameter contains information on how to access the R/3 database server. This information strongly depends on the database used.

Overview:

Database Release	Value of #DBVendor	Value of #DBServer (delimited by blanks)	Files required from the R/3 Basis Runtime System	Comment
Oracle8i 8.1.x	DBSLORA	ALIAS	DBORASLIB.DLL	see 1)
MS SQL Server	DBSLMSS	INSTANCE [ALIAS]	DBMSSSLIB.DLL	see 2)
Adabas 7.3.0 (SAPDB)	DBSLADA	INSTANCE MACHINE [SERVICE]	DBADASLIB.DLL PCR71MD.DLL	see 3)
DB2 7.x for NT/AIX	DBSLDB6	ALIAS	DBDB6SLIB.DLL

Caution Caution

Please note that the files you need from the R/3 Basis Runtime System are not provided via the ASCII Adapter installation. You have to copy them manually from the R/3 Basis System running on Windows NT to the directory \Program Files\SAP AG\ASCII-Adapter\bin . These files do not require any further actions.

End of the caution.

Comments:

1) Note that R/3 database installations quite often use a server port different from the default port proposed by Oracle.

2) An alias for the server is not necessary as long as the database resides on the local machine.

3) The network protocol is always TCP/IP. The server port has to be specified by the TCP/IP service entry if it differs from the default port. A service entry has to be made in the SERVICES file for the TCP/IP protocol of the given machine.

Legend:

Value of #DBServer	Description
ALIAS	Alias of the server as configured in the vendor’s Configuration Utility .
INSTANCE	Instance of a database.
MACHINE	Name of the database server.
SERVICE	Name of an entry in the SERVICES file of the TCP/IP protocol. It informs you about the TCP/IP port that is used for the database on the server machine.