Ok, I have a web app that displays Crystal Reports, these reports obtain their data from a Remedy DB(oracle me thinks, i dont manage it and people here are very protecting of their job security). When I setup these reports I connected to the DB without problems, using my username and pass.
I had no problem displaying the reports until today, my password for this user had expired, I changed it and now everytime I run the app and try to open a Crystal Report it prompts me for my user and pass, once I do this, the report displays without problem.
Is there a way to hard code this user and password? I cant use a non-expiring user for this db connection because we have the whole Single-sign-on thing here and this user is connected to a whole other host of services besides oracle(email, admin tools, etc)..
I know that hard coding users and passwords is a really bad idea ,specially for a web app, so if someone can offer any suggestions, I'll be more than grateful.
BTW, I am using Visual Studio.net 2005 Beta2
I had no problem displaying the reports until today, my password for this user had expired, I changed it and now everytime I run the app and try to open a Crystal Report it prompts me for my user and pass, once I do this, the report displays without problem.
Is there a way to hard code this user and password? I cant use a non-expiring user for this db connection because we have the whole Single-sign-on thing here and this user is connected to a whole other host of services besides oracle(email, admin tools, etc)..
I know that hard coding users and passwords is a really bad idea ,specially for a web app, so if someone can offer any suggestions, I'll be more than grateful.
BTW, I am using Visual Studio.net 2005 Beta2