Overriding all database connection properties using ad hoc values

Instead of predefining the numbered database connections in ReCrystallize Server Settings, you may replace all database location properties that were originally set in the Crystal Reports designer with ad hoc settings. This approach may be useful when there are many possible database configurations or when the connection settings are not known in advance.

To use this method, include each of the following in the report request:

*If dbConn is included in the request, dbUser, dbPw, and dbDatabase (if required) must also be included in the request. When dbConn is detected, ReCrystallize Server will not attempt to validate these values and will not attempt to match any predefined database settings. If any of these settings is omitted or incorrect, the database login will fail.

For example, the following request overrides all table connection settings with these values:

Database server or DSN: MyDatabase
Database name: AdventureWorks
Database user: sa
Database password: secret

ViewReport.aspx?reportName=catalog.rpt&dbConn=MyDatabase&dbDatabase=AdventureWorks&dbUser=sa&dbPw=secret

Triple DES or AES encrypted values may be used with the same effect by including

DbConn-3DES, dbUser-3DES, dbPw-3DES, and dbDatabase-3DES or
DbConn-AES, dbUser-AES, dbPw-AES, and dbDatabase-AES.

!Use this approach with dbConn only when it is necessary to override all database location properties at runtime, without utilizing value predefined in ReCrystallize Server Settings. Any mistakes in the database settings may cause the report to fail.