Crystal报表登录失败 [英] Crystal report logon fail

问题描述

我使用Oracle 10g XE作为数据库，使用Visual Studio 2005 Prof.版本开发基于WEB的应用程序。

我有两个使用Crystal报告设计的水晶报告（随VS 2005一起发布），

其中一个报告中，我使用了来自oracle服务器的直接连接，而在另一个报告中，我使用了在web项目中设计的现有数据集。

我在两个报告中使用了相同的数据表。在具有水晶报表查看器控件的页面的代码隐藏文件中，我通过Page_Load事件中的代码传递了登录信息。

（

ConnectionInfo connInfo = new ConnectionInfo < font size = 2>（）;

connInfo.ServerName = " xxx" ;

connInfo.DatabaseName = " yyy" ;

connInfo.UserID = " abcd" ;

connInfo.Password = " aaa" ;

.....等等......其中xxx是实际的服务器名称，yyy是数据库名称等等）

现在报告中有直接数据库连接WORKS，但是与DATASET连接的报告给出了以下运行时错误 -

"登录失败。详细信息：crdb_adoplus：未将对象引用设置为对象的实例。文件C中出错：\ DOCUME~1 \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ >

由于数据集也使用相同的连接，为什么它不能与数据集一起使用？我还使用了"推"。数据集的方法仍然不起作用并给出了上述错误。

问候，

Shrikant

解决方案

我有很多Oracle XE和Oracle 10g都存在问题。我发现只有一种连接类型实际上正常工作，那就是Microsoft OLE DB Provider for Oracle。所有其他连接类型（Oracle Server，Crystal Oracle ODBC）一直给出错误，因为Crystal Oracle ODBC（crdb_oracle）给出了类似的错误。我已经尝试了各种方法来绕过它，但没有任何作用，Crystal本身根本没用。我建议尝试OLE DB类型的连接，如果有可能，因为我从来没有任何错误。

Hi,

 

I am using Oracle 10g XE as database, and Visual Studio 2005 Prof. edition for developing a WEB based application.

 

 I have two crystal reports designed using Crystal report (coming with VS 2005),

 

In one of the reports, I used direct connection from the oracle server, and in another report I used an existing Dataset designed in the web-project.

 

I used the same datatable in both the reports. In the codebehind file of the page which has the crystal report viewer control, I passed the logon information through code in the Page_Load event.

(

ConnectionInfo connInfo = new ConnectionInfo();

connInfo.ServerName = "xxx";

connInfo.DatabaseName = "yyy";

connInfo.UserID = "abcd";

connInfo.Password = "aaa";

.....and so on...where xxx is the actual server name, yyy is database name, etc)

 

Now the report which has direct database connection WORKS, but the report which has connection to DATASET gives the following runtime error -

 

"Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File C:\DOCUME~1\admin\LOCALS~1\Temp\test {8D903C47-3E56-4A28-B80E-62E8E7FCF97A}.rpt: Unable to connect: incorrect log on parameters"

 

Since dataset also uses same connection, why doesn't it work with the dataset? I also used "push" method for the dataset, still it doesn't work and gave the above error.

 

Regards,

Shrikant

 

解决方案

I had many problems with both Oracle XE and Oracle 10g.  I have found only one connection type that actually works properly and that is Microsoft OLE DB Provider for Oracle.  All the other connection types (Oracle Server, Crystal Oracle ODBC) keep giving errors the Crystal Oracle ODBC (crdb_oracle) give a similar error to yours.  I have tried every way to get round it but nothing works and Crystal themselves are no use at all.  I suggest trying the OLE DB type of connection if it is possible as i never had any errors with it.

 

这篇关于Crystal报表登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！