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:
dbConn | The database server or ODBC DSN name. |
dbDatabase | The database name, typically used for SQL Server and left empty for Oracle. |
dbUser | The database username for login |
dbPw | The database password for login. |
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.
Post your comment on this topic.