Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Introduction : DataServer configurations : Configuring distributed DataServer applications using the Unified Broker Framework : Typical configuration scenarios
 
Typical configuration scenarios
In a distributed client-server configuration, the OpenEdge client runs on a client machine (either in Windows or on UNIX) and accesses a remote server on a Windows server where the broker for the DataServer for MS SQL Server is running.
Multiple NameServers and/or Unified Broker instances can be running simultaneously on one server machine. The DataServer client connects to a broker instance from OpenEdge Management or OpenEdge Explorer either directly or through a controlling NameServer. (See the important caution that follows.) It is then automatically reconnected to a DataServer established for it by the broker instance. Each executing broker instance can spawn a multitude of DataServer processes. A spawned DataServer process uses the ODBC driver to locate and connect to the data source. The actual target database might be either local or remote to the host machine. The schema holder can run on the client or you can locate it on any host that is accessible on your network. Each spawned DataServer can service database requests for the same database or for a different database than those of other spawned servers.
In remote DataServer configurations, OpenEdge handles the communication between the client and the server. OpenEdge Management or OpenEdge Explorer supports only the TCP/IP network configuration. Distributing the client and server components of the DataServer is only possible using DataServer broker instances of the Unified Broker. The Progress Application Server for OpenEdge (PAS for OpenEdge) does not support distributed DataServer components although the client component of the DataServer run from a PAS for OpenEdge can connect to a distributed server component in a DataServer broker instance of the Unified Broker.
Caution: In a run-time configuration, all DataServer clients should attach consistently either to a set of NameServers or to a set of brokers. Do not run brokers under controlling NameServers for one client while another client simultaneously attaches directly to a broker.
For more information, about configuring and connecting the DataServer, see:
*Configuring with OpenEdge Management or OpenEdge Explorer
*Starting and stopping a broker process from OpenEdge Management/OpenEdgeExplorer and connecting a client
For more information about the Unified Broker Framework, its elements, and how Unified Broker products such as the DataServer for MS SQL Server work within the framework, see OpenEdge Getting Started: Installation and Configuration.