水晶报表:数据库登录失败 [英] Crystal Reports: Database Logon Failed
问题描述
我在ASP.NET(C#)中,我使用SAP水晶报表的Visual Studio应用程序。在VS一切都运行完美。但是,当我把它部署到IIS数据库登录失败错误。当我设置CrystalReportViever启用数据库登录提示它让我询问用户名和密码,但不会产生错误,也显示了报告。我设置启用数据库登录提示仅用于测试目的,否则我通过发送登录参数
ReportDocument.SetDatabaseLogon(用户名,密码,我的DSN名称,)。再次,一切都运行完美的VS.
我在用:
- Windows 7企业版64位
- Visual Studio 2010中(C#)
- SAP Crystal Reports中,版本VS 2010
- 在我的IIS应用程序池的身份是NetworkServise
- 我从Oracle存储过程的数据汇集
- 我使用的系统DSN来连接数据库
I have application in ASP.NET (C#) in which I use Sap Crystal Reports for Visual Studio. In VS everything works perfect. But when I deploy it to IIS "Database Logon Failed" error occurs. When I set CrystalReportViever "Enable Database Logon Prompting" it keeps me asking for username and password but doesn't generate an error, nor shows the report. I am setting "Enable Database Logon Prompting" for testing purpose only otherwise I sending logon parameters by ReportDocument.SetDatabaseLogon(user, password, "my dsn name", ""). Again, everything works perfect in VS. I am using: - Windows 7 Enterprise 64 bit - Visual Studio 2010 (C#) - Sap Crystal Reports, version for VS 2010 - My App pool identity in IIS is NetworkServise - I am pooling data from Oracle Stored Procedure - I am using System DSN to connect to database
我期待着你的答案。先谢谢了。
I am looking forward for your answers. Thanks in advance.
推荐答案
谢谢大家的时间。
我用用户DSN之前和我无法打开连接。无法打开连接报告name'.rpt当我部署了我的申请。后来我改成了SystemDSN。 previous错误已经走了,但这次数据库登录失败错误发生。
I used User DSN before and I had "Failed to open the connection. Failed to open the connection 'report name'.rpt" when I deployed my application. Afterwards I changed it to SystemDSN. Previous error was gone but this time "Database Logon failed" error occured.
最后,我已经改变连接形式系统DSN Oracle服务器解决我的问题。现在一切都工作得很好。考虑这一点,如果你有同样的问题。
Finally I have solved my problem by changing connection form System DSN to Oracle Server. Everything works very well now. Consider this if you have same problem.
这篇关于水晶报表:数据库登录失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!