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:
- Local DataServer — All the DataServer software modules run on one machine. Your ORACLE database can also run on this same machine, or it can run on a separate machine that you access through SQL*Net or Net 8.
- Remote DataServer — The DataServer software modules run on different machines. Typically, the client module runs on one machine and the DataServer module runs on another. The machine on which the DataServer module runs is called the host machine. The host machine and the machine where the client is running can communicate through Progress networking (TCP/IP).
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.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |