Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Configuring the DataServer : Configuring a remote DataServer
 

Configuring a remote DataServer

In configurations that include a remote host, two DataServer processes run on the host machine:
*Broker — The DataServer broker (_probrkr.exe) or the unified broker for OpenEdge Management or OpenEdge Explorer on the host machine determines the types of requests coming over the network and starts (spawns) the appropriate DataServer (_msssrv.exe) for the client process.
*DataServer — The DataServer (_msssrv.exe) on the host machine accesses the MS SQL Server database and communicates with the client process.
Note: The OpenEdge MS SQL Server DataServer component is an ODBC client with respect to the MS SQL Server database configuration even though from the OpenEdge point-of-view it resides on the server machine. As a result, your MS SQL Server client software must reside on the machine from which the DataServer and the broker processes will execute. In the remote DataServer configuration, the OpenEdge client component requires no special software or configuration; it only requires a standalone OpenEdge Windows or UNIX client. There are no OpenEdge restrictions regarding the location of the actual MS SQL Server database.
Before you can run the server components, you must configure the DataServer by setting the required environment variables on the host machine. In Windows, you configure the DataServer using OpenEdge Management or OpenEdge Explorer. See Configuring with OpenEdge Management or OpenEdge Explorer for details.
* Configuring with OpenEdge Management or OpenEdge Explorer
* Configuring from the command line