Oracle Reports Services Publishing Reports to the Web with Oracle9i Application Server Release 1.0.2 for Windows NT and UNIX Part Number A86784-02 |
Library | Service | Contents | Index

# E
Database Connection Strings

This appendix lists typical database connection strings that you or users can use when specifying report requests using the CGI or servlet. A database connection string is the value used in the USERID command line argument to connect to the database.

See Appendix B, "RWCLI60 Command Line Arguments" for more information about the USERID command line argument.

Database Connection String | Oracle Reports Services Response | User Action
--- | --- | ---
No USERID specified | Returns the database authentication form. | Types the Oracle or placeholder user name and password.
Oracle `username@database` | Looks for the Oracle user name and database pair in the connection string table to get the password. If Oracle Reports Services finds the password, then the report is run. | None.
If the password cannot be found, then Oracle Reports Services returns the database authentication form. | Types the database password.
Oracle `username/password@database` | Accepts the connection string and runs the report. | None.
Oracle `username/password` | Uses the local database and runs the report. | None.
If there is no local database, then Oracle Reports Services returns the database authentication form. | Types the Oracle database.
`<$username>@database` | Looks for the placeholder user name in the connection string table. If the user name cannot be found, then Oracle Reports Services returns the database authentication form. | Types the Oracle user name and password.
If Oracle Reports Services can find the placeholder user name in the table, then it looks for the Oracle user name and database name pair in the table to get the password. If Oracle Reports Services finds the password, then the report is run. | None.
If the password cannot be found in the table, then Oracle Reports Services returns the database authentication form. | Types the database password.
`<$username>/password@database` | Looks for the placeholder user name in the connection string table. If the user name is found, then Oracle Reports Services runs the report. | None.
If the placeholder user name cannot be found, then it returns the database authentication form. The user must authenticate to run the report. | Types the Oracle user name and password.

| Copyright © 2000 Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index