Configuring the study to use the randomization DSN

After manually creating a randomization source DSN for a study, you must configure the study to use the DSN.

Note: This step is necessary only if you use the Control Panel ODBC manager to create the randomization DSN. If you use the pfadmin utility, it configures the study to use the randomization DSN.

Configure each study separately. Use pfadmin to do this:

Open a Command Prompt window.
Change to the \bin directory in the InForm software installation.
If you have a Microsoft Access randomization source database, enter the following command:
pfadmin CONFIG Trial <StudyName> /RndDSN DSN
- StudyName is the name of the study.
- DSN is the name of the randomization source DSN. For more information, see ODBC connection for the randomization database.
If you have an Oracle randomization source database, enter the following command:

pfadmin CONFIG Trial <StudyName> /RndDSN DSN
- StudyName is the name of the study.
- DSN is either the:
  - Name of the randomization source DSN—When the randomization tables are in a separate database from the study database.
  - Name of the study DSN—When the randomization tables are part of the study database.
  For more information, see ODBC connection for the randomization database.
When prompted, enter:
- The name of the study schema owner.
- The password of the study schema owner.
  Note: The schema owner UID and PID must begin with a letter and contain alphabetic or alphanumeric characters. Do not use all numeric characters.
Examples:
- Microsoft Access randomization source database:
  PFAdmin config trial pfst60 /RndDSN pfst60RND
- Oracle randomization source database:
  PFAdmin config trial pfst60 /RndDSN pfst60RND