how to auto update password using crystal report 2013 and oracle Db server

[former_member232370]

I have customer seeking help "I am using Crystal Report 2013 desktop tool to connect to Oracle DB server and each time when I have to refresh report I get below connection window. Is there any way I do not have to input password to edit/update report? Our company’s policy is to change the DB password frequently so in order to comply with that is there any way I can save password somewhere in the connection to use it without being prompted for inputting password?

also Same thing when I use CMC, I have 70-80 scheduled reports already, is there any way I can update password for all at the same time?

[abhilash_kumar · Accepted solution]

Hi Fahad,

CR Designer does not save database password. If you don't wish to be prompted for database credentials, you'd need to recreate the connection and set it to use OS Authentication (assuming the Oracle DB is also setup to accept windows credentials).

-Abhilash