Using a remote DataServer configuration

DataServer for Microsoft SQL Server

Connecting the DataServer : Connecting a schema holder : Connecting a schema holder at startup : Using a remote DataServer configuration

The examples in the first part of this section show how to use specific command syntax to start OpenEdge in the following modes:

In single-user mode

In a remote DataServer configuration

With a local schema holder connected

With a MS SQL Server database connected

Note the following command syntax used in a Windows client:

Synrax

prowin32 schema-holder-name -1 -db datasrc-name -dt MSS
-ld logical-datasrc-name -H hostname -S service-name
-U userID -P password -Dsrv qt_debug,EXTENDED

Note the following command used on a UNIX client:

Syntax

pro schema-holder-name -db datasrc-name -dt MSS
-ld logical-datasrc-name -H hostname -S service-name
-U userID -P password -Dsrv qt_debug,EXTENDED

The examples in the second part of this section allow you to start OpenEdge in a remote DataServer configuration:

The schema holder's physical name is mssholder and it is read-only.

The data-source name is sports.

The data source type is MSS (Microsoft SQL Server).

The logical data source name is mydemo.

The host name is host1.

The service name is mssport.

The user ID is bob.

The password is bobpass.

Note the following command used in a Windows client:

prowin32 mssholder -RO -db sports -dt MSS -ld mydemo -H host1
-S mssport -U bob -P bobpass -Dsrv qt_debug,EXTENDED

Note the following command used on a UNIX client:

pro mssholder -RO -db sports -dt MSS -ld mydemo -H host1
-S mssport -U bob -P bobpass -Dsrv qt_debug,EXTENDED