Telnet Reference > Editing QAD Enterprise Applications Telnet Scripts > Database Connection Parameters
  
Database Connection Parameters
The sample connection script on here is a local host connection—the QXI and the QAD Enterprise Applications receiver are on the same machine. You can also connect to QAD Enterprise Applications on a separate database server using a client/server connection.
Local Host Connection Parameters
If QXI is on the same server as the QAD Enterprise Applications databases, you can use local host or shared memory connections to access the databases. This can improve QXI performance by eliminating network overhead between the processes and the databases.
To enable local host connections, the QXI parameter files must contain the connection parameters described in Local Host Connection Parameters.

Local Host Connection Parameters
 
Parameter
Description
-db
The physical database name parameter. Follow this parameter with the path and physical name of a QAD Enterprise Applications database.
-trig
The triggers parameter. Follow this parameter with the name of the directory containing the database triggers for the main QAD Enterprise Applications database. This is the triggers subdirectory. The parameter value is: -trig triggers. This parameter is used only with main databases.
-ld
The logical database name parameter. Follow this parameter with the logical name of a QAD Enterprise Applications database. This parameter is used only with support databases.
Client/Server Connection Parameters
If QXI is on a different machine than the QAD Enterprise Applications databases, use client/server connections to access the databases. This can improve QXI system performance by spreading the QAD Enterprise Applications and QXI resource requirements between two servers. To enable the server processes to make client/server connections, the QXI parameter files must contain the connection parameters described in Client/Server Connection Parameters.

Client/Server Connection Parameters
 
Parameter
Description
-db
The physical database parameter name. Follow this parameter with the physical name of the QAD Enterprise Applications database. You do not need to include the path to the database file.
-trig
The triggers parameter. Follow this parameter with the name of the directory containing the database triggers for the main QAD Enterprise Applications database. This is the triggers subdirectory. The parameter value is: -trig triggers. This parameter is used only with main databases.
-ld
The logical database name parameter. Follow this parameter with the logical name of an QAD Enterprise Applications database. This parameter is used only with support databases.
-H
The host name parameter. Follow this parameter with the machine name or IP address of the QAD Enterprise Applications database server. This guide uses DBServer as an example in place of an actual machine name or IP address.
-S
The database service name parameter. Follow this parameter with a QAD Enterprise Applications database service name. You can use the Database Set Maintenance utility in MFG/UTIL to find the service name for a database.
-N
The network parameter. Follow this parameter with the network protocol used to connect to the QAD Enterprise Applications databases. This is TCP/IP. The parameter value is: -N tcp.
A Progress on UNIX example of a client/server connection would look like:
-db mfgprod -ld qaddb -H svr01 -S prod-srv -N tcp -trig triggers
-db mfghelp -ld qadhelp -H svr01 -S help-srv -N tcp
-db mfgadmin -ld qadadm -H svr01 -S admin-srv -N tcp