Progress
DataServer for
Microsoft SQL Server
Guide


Starting a Local DataServer

This section describes how to start a local DataServer for SQL Server™ from the startup command.

Starting the Progress client starts the local DataServer. You include information about the ODBC data source, user ID, and password in the startup command.

To start the client, follow these steps:

  1. Make sure that your ODBC drivers are installed and configured properly.
  2. Start your SQL Server™ database.
  3. Set any environment variables required for your configuration as described in the relevant section of Chapter 3, “Configuring the DataServer” (for example, DSLOGDIR). You must set them in the shell from which you are starting the DataServer.
  4. NOTE: If you change the values of any environment variables, you must shut down the DataServer processes and restart them.

  5. Enter the following command:
  6. prowin32 schema-holder-name -db datasrc-name -dt MSS
      -ld logical-datasrc-name -U userID -P password 
    

    For example, the following command starts Progress with the local DataServer, connects a local schema holder named mssholder in single-user mode, and connects the SQL Server™ demo database with the user bob whose password is bobpass:

    prowin32 mssholder -db demo -dt MSS -ld demo -U bob -P bobpass 
    


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