Progress
DataServer
for ODBC Guide


Starting a Local DataServer

This section describes how to start a local DataServer for ODBC 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. Follow these steps:

  1. Make sure that your ODBC drivers, as well as any client software required by the non-Progress data source vendor, are installed and configured properly.
  2. Start the supporting ODBC data source.
  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 environment from which you are starting the DataServer.
  4. NOTE: If you change the values of any environment variables such as ODBC_HOME, you must shut down the DataServer processes and restart them.

  5. Enter the following command:
  6. prowin32 schema-holder-name -1 -db datasrc-name -dt ODBC
      -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 odbholder in single-user mode, and connects the ODBC data source demo with the user bob whose password is bobpass:

    prowin32 odbholder -1 -db demo -dt ODBC -ld demo -U bob -P bobpass 
    


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