Connecting to a MS SQL Server DataServer broker using the NameServer

DataServer for Microsoft SQL Server

Configuring the DataServer : Configuring a remote DataServer : Configuring with OpenEdge Management or OpenEdge Explorer : Connecting to a MS SQL Server DataServer broker using the NameServer

This section presents an example of how to connect to a MS SQL Server DataServer using the NameServer.

To connect to a MS SQL Server DataServer using the NameServer:

1. Create a schema holder.

2. Set your MS SQL Server instance username (-U) and password (-P) connection parameters for the schema holder.

Progress Software Corporation recommends that you use the -U and -P convention to establish the username and password.

3. Set up your connection, using parameters to run the schema holder. This step shows examples from which you can model your connection:

a. The following example shows how to set up the connection in Windows in a single-user mode:

prowin32 f:\wrk\holder -1 -RO -db MSS_DB_DSN -ld MSS_DB_INS -dt MSS -H MSS_DSRV_Host -S 5162 -DataService mssbroker1 -Dsrv SVUB,1

Note that although the schema holder is defined as a single-user mode, access to the MS SQL Server instance is in multi-user mode.

b. The following example shows how to set up the connection in Windows in a multi-user mode:

prowin32 holder -H MSS_DSRV_Host -S Holder_Service -db MSS_DB_DSN -ld MSS_DB_INS -dt MSS -H MSS_DSRV_Host -S 5162 -DataService mssbroker1 -Dsrv SVUB,1

c. The following example shows how to set up the connection on UNIX:

mpro holder -H MSS_DSRV_Host -S Holder_Service -db MSS_DB_DSN -ld MSS_DB_INS -dt MSS -H MSS_DSRV_Host -S 5162 -DataService mssbroker1 -Dsrv SVUB,1

The following list identifies the values used in the examples shown in Step 3:

MSS_DB_DSN

Identifies the ODBC Data Source name.

MSS_DB_INS

Identifies the MS SQL Server instance name.

MSS_Dsrv_host

Identifies the name of the MSS DataServer broker host.

5162

Identifies the NS1 NameServer default port where the MSS broker is registered.

Holder_Service

Identifies the service name used to server the database holder; however, it can also be a port number.

For details about the database connection parameters noted in each example in of this procedure, see Connecting a schema holder at startup.

Caution: Do not simultaneously run some DataServers for MS SQL Server under brokers with controlling NameServers and others directly under brokers (that is, without controlling NameServers). This defeats the purpose of using a NameServer to control brokers. If you do this, the benefits of the NameServer are lost and load balancing is ineffective. Progress Software Corporation (PSC) recommends that you always use a NameServer, with one exception: you can choose initially to connect directly to a broker to simplify confirming an initial connection. Once you establish a connection, PSC recommends that you reintroduce the NameServer into your configuration.

Once you have completely set up your environment, you can build the schema holder for your MS SQL Server database. See Creatinga schema holder for instructions.