While calling a crystal report from ASPX i get the following error message:
Error in File C:WINDOWSTEMPReport1 {CB17A4FE-ECB0-4461-AB9C-0E07F8CDDB1F}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 102 ]
I have tried to verify the database and then call it again but in vain.
I have a Crystal Report which was running correctly in Visual Studio. I placed the .rpt file on our Test server and I tried to open it from another application. It is pointing to the same database. We are using SQL Server. It failed with this error:
Failed to retrieve data from the database. Vendor Code 102.
How can I debug this without being able to run the report in the other application? That application was written by another company and I don't have access to its source code.
why i am getting an error when i try to run my reports from a windows server 2003 service pack 2 X64
the reportviewer displays but the following error shows up
Failed to load Database information
Error in file (temporary file that the viewer creates.
i have done a crystal report in asp.net. i have a table called c_order it contains cust_id field, so while generating report itself i specified cust_id value but i have put a textbox and a button in the form which contains crystalreportviewer. so i need to enter a value in textbox and press the button then it should get value which match with the value in textbox with database and generate report.
View 1 RepliesI'm getting the "Load Report Failed" Error.
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
My reports works fine in my local machine. But when i pushed it to development server to test, it displays the following error:
Failed to load database information. Error in File C:WINDOWSTEMPReportViewer {2E85E5E2-D118-438D-BD62-9B30F2E6E224}.rpt: Failed to load database information. what i need to configure in development server or make changes in my code.
My report does not use data from a database. It uses a code generated dataset. How do I give crystal reports the necessary logon data to avoid database logon failures.
View 1 Repliesthough paramerter in crystal report with stored procedure
View 1 RepliesI have an error loading a report on my website
[URL]
This code:
[code]...
It generates the error: Load report failed.
What settings should I have on the server.
I have an vb 2005 asp application that will show a crystal report based upon a user selection which is a job number.On my development machine all work fine and the report is being shown every time.When I publish the application the web server it works for most part. Every so often for selected job numbers the report that will not display. When this happens there is a text being displayed above the business object banner:The Report Application Server failed I have checked the event log and there is no entries. Also there is no stack trace. The application seems to complete normally. I have compared the registry entries in HKEY_LOCAL_MACHINESOFTWARECrystal Decisions and they are the same id evelopment and production. I am referencingCrystalDecisions.CrystalReports.Engine version11.5.3700.0I am clueless and hoping that someone could suggest where to start looking
View 2 RepliesI just upgraded my development machine from Crystal Reports XI to Crystal Repors XI Rel2 so I could use the Graphic Location feature in CR. When I run my site locally, reports work great. When I deploy to the server, I get "Database logon failed." The Crystal Reports are not connecting to the database. They are connecting to datasets that are populated at runtime. The network admin said he upgraded CR on the server. The references in my solution that work when my app is deployed to the server are version 10.5.3700.0.
The references that do not work are 11.5.3700.0. I have made no other changes to my .net code.
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
View 2 RepliesMy Crystal Reports works perfectly when I have it on my local host, once I upload it to the server I get the error listed below. I ran the following MSI on the dedicated server: CRRedist2008_x86.msi.. If it is a permission issue, I am using Plesk Panel so there is no ASPNET user, it is different users, what user and what specific folder do I have to give permissions to? Retrieving the COM class factory for component with CLSID {5FF57840-5172-4482-9CA3-541C7878AE0F} failed due to the following error: 80070005.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {5FF57840-5172-4482-9CA3-541C7878AE0F} failed due to the following error: 80070005.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
i hv use a crystal report in my web application if i publish my application and run in iis on different system with diff server name the crystal report part cause problem login failed with server as name is alredy defined in crystal report at publish time.Can we define the name of server for crystal report in web.config.
View 5 RepliesCurrently, I have a page contains a report. But while I need to load the report for several times , the latest one I got the err about
'crystaldecisions.crystalreports.engine.logonexception load report failed'
What's the problem?
We are getting an error when ASP.Net tries to connect to Crystal reports Server.
I am running this in my local PC. The code is developed in .net Framework 3.5. The application is showing the following error.
Retrieving the COM class factory for component with CLSID {E063B04A-CB8B-460E-99D0-F7D8FA2FAAA2} failed due to the following error: 80040154
I am running the .net Framework 3.5 code in my system. AND asp.net version is 2.0
I have an application that uses Crystal Reports downloaded from SAP for Visual Studio 2012.
When I debug the software in Visual Studio it works perfectly fine, but when I deploy it and want to view the Crystal Report, I get the following error:
Server Error in '/' Application.Retrieving the COM class factory for component with CLSID {4DB2E2BB-78E6-4AEA-BEFB-FDAAB610FD1B} failed due to the following error: 80040154.
I wanted to post my problem and solution since I've gotten some good information on this board. When deploying my Visual Studio 2008 C# .NET 2.0 web application Production, I encountered some problems, which is not unusual. What was unusual is that my Crystal Reports .NET reports that use the Report Viewer control would not work; they errored out with:
note: Crystal Report works fine in dev environment....
Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Unable to connect: incorrect log on parameters.We are using Oracle 11g 64 bit as database. We establish crystal report database connection by two ways,
1. Microsoft OLE DB Provider for Oracle
2. Microsoft OLE DB Provider for ODBC
but we got the same error in report module when we using two methods.
Our Coding : //CrystalDecisions.CrystalReports.Engine.ReportDocument crpt = new ReportDocument();
private ReportDocument crpt = null;
private void Page_Init(object sender, EventArgs e) [code]....
I am displaying crystal report for particular 1 table
For example: in my crystal report i have displayed company name and amount
In that i have done every thing Company wise amount is being showed and total of each company is also been shown and grand total is also displayed i just want to know that can i save the displayed grand total in sql database using crystal report?
As I want that grand total in database..........
I'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I'm new to Crystal Reports and am just trying to add some simple reports to my web application. In the non-report pages I've been using SqlDataSources to retrieve data from the database and would like to do the same for the report pages. I saw a tutorial that indicated I could do this by explicitly setting the data source for the report in the Page_Load callback of the ASPX page as shown below:
[code]...
Is there a way to create "bound" fields w/o a database, since I'll be specify the database at runtime? Or is there a way to create the ".rpt" file w/ unbound fields, that get "bound" at runtime?Or is there a better way to do this altogether?
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
View 3 RepliesI have about 15 .RPT files on my .NET 2.0 site, and I recently changed to a new database server.
I successfully changed the Datasource on 14 of those .RPT files, but on one, after making the change, I get "Failed to Save Document" when I try to save the updated report. I can change the subreport's Datasource, and save it just fine, but when I try to change the main report's Datasource I get that error message.I'm definitely doing a "Verify Database" at various times throughout the process, but that doesn't seem to help.
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
View 1 Replies