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.