Can I pass username & password in JDBC URL in Crystal Reports 2008?

[Former Member]

Hi,

I tried to put this URL in the CRConfig.xml file : jdbc:postgresql://hostname:5432/db_name?user=user_name&password=pw

Without the user and password parameters, it works fine but I always have to enter the database information when I create a new report or refresh an existing report.

With the parameters, when I create a new report, if I click on "Create new connection", Crystal Reports freezes. If I click on the connection in "My connections", then I get an "Invalid argument" error message.

How can I configure the database information so that I don't always need to enter it manually?

Thanks,

Marianne

[former_member11696]

Hi Marianne,

We don't recommended you do that. The text is in the clear so anyone could use your log on info. You may be able to add your user name to the Report by editing the connection properties from the Set Location dialog box but to add your password would give anyone who opened your report your log on info.

And the info would be passed to the DB over the network in the clear so someone could hack your info.

Thank you

Don