You can put a client on one computer and the database server on another or the same computer. A client is an application that a user runs to request or modify information from a database by issuing SQL statements. The following IBM Informix tools are client programs:
The database administrator specifies the types of connections that the database server supports in the sqlhosts file on UNIX or the PROTOCOL field in the SQLHOSTS registry key on Windows.
Use a network protocol to connect to and transfer data between database servers, or between a client and a database server. You must establish a connection between the client and database server before data transfer can take place and you must maintain it for the duration of the data transfer.
A multiplexed connection uses a single network connection between the database server and a client to handle multiple database connections from the client. If you need to manage several hundred or thousands of client connections, consider ordering IBM Informix MaxConnect. For details, see IBM Informix MaxConnect (UNIX).
The database server supports the following types of connections to communicate between client applications and a database server.
| Connection Type | Windows | UNIX | Local | Network |
|---|---|---|---|---|
| Sockets | X | X | X | X |
| TLI (TCP/IP) | X | X | X | |
| TLI (IPX/SPX) | X | X | X | |
| Shared memory | X | X | ||
| Stream pipe | X | X | ||
| Named pipe | X | X |
For information about client/server configurations that the database server supports, see the IBM Informix Administrator's Guide. For instructions on how to use client applications, see the appropriate programmer's manual, as listed in Using the Documentation.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]