Progress
DataServer
for ORACLE Guide


DataServer Configurations

The Progress DataServer supports many possible configurations. There are two general types of configuration—local and remote—with several variations on each type:

Figure 1–4 shows a local DataServer configuration where all the modules run on one machine. In this case, the ORACLE database is also local.

Figure 1–4: The Local DataServer

Figure 1–5 shows a local DataServer accessing an ORACLE database on another machine through SQL*Net. To access an ORACLE8 database, this configuration can use SQL*Net or Net 8. You must install SQL*Net or Net 8 on the client machine.

Figure 1–5: A Local DataServer and Remote ORACLE Through SQL*Net

Figure 1–6 shows one possible configuration for the remote DataServer where a client accesses a remote DataServer for ORACLE. Here, the ORACLE database and the Progress DataServer are running on the same machine.

Figure 1–6: The DataServer for ORACLE-Remote

Figure 1–7 shows how you can combine clients and DataServers that run on different platforms. From your PC you can run a Progress client that accesses a remote DataServer on an NT workstation. This sample configuration has the schema holder on the PC client. You can optionally locate the schema holder on any host that is accessible on your Microsoft network.

Figure 1–7: The DataServer for ORACLE-Windows Client to NT Server

Progress handles the communication between the client and the DataServer. The client and server processes that make up the DataServer adapt to a variety of network configurations. Figure 1–8 shows a local self-serving client on a PC accessing an ORACLE database through SQL*Net. To access an ORACLE8 database, the same configuration can use Net 8 or SQL*Net.

Figure 1–8: Progress for Windows to ORACLE on UNIX

NOTE: Currently, it is not possible to use dblinks in an ORACLE7 database to point to an ORACLE8 database, nor is it possible to use dblinks in an ORACLE8 database to point to an ORACLE7 database.

In configurations that include SQL*Net or Net 8 there are no Progress processes running on the machine where ORACLE is running. You must install SQL*Net or Net 8 on the client machine.

The previous illustrations showed a few possible configurations. Table 1–1 lists all supported configurations. It considers possible client-server combinations and networking options.

Table 1–1: Supported Configurations
Client
Networking
DataServer
Progress on UNIX
None
DataServer, client, and ORACLE on the same machine.
Progress on UNIX
SQL*Net or Net 8
DataServer, client, and SQL*Net or Net 8 on the client machine, and ORACLE on a server.
Progress on UNIX
Progress
Client on the client machine, and the DataServer and ORACLE on a server.
Progress on Windows
SQL*Net or Net 8
DataServer, client, and SQL*Net or Net 8 on the client machine, and ORACLE on a server.
Progress on Windows
Progress
Client on the client machine, and the DataServer and ORACLE on a server.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095