Save the DB string connection

Hi,

Everytime I run the Crystal report it always ask me for the password, even though when i create the DB connection I declare the password. I check the property of my connection and it seems the password is not saved.

how can I save the password in CR so it wont ask me again for password everytime I run the report.

I am using OLEDB Provider for SQL Server to connect.

thanks!
AnvieAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
This tutorial has a wlakthrough on passing the password through code
http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf

mlmcc
0
 
mlmccCommented:
For security reasons, Crystal doesn't save the password.

How are you running the report?

mlmcc
0
 
AnvieAuthor Commented:
I run the report using visual studio 2005. I can pass parameter using VS then I tried to config the passing of password in web.config but no luck.

I will really appriciate if you can help me with this because I am dealing with this more than a week now ;-(

Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.