Crystal Reports :: Logon Failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description

Feb 24, 2011

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]....

View 3 Replies


Similar Messages:

Crystal Reports :: VS2008 Crystal Reports - "Load Report Failed - Error"?

Jul 25, 2010

I'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.

View 1 Replies

Crystal Reports :: How To Avoid Logon Parameter Of The Databse Data Creating The Crystal

Dec 25, 2010

I am creating the crystal report without database data, just i am read the data from text file and fill into dataset then genrate the crystal report but problem is here if i am export the crystal report into different format so he wants the database logon parameter.so in this case i have no database crendential because i am creating the report without database.

View 1 Replies

Crystal Reports :: Getting An Error - Failed To Load Database Information?

Apr 14, 2010

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.

View 2 Replies

Crystal Reports :: Paging Error - No Valid Report Source Is Available?

Aug 14, 2013

i have a load report on asp page

i have load report on button click

but when i click on next navigation button 

then it gives me error with popup

"No valid report source is available."

my code is:

protected void Button1_Click(object sender, EventArgs e) { GetData();
}
private void GetData() {
SqlConnection connection = new SqlConnection(strcon); SqlCommand command = new SqlCommand("Select * from demoforreport WHERE role='" + TextBox1.Text + "'", connection); SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet dataset = new DataSet(); adapter.Fill(dataset, "demoforreport"); ReportDocument CustomerReport = new ReportDocument(); CustomerReport.Load(Server.MapPath("CrystalReport.rpt")); CustomerReport.SetDataSource(dataset.Tables["demoforreport"]); CrystalReportViewer1.ReportSource = CustomerReport; CrystalReportViewer1.DataBind(); }

View 1 Replies

Crystal Reports :: Retrieving The COM Class Factory For Component With CLSID Failed Due To The Following Error: 80040154

Dec 1, 2010

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

View 1 Replies

Crystal Reports :: Retrieving COM Class Factory For Component With CLSID Failed Due To Error 8004015

Mar 5, 2014

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.

View 1 Replies

C# - Programmatic Logon To Crystal Reports Server?

Jan 9, 2010

I have a Web Forms app that uses forms authentication. I have a Crystal Reports Server 2008 V1 server with InfoView .NET installed and working. I have some Enterprise accounts setup. EDIT: I should mention that my Web Forms app is on a different server from Crystal Reports Server.

I need to know how to log on to InfoView .NET programmatically on my custom ASP .NET page (C#) and then transfer the user to InfoView without them having to type in the logon information.

Something like this would be nice (C#):

string username = "blah";
string password = "asdf";
// create logon token for crystal reports server
// .. // this is the code I need
Response.Redirect(url);

I did find this question, which gets me partway there, but it doesn't tell me how to pass the token to InfoView .NET. Some older docs also mention needing a cookie. I've also found other sites that show how to pass it to Java InfoView, but I need the .NET version.

View 1 Replies

Crystal Reports :: Programmatically Logon To Database

Dec 15, 2010

My report is using two (2) different databases, how can I programmatically logon to each database? I am using Visual Studio 2010, in preview mode the report populates with no problems. I am using the standard code to login to a single database, but unsure on how to pass values for the second.

View 1 Replies

Crystal Reports :: Using Crystal Reports W/ Sql Data Source?

Feb 19, 2011

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?

View 5 Replies

Crystal Reports :: Duplicate .vb Code Behind Files / Getting Error?

Apr 23, 2010

I have a weird problem that I am struggling with. We have a legacy project (VS 2003), and all I have to do is change a Crystal Reports label, when I change it and save it creates an additional code behind file. So after saving I have the file rptInvoice.rpt with two dependant files rptInvoice.vb and rptInvoice1.vb. I have no idea why it is creating an additional file but it is causing a compiler error.

View 1 Replies

Crystal Reports :: Debug Error "Failed To Retrieve Data From The Database"?

Jul 8, 2010

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.

View 1 Replies

Crystal Reports :: How Crystal Report Read Connection String From Web.config Using Entity To Sql

Feb 9, 2011

<connectionStrings>
<add name="SchoolEntities" connectionString="metadata=res://*/SchoolModel.csdl|res://*/SchoolModel.ssdl|res://*/SchoolModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.;Initial Catalog=school;User
ID=sa;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
</connectionStrings>

how report read this connection string

View 2 Replies

Crystal Reports :: How To Use A Connection String From Web.config For Crystal Report

Dec 27, 2010

Is there anyway to use a connection string from web.config for Crystal Report? The problem I'm having is that I develop on two different computers and on each I use a different IP to connect to the SQL Server. And when I deploy to a web server I use "localhost". So each time I get prompted for changes from the Crystal Report...

View 8 Replies

Security :: Impersonation / Getting Error / Login Failed For User 'NT AUTHORITYANONYMOUS LOGON

Aug 16, 2010

I'm running IIS 6.0 on a Windows 2003 server and running an ASP.NET 4 application which connects to an SQL Server 2005 database on another server. I have my Default.aspx page set to Windows authentication with anonymous access disabled.

When I load up the page it asks for a username and password (as expected), I enter my credentials and it comes up with the following error:Login failed for user ''. The user is not associated with a trusted SQL Server connection.

If I add the following to my web.config file: <identity impersonate="true"/> then I get the following error:

Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.

And if I add the <identity impersonate> tag set to true and with my username and password included it connects successfully.

I can't leave this in there as I want each user to connect as themselves, so why is the server not using the credentials that I enter when prompted to connect to the database ?

View 5 Replies

Crystal Reports :: Exporting Works In HTTP Error - Unable To Evaluate Expression Because The Code Is Optimized

Feb 9, 2010

I am using asp.net 2.0 with c#.

" myReportDocument.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, rptName);"

As soon as compiler execute this statement i get error

" [System.Threading.ThreadAbortException] = {Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.} "

What will be the possible reasons for the error.

Although it throws execption but it will allow to convert report when i deployed my site using http but when i deployed my site using https then it will shows error .

View 1 Replies

Crystal Reports :: Crystal Reports Error When Publishing A Website On To The Web

Feb 4, 2011

Crystal

Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception

View 3 Replies

Crystal Reports :: How To Fix The Details Section Height

Aug 28, 2010

I have an issue while working with a Crystal Report 10.0 I am printing a Students records in a pre-define format. now the detail section is dymaically change beacuse of No. of records for the studentsfor some students there are 8 record ,& for some other students only 2 records are theirbecause i am printing on pre defined format when 2 records comes in the details section it is placing the reords at wrong places

View 1 Replies

Crystal Reports :: Duplicate Values In Details Section

Feb 5, 2010

I have the following tables:ACTNUM in ACT1 and ACT2 is linked to ACTNUM in ACT0. I am using ACT0.ACTNUM for grouping (I want to display all MEMOTEXT and all Desc for each ACTNUM). the poblem is that I am getting duplicate values in the details section although the dataset is being filled without those duplicate values.

View 1 Replies

Crystal Reports :: Failed To Export Using Options Specified?

Mar 8, 2013

though paramerter in crystal report with  stored procedure 

View 1 Replies

Crystal Reports :: Failed To Retrieve Data From The Database?

May 16, 2010

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.

View 4 Replies

Crystal Reports :: Load Report Failed In Website?

Sep 13, 2010

I 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.

View 2 Replies

Crystal Reports :: The Report Application Server Failed?

Feb 28, 2011

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 Replies

Visual Studio :: RE: VB.NET And Crystal Reports - Login Failed?

Mar 14, 2011

I 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.

View 1 Replies

Crystal Reports :: Either The Crystal Reports Registry Key Permissions Are Insufficient Or The Crystal Reports Runti?

Aug 5, 2010

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 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved