Database connectivity with Crystal Reports

[Former Member]

Working with CR v13 has been completely unproductive so far. We never had this issue with v11. We've tried to connect to the database setting the Logon for the ReportViewer, setting the Logon for the Report itself, and setting the logon directly, but all of the methods we've tried create a logon error. When we step through the code we can see the correct logon parameters being set, but the report comes up with a "Database logon failed" error.

ReportDocument Report = new admin.AccountDebitsAndCredits();

Report.SetDatabaseLogon(strUser, strPassword, strServer, strDatabase);

CrystalReportViewer1.ReportSource = Report;

The SQL logs show that it is receiving the correct database name and the correct username, but gives an error that the password does not match. So it is not getting the password we send it.

[Former Member]

Hello:

From the Overview description of the Software Support and Maintenance:

Our primary goal is to engage in an open dialogue around support topics and to provide you the opportunity to share ideas and advice. Your comments help us to build a support and maintenance community that fit your needs. If you would like to know more about a specific topic or have feedback, please send us an email.

Please note that this query should be posted to the SAP Crystal Reports, version for Visual Studio. The overview of this Space:

SAP user community for SAP Crystal Reports, version for Visual Studio. Learn how to create & integrate Crystal reports into .NET applications and find the latest news, articles, tutorials, discussions, free downloads, blogs, sample apps, service packs and more.

I would move the post, unfortunately, I do not have the rights. And as I do not monitor this Space, I do not get notification of replies either. Thus the best thing will be to create a new post in the correct forum please.

- Ludek