RAS 9.0 ODBC Password

[vannojl]

How can I automate the ODBC password in a report using RAS 9.0?

We are creating reports in CR 9.0. These reports include subreports based on two different databases, each with their own DSN. Accessing the reports through the ePortfolio Light, the users are prompted for two sets of username/password.

 

[sbdavis]

The simplist solution is to just store the passwords in the ODBC registry entry. Look for the ODBC entry (same location as the username), create a String Key named "Password", and store the Password. Note this works for CR9 and RAS9.

I have put detailed instructions into a similar thread.

Steve