Link to home
Start Free TrialLog in
Avatar of TerryBurger
TerryBurger

asked on

Crystal Reports 11, how to save SQL connection password?

Hi, for security and networking reasons I'm using an OLE-ADO connection to MS-SQL 2005 with an explicit SQL user (that has read only access to the tables needed). The report is published on a webserver (via an ASP.NET 2.0 website), and I need to hardcode the connection password within the report. How can I do that?


Thanks,

Terry

Avatar of Mike McCracken
Mike McCracken

I am not that familiar with the ADO connection method but don't you open the connection in the ASP application then bind it to the report?  In that case you don't put the password in Crystal but in the application.

I don't think you can store the password in Crystal.

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of frodoman
frodoman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TerryBurger

ASKER

Hi, I found code for hardcoding the password in ASP.NET. Thanks!


T