Progress
DataServer for
Microsoft SQL Server
Guide
Configuring the 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 broker for the Progress 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 SQL Server™ database and communicates with the client process.NOTES:
- The Progress SQL Server™ DataServer component is an ODBC client with respect to the SQL Server database™ configuration even though from the Progress point-of-view it resides on the server machine. As a result, your 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 Progress client component requires no special software or configuration; it only requires a standalone Progress NT or UNIX client.
- There are no Progress restrictions regarding the location of the actual 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. On NT, you configure using ProControl or the Progress Explorer tool. See the "Configuring with ProControl" or the "Configuring with the Progress Explorer" section for details.
NOTE: Configurations that use a remote DataServer on NT are available only with the Enterprise DataServer for SQL Server™.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |