Progress
DataServer for
Microsoft SQL Server
Guide


DataServer Components

The DataServer for SQL Server™ is available in two versions:

For more details on the differences between the two versions, see Introduction."

Before you configure a DataServer, you must register your SQL Server™ database as an ODBC data source. For details, see the "Registering Your Data Source" section.

To set up a DataServer configuration, determine which components you need on which platforms, then set up the appropriate executables on those platforms. Table 3–1 lists the possible combinations and describes which executables you must set up on each machine. In this table, the term local indicates that the DataServer component runs on the same machine as the client, while the term remote indicates that the component runs on a different machine than the client.

Table 3–1: Installing the DataServer Components
Client
DataServer
Installing and Configuring
NT
Local NT
Use the default Progress client executable (prowin32.exe). The server component is embedded in the client executable.
Windows
Local Windows
Use the default Progress client executable (prowin32.exe). The server component is embedded in the client executable.
NT or Windows
Remote NT
On the client machine, use the default Progress client executable (prowin32.exe).
On the host machine, do one of the following to make a connection to the default DataServer executable (_msssrv.exe):
    • Use the default broker executable (_probrkr.exe) from the command line or configure it using ProControl.
    • Use the Java-based broker executable (mssman) from the command line or configure it using the Progress Explorer.
This configuration is available only on the Enterprise DataServer for SQL Server™.
UNIX
Remote NT
On the client machine, use the default Progress client executable (_progres).
On the host machine, do one of the following to make a connection to the default DataServer executable (_msssrv.exe):
    • Use the default broker executable (_probrkr.exe) from the command line or configure it using ProControl.
    • Use the Java-based broker executable (mssman) from the command line or configure it using the Progress Explorer.
This configuration is available only on the Enterprise DataServer for SQL Server.

NOTE: You can optionally build custom DataServer executables using the Progress PROBUILD utility. See "Building DataServer Executables," for instructions. This is typically useful only on UNIX platforms.

For instructions on setting up your DataServer configuration, see the sections that apply to the platforms that you will use. For example, if you are configuring a local DataServer, see the "Configuring a Local DataServer" section. If you are building a remote DataServer configuration host, see the "Configuring the Remote DataServer" section.


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