[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Crystal Reports 11, how to save SQL connection password?

Posted on 2006-06-04
Medium Priority
Last Modified: 2008-02-01
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?



Question by:TerryBurger
LVL 101

Expert Comment

ID: 16830254
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.

LVL 42

Accepted Solution

frodoman earned 1500 total points
ID: 16832722

I assume you're currently letting Crystal just prompt for a password when the report runs?  If so, simply hardcode the credentials into your application (or pull them from a web.config file if you prefer) and pass them to Crystal through your application.  If you need a code sample for that let us know.


Author Comment

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


Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month20 days, 8 hours left to enroll

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question