Disclaimer: The information provided on DevExpress.com and affiliated web properties [including the DevExpress Support Center] is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confindential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
I am trying to embed a Crystal report in an ASP.NET 2005 web page, but every time I run the page I get the following error:
Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File C:\DOCUME1\PB_IT_AN\ASPNET\LOCALS1\Temp\DIPSummary {DC347D6B-44F8-441F-8940-4A16ACB54E76}.rpt: Unable to connect: incorrect log on parameters.
I have set up the report using a simple xsd schema in my project which corresponds to the data being extracted from the database [SQL Server 2000] elsewhere within the project. This is being populated into a datatable [dtPCDipSummary] which is then put in a dataset and used as the data source for the report. My code is as follows:
DSDipSummary.Tables.Add[dtPCDipSummary];
oRpt.Load[Server.MapPath["DIPSummary.rpt"]];
oRpt.SetDataSource[DSDipSummary];
crvDIPSummary.ReportSource = oRpt;
crvDIPSummary.DataBind[];
I don't understand what the report is trying to log on to, as the only thing it points to is the schema definition within the project - no reference to an external database.
I have scanned through numerous references to the same error on the internet and tried everything I thought might help but without success.
After banging my head into the wall with this issue for about a day, I realized that I had specified two linked tables in the Database Expert window, but was only setting the datasource for one table. It turns out that I only needed one table for the report so removing the extra one fixed this problem for me. I assume that setting the datasource for the second table would also have fixed the problem, but I didn't test that. This particular scenario is especially frustrating because the error message has nothing to do with the actual problem. Hope this helps someone else. Title: Deployment with crystal report problem Name: Aravinda Date: 2011-12-05 1:59:21 AM Comment: I'm having a problem with my crystal report when deploying to the client machine. The Problem is when i tried to run my software to the client machine its runs smoothly but when i try to load my report , it requires me to enter LOG ID and PASSWORD, but in my computer where i built the software, when i try to load the report , there's is no LOG ID and PASSWORD .. I'am sure to myself that my database does not have a password and dont also set any security to my app .. Why is this happening? Can anyone help me? Title: Deployment with crystal report problem Name: Joyce Romo [AppDev - Beginner] Date: 2011-09-26 4:44:24 AM Comment: I'm having a problem with my crystal report when deploying to the client machine. The Problem is when i tried to run my software to the client machine its runs smoothly but when i try to load my report , it requires me to enter LOG ID and PASSWORD, but in my computer where i built the software, when i try to load the report , there's is no LOG ID and PASSWORD .. I'am sure to myself that my database does not have a password and dont also set any security to my app .. Why is this happening? Can anyone help me? Title: Thanks for Lesson 1 Name: Andrew Websdale Date: 2011-01-31 5:43:23 AM Comment: Thanks for this - we've got loads of old reports that are set to ODBC. Interestingly the COM component [craxdrt] doesn't care what method the report uses to connect to the DB, you just updated it at runtime. We're currently updating to using the .NET crystal reports runtime instead. So all our reports that worked fine with OLE DB & COM don't work with the .NET version, which means we have to change 100+ reports[with many tables each] to accommodate the "improvement"[NOT]. Well done, Business Objects/SAP - less than impressed with this. Title: database login failure Name: joseph Date: 2010-10-21 10:51:50 AM Comment: i am using visual studio 2008 n c#.net. I created a crystal report and connected to MS Acess database, but when debugging ,when crystalreportviewer is called, is asking for a login n password to login to database. i am sure i hadnt given anything like that while connecting...Plz help Title: Logon Failed Pull Reports Name: Joe Rich Date: 2010-10-04 9:56:05 PM Comment: I recently encountered a problem deploying an app that uses Crystal Reports. Of five work stations, three worked fine. But the other two threw Logon Failed exceptions when attempting to print from the report. All of my reports are "pull" reports which use stored procs as their data source. After almost two months of working with Crystal support we found that the work stations that threw the Logon Failed error did not have SQL Native Client installed [SLQNCLI.DLL]. Installing the SQL Native Client resolved the problem. Note that while my back end was SQL Server 2008, SQL Native Client for 2008 would not work. It seems that Crystal is looking for SQLNCLI.DLL and Native Client for 2008 is SQLNCLI10.DLL.
The lesson is check to see that SQL Native Client is installed on your work stations. You should be able to see that in the Control Panel's Install/Uninstall programs list.
Good Luck
Title: "logon failed" and "reference schema in xml is invalid" Name: Sue Date: 2010-09-03 4:06:58 AM Comment: "logon failed" and reference schema in xml is invalid XML and Web Service connection. This is an intemitted error but bugging me. Does anyone know why this happens? Title: query Name: hit Date: 2010-04-26 6:14:54 AM Comment: i have a code for crystal report that run sucessfully. but when i run that project in client side the crystal report does'nt start. what is the problem? Title: Logon Failed Error Name: Kaveri Patil Date: 2010-03-08 9:24:29 PM Comment: i m using crystal report with asp.net 2008.with database connectivity to .mdf file. it gives the "Logon Failed". Plz help me out.It is very urgent. contact: kaveripatil11@gmail.com Title: set dabase location to Crystal report using C# Name: Here is the solution Date: 2010-02-16 1:59:51 PM Comment: following code is successfully run for many report
RPTRaw_DC rd = new RPTRaw_DC[];report file name ConnectionInfo conne = new ConnectionInfo[];
conne.ServerName = ConfigurationSettings.AppSettings["servername"]; conne.DatabaseName = ConfigurationSettings.AppSettings["databasename"]; conne.UserID = ConfigurationSettings.AppSettings["username"]; conne.Password = ConfigurationSettings.AppSettings["passname"]; TableLogOnInfo tablelogs = new TableLogOnInfo[];
Database db=rd.Database; Tables tbls=db.Tables; foreach[Table tab in tbls] { tablelogs = tab.LogOnInfo; tablelogs.ConnectionInfo = conne; tab.ApplyLogOnInfo[tablelogs]; tab.Location = ConfigurationSettings.AppSettings["databasename"] + ".dbo." + tab.Name; most important line whole report is depend on this line } crystalviewerdc.ReportSource = rd; crystalviewerdc.Zoom[1];
Title: set dabase location to Crystal report using C# Name: a Date: 2010-02-16 1:56:49 PM Comment: RPTRaw_DC rd = new RPTRaw_DC[];report file name ConnectionInfo conne = new ConnectionInfo[];
conne.ServerName = ConfigurationSettings.AppSettings["servername"]; conne.DatabaseName = ConfigurationSettings.AppSettings["databasename"]; conne.UserID = ConfigurationSettings.AppSettings["username"]; conne.Password = ConfigurationSettings.AppSettings["passname"]; TableLogOnInfo tablelogs = new TableLogOnInfo[];
Database db=rd.Database; Tables tbls=db.Tables; foreach[Table tab in tbls] { tablelogs = tab.LogOnInfo; tablelogs.ConnectionInfo = conne; tab.ApplyLogOnInfo[tablelogs]; tab.Location = ConfigurationSettings.AppSettings["databasename"] + ".dbo." + tab.Name; }
Title: aa Name: a Date: 2010-02-16 1:54:50 PM Comment: crystalviewerdc.ReportSource = rd; crystalviewerdc.Zoom[1]; Title: set dabase location to Crystal report using C# Name: Here is the solution Date: 2010-02-16 1:52:32 PM Comment: \ \ Title: Log In error Name: dynamic0713 Date: 2009-12-11 5:40:36 PM Comment: Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File [path] name.rpt: Unable to connect: incorrect log on parameters. Title: Light at the end of the tunnel Name: firedancerx Date: 2009-11-03 1:15:34 PM Comment: Thanks. These articles are great.
For those who, like me, had set out on the wrong footing, the solution to the LOGON FAILED issue is non-trivial. It has to be resolved through codes, not just by setting properties at design time. MSDN has comprehensive tutorials here - //msdn.microsoft.com/en-us/library/ms225570.aspx
All the best!
Title: Soft ware engineer Name: Naresh Date: 2009-09-24 6:46:17 AM Comment: Hi I am using crystal reports using xsd as datasoure.In my machine reports are opening.but client machines reports are not opening.It throws Logon failed exception.I am Developed application in Vs 2008 reports are Upgraded from vs 2003. my dataset contains many tables.Any one konw the reason why error is coming... Title: solution for loginfailed for crystal report Name: Ahmed Ekdawy Date: 2009-09-01 7:35:47 AM Comment: just don't pass value for reportsource property of reportviewer control in design time and just do it in code like all do i try it and it work fine Title: Solution for login error Name: Ahmed Ekdawy Date: 2009-09-01 7:24:59 AM Comment: the solution for this error is very simple just don't pass reportsource to reportviewier control and just do it in code as all do this will core id try it and success Title: Problem of Log On Database + crystal report Name: Manan Shah - India Date: 2009-06-18 7:07:09 AM Comment: hi,
i m using crystal report with asp.net 2008. i have create crystal report by setting database detail in design mode. now when i m uploading on server it show error of Log on failed when i m running it.and when i have change database setting in design mode and set for server than its working. so it is problem of every time to set database setting from design and verify it when i want to setup on server. Please tell me solution. Thank You, Manan Shah
Title: ASP.NET error Name: Ruud van der STeen Date: 2009-05-27 7:02:47 AM Comment: i have make a asp.net page where i display a report with in VS2005 it works fine but when i put it on a webserver i have a error massage, it is a report with dynamic parameters
[COMException [0x80004005]: Unknown error 0x8004380D] CrystalDecisions.ReportAppServer.Prompting.IPromptEngine.startPrompting[PromptingUnits units, CRPromptingInfoProvider infoProvider, PromptingOption option] +0 CrystalDecisions.ReportSource.EromReportSourceBase.DoParameterPrompting[PromptingRequestContext reqContext] +321 CrystalDecisions.CrystalReports.Engine.FormatEngine.DoParameterPrompting[PromptingRequestContext reqContext] +44 CrystalDecisions.ReportSource.LocalReportSourceBase.DoParameterPrompting[PromptingRequestContext reqContext] +140 CrystalDecisions.Web.ReportAgentBase.DoPrompting[PromptingHTMLRenderOption htmlOption] +121 CrystalDecisions.Web.CrystalReportViewer.OnPreRender[EventArgs e] +966 System.Web.UI.Control.PreRenderRecursiveInternal[] +80 System.Web.UI.Control.PreRenderRecursiveInternal[] +171 System.Web.UI.Control.PreRenderRecursiveInternal[] +171 System.Web.UI.Page.ProcessRequestMain[Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint] +842
can anybody help please sen mail to r.vandersteen@nmanet.nl
Title: Logon Failed Name: Aniruddha Date: 2009-05-13 3:03:36 PM Comment: I am trying to create crystal report in my website.I am using Visual Studio 2005 and Oracle as database.I have configured my website with IIS. But after adding a dataset to crystal report and after running it is showing an error message that Logon failed Invalid Logon Parameters.
Plz suggest me any solution i m sick of this problem....
Title: Not using database Name: JvH Date: 2009-04-22 9:49:07 AM Comment: I'm using VS2008 Professional Edition, and the version of Crystal Reports that came bundled with it.
I'm trying to use Crystal Reports without a database. In other words: I create a DataSet in code, and fill it manually. I then link my report to this custom DataSet.
Still, for some strange reason, I'm asked to enter a login ID and a password. What should I fill in here? I'm completely at a loss right now.
Title: crystal report viewer logon failed Name: Krzysztof Date: 2009-01-19 9:21:39 AM Comment: It's very simply:
Install :"mysql-connector-odbc-3.51.25-win32" on client system ["plus mysql-connector-net-5.2.3"]
Title: CR Connection through udl file Name: Sagar Date: 2008-10-10 12:03:43 AM Comment: I try to connect Crystal report through DSN but it give error to enable to logon server. can we connect Crystal report tthrough udl or other please tell me in sagar@sesnomatrix.in Title: Connecting crystal report remotly to sql server Name: niraj Date: 2008-08-20 1:31:09 AM Comment: i am getting problem to connect crystal report remotly it gives message like connection error Title: Logon failed Name: problemo Date: 2008-08-13 10:45:10 PM Comment: I try to view the report in service desk reporting [crystal], but it says Unable to open file C:....... and lastly the message is : Logon failed. before, i can view the report, but now i cant. why is tat? thanks. Title: Crystal report Login Problem Name: saurabh Date: 2008-07-16 4:28:33 AM Comment: hi i am using a .xsd file and a dataadapter to produce crystal reports. The code is as follows.
Dim Report As SCOREPC.crptCollactivity = CType[CrystalReportViewer1.ReportSource[], SCOREPC.crptCollactivity] Dim DataEnvironment As New DataEnv2 Dim TableAdapter As New DataEnv2TableAdapters.dtrptCollactivityTableAdapter
TableAdapter.Fill[DataEnvironment.dtrptCollactivity]
Report.Database.Tables[0].SetDataSource[DataEnvironment] CrystalReportViewer1.Show[] The report is taking the connection string info from app.config file. connectionString="Data Source=servername;Initial Catalog=SKYPE;User ID=sa;Password=xyz"
Everything is working fine. Now if i change the UID and PASSWD in app.config file and run the application again. the statement TableAdapter.Fill[DataEnvironment.dtrptCollactivity] is throwing a exception for invalid user.
What i want is that instaed of throwing an exception it should present me a sql prompt for changing user id and password. Is it possible? I am using ado.net datasets.
Is the same functionlity can be achieved in crystal report through some other means?
Title: In his “Troubleshooting Database Login Errors using Crystal Reports with .NET,” Eric Landes points out that he sees questions regarding the “Exception Name: In his “Troubleshooting Database Login Errors using Crystal Reports with .NET,” Eric Landes points out that he sees ques Date: 2008-07-02 7:26:26 AM Comment: In his “Troubleshooting Database Login Errors using Crystal Reports with .NET,” Eric Landes points out that he sees questions regarding the “Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed” message quite often in the newsgroups. That's an understatement. Since I use the “push” method [generating an ADO.NET dataset first, then setting the report's DataSource], I never saw this error, but I decided to try and replicate the problem to see why this was happening--it seems to be a popular error. I had a suspicion that impersonation and the “double hop“ [where the ASP.NET application cannot pass the user's credentials] may play a role in this problem, since the methods in Eric's article don't solve the problem for every user it should.
To replicate the problem, I used an ASP.NET project connecting to either a remote production SQL Server database or a copy of the same database on my development machine [SQL Server Developer Edition]. I created a stored procedure that was just a simple SELECT statement, and used this stored procedure as my report source [“pull“ method]. I probably created this report 20 different ways, testing various options, and here's what I found.
Title: Software Enginner Name: Prem Prabhat Sinha Date: 2008-05-31 4:49:15 AM Comment: i developed a application in vb.net and using crystal report on Windows 2000 server. i have a network connection and all user access it and view crystal report, but when i changed os from windows 2000 server to win xp user cannnot view crystal report. it required server name and password. so what it solution. Title: connot change server name Name: Elie h Date: 2008-04-24 7:59:07 AM Comment: hi i need some help i m trying to change the SERVERNAME like this Dim myConnectionInfo As New ConnectionInfo[] myConnectionInfo.ServerName = "servername" myConnectionInfo.DatabaseName = "databaseName myConnectionInfo.UserID = UserId myConnectionInfo.Password = "passWord" Dim mytableloginfos As New TableLogOnInfos[] mytableloginfos = CrystalReportViewer1.LogOnInfo
For Each myTableLogOnInfo As TableLogOnInfo In mytableloginfos myTableLogOnInfo.ConnectionInfo = myConnectionInfo Next CrystalReportViewer1.RefreshReport[] '' the ServerName change when i run the webapplication from vs2005 but it still use the old server name
Title: Logon Failed Name: Rajeshkanna Krishnan Date: 2008-04-24 7:31:48 AM Comment: the reason for logon failed error in asp.net crystal report is, database connection in the crystal report[design] may be different from connection details in the coding. Title: It really Helped Name: Tejwant Singh Randhawa Date: 2008-04-14 12:37:26 PM Comment: Thanks
you article helped me
Here is the simple implementation
//First Include these header file using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared;
// In crystal viewer load event change logon Info otherwise it will not effect private void crystalReportViewer1_Load[object sender, EventArgs e] {
crystalReportViewer1.SelectionFormula = "{invoicedesc.inv_no}=" + inv_no.ToString[];
//// Change Credentials Here
Database crSubDB; Tables crTables;
ConnectionInfo cInfo = new ConnectionInfo[]; cInfo.ServerName = "SERVER"; cInfo.UserID = "username"; cInfo.Password = "password"; cInfo.DatabaseName = "databasename";
InvoiceReport IR = new InvoiceReport[];
crSubDB = IR.Database; crTables = crSubDB.Tables; foreach [Table crTable in crTables] { TableLogOnInfo crTableLogOnInfo = crTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = cInfo; crTable.ApplyLogOnInfo[crTableLogOnInfo]; }
/////
crystalReportViewer1.ReportSource = IR; }
Title: check folder permissions Name: rjdudley Date: 2008-04-10 6:34:27 AM Comment: reee,
It sounds like you need to check folder permissions.
Title: logon failed Name: reee Date: 2008-04-09 5:15:12 AM Comment: hi
my problem is about the logon failed error. if i run the project using local host. it gives the correct report. while running in the web based it gives the error after clicking the buttton
Title: Cyrstal Report Refesh Case Name: Yooops Date: 2008-03-29 4:21:32 AM Comment: Using a database with blank of table data and then design a report using the table and the field available in the database. Use INSERT INTO command to put some data in to the database. we can change the data in crystal report dynamically , but we still have to refresh many time when we view it with CRV... it just too bad... Title: Crystal Report Viewer truncating character Name: Avinash Pohane Date: 2008-02-07 9:52:12 AM Comment: with reference to report viewer with asp.net 2005 , crystal report viewer somtimes showing the all characters and sometimes truncating the characters. i have deleted the temp files and cookies but still facing same the problem. Please help me in this regard. Title: Aaaaargghhh Name: tia Date: 2008-01-30 4:40:19 PM Comment: We just started using Crystal. We use standard security for development and integrated security from the Web servers for test/prod. For 2 days I've been trying to figure out why it won't work with integrated security on the test server. Followed the tutorials & added logic to display ALL the connection settings [even collections] - it looked like everything was set correctly but still got the login error. No problem connecting using .Net controls, so it couldn't be the SQL Client setup. Works fine when everything's on the same machine. Thought I must be doing something wrong - never occurred to me that Crystal would have such a huge flaw. And why do they put the tutorials out there when they know they don't work? Title: The Honest Truth Name: i_no Date: 2008-01-28 2:59:43 PM Comment: The honest truth about crystal reports is that it is simply non-functional garbage. Title: Another possibility Name: Berreke Date: 2008-01-25 10:07:13 AM Comment: I found this error in a report when I used the standard selection from VS2008. It mysteriously put the databasename double in the select statement. I changed the select statement and everything worked fine afterwards. The strange thing was that it worked on my test machine even with the wrong selection of database.
Kind regards
Berreke
Title: Logon Failed Name: Selva Date: 2008-01-18 1:59:49 AM Comment: It's very useful for all .Net with crystal report developers Title: Cant display data in crystal report Name: kumar Date: 2008-01-11 12:51:25 AM Comment: hi, i am using dataset.xsd file to fill the data i am unable to display the data in crystal reports actually when i first design the crystal report and run it works properly but when i do modification [adding extra field in crystal report] the data will not display.
please help me
Thanks Kumar
Title: Logon Failed Name: Amar Date: 2007-12-07 2:04:35 AM Comment: Hi,
I have a crystal report which uses push method [Using Dataset as report source]. When the data retrieved is huge, I get this logon failed exception, but the same report works when the data retrieved is say around 7500 rows. I have also added the value CommandTimeout as 300 seconds in my web config file.The application and the SQL server are running on the same machine. Any help would be of great use.
Title: Load Report Fail Name: Rohini Date: 2007-11-06 6:36:41 PM Comment: hi all, i have a problem,i m making an acadmic project in vb.net but my crystal report is not runing.when ever i m trying to execute it a msg will be show that is LOAD REPORT FAIL.plz help for this problam.if some one have any idea abt it then plz reply me on this address:- Sharmarohini18@yahoo.co.in i shall be very thankfull to u all.warms regards. Title: SQL Login Name: RJD Date: 2007-11-03 6:13:27 PM Comment: Cho,
There are two ways to pass SQL Server information to a Crystal Report. They are known as "push" and "pull". If you are getting a SQL Server login, it sounds like you designed your report using the pull method. You canno switch to the push method--you need to redesign your report from the beginning.
Title: SQL Login Pop Up in Crystal Report Name: CHO Date: 2007-10-30 5:05:28 AM Comment: I have a store procdure which return 2 table's data. I created the dataset and load the data from those dataset[.xsd] to crystal report.but when i run the report, there is a SQL server login popup appear and Reporting generation process is fail. i have try with ODBC connection , direct connect to Tables , it is ok. but with .xsd .it's not working. Can anyone please give me some ideas? I do appreciate for ur ideas.. thanks a lot and Best Regard,cho Title: Weird Error Name: Eddie Anderson Date: 2007-10-17 2:38:54 PM Comment: I have created a Crystal Report.NET report that is generated dynamically using a stored procedure that is run from my webpage. The report runs fine. Once it opens and the user clicks either the Print option or Export option, closes the option box and then hits the BACK button on the browser, I get the following error...
Logon failed. could not find part of the path. unable to connect incorrect log on parameters
I've been trying to figure out any possible reasons for this. I do use a single sign on solution to access the report. When the user clicks the link, it generates a unique Token ID. It may be trying to reload the report using the same Token ID when they hit the back button and since it won't allow it, may be throwing that error.
Any input would be awesome.
Thanks.
Title: ''can't find keycodev2.dll or invalid keycode" Name: Sreeraj Date: 2007-10-09 12:01:13 AM Comment: I am using Ms.Net 2003[1.1].........
I can't host the crystalreport to my exe.I can get an error message'' can't find keycodev2.dll or invalid keycode ".Any one can know about this problem please help me immediatly.......
thanks......
Title: database change Name: malleshwari Date: 2007-09-27 3:33:00 PM Comment: hi, is it change database provider msaccess to sql server at runtime using crystal report in .net 2005,if yes pls write the code,pls reply as soon as possible. Title: Sub Report in Crystal Report Name: Alex Date: 2007-09-19 8:15:47 AM Comment: I am using Crystal Report in ASP.NET. i have few report with subreport. if i changed the database server in web.config file then the main reports are working fine. but the problem what i am facing is the subreports are not working. in reports i am using record set query to get the values... if anybody have the solution please help me.. Alex Title: Login failed Name: ram Date: 2007-09-03 8:32:19 AM Comment: i am using cristal reports in Lotus before worked properly. recently my Pc formated not comming to some cristal reports "Logon failed" this message has come.if anyone knows the solution please send me code Title: Login failure in crystal report Name: vijay Date: 2007-07-03 5:18:14 AM Comment: i have created a crystal report in asp.net and c#.net out of this all are running fine but it will display an error "Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object." Title: exporting to PDF format Name: subi Date: 2007-05-08 1:22:37 AM Comment: when i am trying to export crystal report into PDF format login failed error occurs.can any one plzz send the code to ms.subitha@gmail.com. thanx in advance. Title: PUSH METHOD SUCCESS ! Name: ake Date: 2007-04-10 2:11:06 AM Comment: Try to change your code that like "report.SetDataSource[DATASET.TABLENAME];" into "report.SetDataSource[DATASET];". Title: Login failure in crystal report Name: Bhargavi Date: 2007-04-02 5:21:19 AM Comment: Hi, I have created a crystal report with crystal reports 9 version & I am using it with asp.net 1.1 c# web application. When i run the application, other things run fine, but the crystal report gives Login error. I tried making it Mixed authentication for SQL server. Once the problem was solved. But it is giving Login error again. Plz help me to sove this problem. Thank u Title: Crystal Report Name: vanu Date: 2007-04-02 3:15:33 AM Comment: type 'CrystalDecisions.web.crystalreportviewer is not defined Title: crystal report Name: Avinash Date: 2007-03-14 8:47:10 AM Comment: Hi! i got an error in existing report error is Database Connector Error ADO ERROR Code ox 80004005 Source : ORA OLEDB DE: ORA-01403 Title: use crystel report 2005 assembley file Name: S.jawahar Date: 2007-03-01 2:44:20 AM Comment: hi friend, please use the assembly file that are needed for crystal report to run on the client side.... add it in ur website deployment Title: push method explained Name: Rinat Date: 2007-02-13 8:26:19 PM Comment: Dear Richard, After messing with Crystal deployment for several days now and reading your article, I think I want to switch to the push method. Can you recommend a good source for sample/walkthrough for implementing this method? My architecture is simple [IIS SQL Server on the same machine] but I want Crystal to use the connection string from me web.config file. Thanks, Rinat Title: "login Faliure:: When copied to another system" Name: bhakuni chandan Date: 2007-01-17 5:04:18 AM Comment: i read this article and found very interesting.I am also facing somewhat similiar problem. I develop a web based apps in my local system.Sql Server is also residing in my system.. but when i copied my whole project and run i faced the "Loign Faliure". i follows the possible steps to remove the problem.. but it still persist so what final shoot for it.. any idea..
thanks bhakuni
Title: LOGON Failed Name: Robert Date: 2006-12-08 8:30:59 AM Comment: Apparently Logon failed is a bigger issue than just verifying the database and problem would go away. Business Objects have this issue on their “monthly fixes” list and if you pick the right SP or fix problem will go away. The problem I had was even after I installed several patches and fixes Logon Failed message would still be there. Final solution was to just simply remove Crystal Report and install it again along with all patches and fixes. I got lucky this time... problem was gone. Title: Logon Failed Name: Rajeesh Date: 2006-10-06 12:09:24 AM Comment: Hi there,
I get a "logon failed" message for reports that has "command" or "rowset" as tables. Interestingly, it works for reports that do not have "command" as tables. Here's the code I use
Protected Sub SetDBLogonForReport[ByVal sDbServer As String, _ ByVal sDbName As String, _ ByVal sDbUserName As String, _ ByVal sDbPassword As String, _ ByVal reportName As ReportDocument, _ ByVal subReportName As ReportDocument]
Dim crSections As Sections Dim crSection As Section Dim crReportObjects As ReportObjects Dim crReportObject As ReportObject Dim crSubreportObject As SubreportObject Dim crDatabase As Database Dim crTables As Tables Dim crTable As Table Dim crLogOnInfo As TableLogOnInfo Dim crConnInfo As New ConnectionInfo
'Report code starts here 'Set the database and the tables objects to the main report 'repDoc' crDatabase = reportName.Database crTables = crDatabase.Tables 'crTables.Reset[] 'Loop through each table and set the connection info 'Pass the connection info to the logoninfo object then apply the 'logoninfo to the main report Try For Each crTable In crTables With crConnInfo .ServerName = sDbServer .DatabaseName = sDbName .UserID = sDbUserName .Password = sDbPassword End With crLogOnInfo = crTable.LogOnInfo crLogOnInfo.ConnectionInfo = crConnInfo crTable.ApplyLogOnInfo[crLogOnInfo] crTable.Location = sDbName & "." & "dbo" & "." & crTable.Location.Substring[crTable.Location.LastIndex
Title: Error with Oracle Name: Richard Dudley Date: 2006-09-22 1:41:47 PM Comment: I'm not familiar with Oracle and CR .NET, but you might need to specify a database name. Title: Login Failed with XML File Name: Richard Dudley Date: 2006-09-22 1:39:24 PM Comment: Karl,
You can't report from XML directly in VS 2003. I think you can in VS 2005, but I haven't used it yet. See //www.rjdudley.com/blog/Crystal+Reports+NET++How+To+Report+Off+A+Flat+XML+File+Through+A+Visual+Studio+NET+Application.aspx for a VS 2003 solution.
Remember that you need to have designed your report from an XSD, not from a database table.
Title: Logon failed to an XML file Name: Karl Date: 2006-09-21 7:19:14 PM Comment: This is great information for connecting to a database, however, as many people have raised, I am simply trying to report from an XML file. I have no need to connect to it, but I am getting the logon failed error message. Any progress on this one... anyone... Title: Logon failed.CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. Name: manimaran Date: 2006-09-18 1:35:01 AM Comment: I am using Oracle, ASP.net 1.1 in VS 2003.I create a Report using Oracle Db. For that i show s the error
CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
My Server is in remote machine.But i add the SetLogOnInfo for the Report . Eventhough it shows a error. It works fine for SQl Server in remote Server.Please help.
OracleTable UserRpt=new OracleTable[]; crConnectionInfo.ServerName="DIM9"; crConnectionInfo.DatabaseName=""; crConnectionInfo.UserID="system"; crConnectionInfo.Password ="manager"; crDatabase=UserRpt.Database; crTables=crDatabase.Tables; foreach[CrystalDecisions.CrystalReports.Engine.Table crTable in crTables] { crTableLogOnInfo=crTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo=crConnectionInfo; crTable.ApplyLogOnInfo[crTableLogOnInfo]; crTable.Location="INTERMEDIATE."+ crTable.Location.Substring[crTable.Location.LastIndexOf["."] + 1]; if[crTable.TestConnectivity[]] { Label1.Text="Connected"; } else { Label1.Text="Not Connected"; } } UserRpt.SetDatabaseLogon["system","manager"]; CrystalReportViewer1.SelectionFormula=""; CrystalReportViewer1.ReportSource=Server.MapPath ["OracleTable.rpt"];
Title: crystal report fails while running from virtual directory Name: Radhika Date: 2006-08-25 3:19:32 AM Comment: In My project the crystal reports used when executed displays the result. but the same when run from virtual directory asks for server name user id ,etc. Can anyone help me out. Title: "Failed to open a Rowset" Name: Jignesh Date: 2006-07-03 6:04:42 AM Comment: I have designed a report. And then Query Engine error : "If Tables are already linked then join type cannot be change." Title: Connectivity Name: Junaid Ali Date: 2006-06-22 1:26:44 PM Comment: Dear Richard,
I have designed a report .DSR how can i connect my report using my Application Connection instead of creating DSN on Client end
Junaid Ali
Title: Geo Raghu Name: Asghar Date: 2006-05-23 3:27:26 AM Comment: Your one line suggession is best from all of this discussion. Any one please who is worried about CR problem just see the first post by Geo Raghu.
Asghar.
Title: ADO.NET DataSet Push Method Name: Richard Dudley Date: 2006-04-06 12:46:28 PM Comment: Atilla,
Ask your question in the forums at //asp.net. This needs more debugging.
Title: Windows Updates Name: Richard Dudley Date: 2006-04-06 12:44:24 PM Comment: Kapil, How is the dataset being generated? If the data are coming from an SQL server, then SQL security might be a problem.
Also, what happens if they patch the computer before installing your software?
Title: ADO.NET DataSet Push Method Name: Atilla Date: 2006-04-06 5:55:25 AM Comment: Hello,
I am using the push method, where I have a typed dataset, I filled the dataset with the data [from an access database with OLEDB adapter] and set the datasource of the report to this Dataset [filled]. Okay i get the logon failed exception.
Then I redesigned the report to use an XML file [fixed full file]. During runtime I fill the XML file with the typed dataset and call the report to such the XML file contents. Okay then I get "Database Logon Failed" exception.
I do not undertand how the report try to logon to database when there is XML file allready filled with data and waiting for the report to read it.
Please someone help me I am totaly dead.. Regards
Title: "Failed to Open Rowset" Name: Bipin Date: 2006-04-01 2:07:35 AM Comment: Hi All,
I has developed Crystal report in ASP.Net which works fine at my site, but when I change database location it dosen't work. I had tried databselogon and logininfo method but it gives me above error.
I had used two tables in my report. so if i am setting setdatasource to ds it works but it dosen't get refresh
If any one have solution please provide me so
Title: Narrowing it down to Windows Updates Name: Kapil Kelaiya Date: 2006-03-31 12:55:57 AM Comment: Hello Richard,
Thanks for your reply,
CR prompts login for every windows user even domain admins as well.!! And as dataset and report are sitting on client site [report only fetches data from dataset], sql security can not be culprit.
I asked client's tech guys to reinstalled windows XP. When they reinstalled Windows XP and installed our software on fresh XP SP2, it worked FINE.
They did live windows update, restarted their computer and CR started PROMPTING LOGON.
I tried recreating the same in my test environment but no success - CR works fine with every latest XP patch.
I emailed crystal guys in Australia and they said - I am entitled to ask ONLY TWO product related questions for the .Net products which I had already asked so even if this is a Crystal bug they are not helping me.
BTW, client uses... - Dell Computers - Windows XP SP2 + latest updates - McAfee antivirus - Windows firewall - Windows Domain security - .Net Framework 1.1 - CR 9
Do you know any condition that in combination with the above can cause CR to prompt for login?
Thanks again,
Kapil Kelaiya
Title: Failure after 1 year Name: Richard Dudley Date: 2006-03-29 8:24:44 PM Comment: If your application is impersonating a user, did that user's password expire? Title: "Logon Failed" on dataset after a year Name: Kapil Kelaiya Date: 2006-03-29 7:02:41 PM Comment: Hello Richard,
I am using....
.Net Runtime 1.1 CR 9 shipped with vs2003 Winforms Application DataSource = ADO.NET dataset
I have finished this application a year ago and we have 70+ clients. One of our clients has our program installed on 6 computers. Before few days, the program including crystal report was working fine. Suddenly, in last month, CR viewer started popping up error "Logon Failed" with login box with prewritten table name in it.
I have checked all logon problems with dataset on every discussion board. All I found was - table name or field name might be wrong.
Can you think of any program or condition that can cause CR to display “Logon Failed” specially after going well for a year?
BTW, All the client machines are windows XP with SP2 on it.
Kapil Kelaiya
Title: Login Failed Name: Srinivas Date: 2006-03-16 2:27:56 AM Comment: hai sir, i have tried all methods of u r discussion but unable to see the crystal report in web applications,same thing when i done in windw0s application it is working.
please do needful.......
Advance Thanks Srinivas.N
Title: Crystal Report Name: Prashant Date: 2006-02-25 5:20:21 AM Comment: I have created a crystal report from an existing report but it gives me the problem of login to database . i have passed all the informatuion related to database [login ,pwd database name ,servername] but still my application asking me for password. Title: Crystal Report Name: Prashant Date: 2006-02-25 5:18:15 AM Comment: Hello sir, I have created a crystal report from an existing report but it gives me the problem of login to database . i'm working in a server environment please help me.. Title: Error Message Name: Naoba Date: 2006-02-18 4:53:03 AM Comment: Hi, I am using the process of pull model according your guidance. But I got the error message like Logon fail. kindly cooperate with me to solve this problem.
Naoba
Title: Unable to display the Cry. Report While Connecting to SQL Server Through Client Name: Richard Dudley Date: 2005-12-05 11:33:23 AM Comment: Vinay,
This will take some debugging, and these comments aren't the best place for that. Try asking your question in the Crystal Reports list at ASP Advice [//aspadvice.com/lists/SignUp/list.aspx?l=181&c=11].
Title: logon failed through push method Name: logon failed through push method Date: 2005-12-04 8:54:33 PM Comment: hi, logon failed message is really annoying. im using push method. i created an xsd dataset file and change the datasource of the report at runtime with a populated dataset from the database. im wondering why im getting this error, i already got the records in the runtime dataset, so crystal is not pulling data from the database but logon failed keeps on showing. this is really annoying. please help. Title: Unable to display the Cry. Report While Connecting to SQL Server Through Client Name: Vinay KD Date: 2005-12-03 5:09:36 AM Comment: I have designed a Crstal report 9.0 in VB6.0, using back end on SQL Server. When i ever i try to open report from the client, it displays a dialog box with title :- Crystal Report Viewer, and Message: ----- Logon Failed Details: ADO ERROR Code 0x80040ed Source: Microsoft OLEDB Provider for SQL Server Description: Logon Failed For User SERVER/Guest SQL State: 42000 Native Error:18456 ----- * SERVER is the Computer Name of Server On which SQL Server is running. * I Have installed the SQL Server on Windows XP, in mixed mode. * When Ever I try to run the report on server it's working properly, but not on client node. * I have tried both the
- Integrated Security Option,in Database Expert while designing the Report.
- Windows Authentication. but in both cases i couldn't resolve my problem
Vinay KD
Title: Getting the error when we export the report from the Crystal report viewer Name: Satish Date: 2005-12-02 5:20:57 AM Comment: Hi,
We are getting the error from teh Crystal report viewer. When i try to export the report to the PDF file using the Export in from the Crystal report error, i am getting the login failed error. please suggest me in this
Satish
Title: CR Hater Name: Richard Dudley Date: 2005-10-13 10:08:10 AM Comment: It sounds like a file permissions issue. Depending on the server version and the impersonation settings of your app, there are a number of settings you'll need to tweak. Make sure ASPNET [win 2K] or Network Service [Win 2K3] have at least READ permisssions on the folder where the XML is stored. If that doesn't help, try the forum at //asp.net. Title: Sharad Name: Rich Dudley Date: 2005-10-13 10:05:21 AM Comment: Sharad,
Try asking your question in the Crystal Reports forum at //asp.net.
Title: crystal report problem Name: sharad yadav Date: 2005-10-13 2:14:00 AM Comment: sir, i am using asp.net with VB but when i use crstal report i got this error: Crystal Report in Web Application Fails to Log On to SQL Server
every topic is explained with c# but i want syntax in vb please if you know this send it at:
sharad_yadav2006@yahoo.com
Title: CR Hater Name: Bob Loblaw Date: 2005-10-12 2:02:09 PM Comment: I've got an even more interesting problem.
I'm using an XML file for my data and I get this error with my .Net report. Oddly it works fine on my development machine but when I publish the report it give me a "CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed" error. Very annoying.
Title: Logon failed after even after "ApplyLogOnInfo" Name: Alessandro Pannone Date: 2005-10-03 11:52:07 AM Comment: I used Integrated security while I was designing my CR... ...I was confident I could change the connection and logon information[user and password] easily. In few worlds I can't. I use:
crConnectionInfo.ServerName = databaseDSNorServerName; crConnectionInfo.DatabaseName = databaseName; crConnectionInfo.UserID = userID; crConnectionInfo.Password = password; //Get the table information from the report crDatabase = pF_CrystalReport.Database; crTables = crDatabase.Tables;
//Loop through all tables in the report and apply the //connection information for each table. for [int i = 0; i < crTables.Count; i++] { crTable = crTables [i]; bool test=crTable.TestConnectivity[]; if [test==false] { throw new Exception["DB Connection not working"]; } crTableLogOnInfo = crTable.LogOnInfo; crTableLogOnInfo.ConnectionInfo = crConnectionInfo; crTable.ApplyLogOnInfo[crTableLogOnInfo];
After this it still uses the old connection information.
Title: thanks raghu Name: venkataraman Date: 2005-09-29 10:35:36 AM Comment: the article was relly good .but raghu gave me the spark. thanks. Title: Glad to clarify Name: Richard Dudley Date: 2005-09-14 8:43:27 PM Comment: You're probably not the first to think that, and I'll see if I can get the editors to make a small change.
In systems where performance is a concern, it's important to know that CR uses ODBC when it connects to a DB, rather than the performance improved ADO.NET. That's one reason why I prefer to use the PUSH method.
Title: Gotch ya Name: Michael De Lorenzo Date: 2005-09-14 3:33:48 PM Comment: I guess I read the sentence to literally. Thanks for the clarification! Title: CR.NET and ADO.NET Name: Richard Dudley Date: 2005-09-14 1:22:05 PM Comment: Michael,
When I said "CR.NET doesn't use ADO.NET", I didn't mean that CR.NET couldn't use ADO.NET. I meant that when CR.NET connects to a database [in the PULL method], it uses ODBC drivers, not ADO.NET drivers.
Your example is the PUSH method, and is actually the method I prefer to use. Technically, you're not using ADO.NET, either, since you are creating an in-memory dataset, the source of which could have been XML, a custom collection, or a database connected via JDBC, ODBC, ADO.NET [as you used], etc.
PUSH and PULL are two distinct methods of feeding data into CR.NET reports, and they can not be mixed, although I see a lot of people trying.
Title: CR .Net most definitely works with ADO.Net Name: Michael De Lorenzo Date: 2005-09-13 10:02:09 PM Comment: A colleague referred me to Richard's blog entry [//dotnetjunkies.com/WebLog/richard.dudley/archive/2004/09/09/25038.aspx] and that led me to this article.
He had struggling for days to figure this out and was perplexed to hear that it was written that CR.Net doesn't work with ADO.Net when I had working samples in our project using ADO.Net.
See below:
// Get my report data; this fills the dataset for me GetMyDataClass myData = new GetMyDataClass[reportId]; MyReportsFolder.report1 rpt = new MyReportsFolder.report1[];
// Set my report data source to my ADO.Net DataSet report1.SetDataSource[myData.ADOdotNetDataSet];
// Display the report CRViewerOnPage.ReportSource = rpt;
A few keys to note:
* this show example is based on a typed dataset. * the report database is set to my DataSchema file [XSD]. * the DataTable[s] displayed on the Database Fields must be named EXACTLY the same as the DataTable[s] filled from the database [ie, DataSet1.TableA and the table under Database Fields should be "TableA"]
Title: CR 8 and Oracle Name: Richard Dudley Date: 2005-08-29 9:43:54 AM Comment: Shubha,
I am not sure that CR 8 is compatible with .NET. Why do you not use the bundled version? You might want to ask your question in the CR 8 forum on the Business Objects website, since that is a very old version.
Title: logon failed error Name: shubha Date: 2005-08-29 4:30:21 AM Comment: I have this error for the past one week and i cannot find a solution ,so please help me to rectify this error as soon as possible.i have designed a crystal report in segatecrystalreport8 and connected it in webapplication using a crystaltreportviewer and the db is oracle
Imports System.Data.OracleClient Imports CrystalDecisions.CrystalReports.Engine Public Class WebForm2 Inherits System.Web.UI.Page Dim con As New OracleConnection[ConfigurationSettings.AppSettings["constr"]] Dim selectcommand As New OracleCommand Dim ds As New DataSet Dim da As New OracleDataAdapter Dim dr As OracleDataReader Dim cs As New CrystalReport1 Dim rd As New rpttest Protected WithEvents CrystalReportViewer1 As CrystalDecisions.Web.CrystalReportViewer Protected WithEvents btnrpt As System.Web.UI.WebControls.Button Dim cs1 As New CrystalReport2 Private Sub btnrpt_Click[ByVal sender As System.Object, ByVal e As System.EventArgs] Handles btnrpt.Click con.Open[] selectcommand.Connection = con da = New OracleDataAdapter["select HLEVEL,BRANCHCODE,BRANCHNAME from TBLBANK", con] da.SelectCommand.CommandType = CommandType.Text da.Fill[ds, "TBLBANK"] rd.SetDataSource[ds] CrystalReportViewer1.ReportSource = rd CrystalReportViewer1.DataBind[] End Sub End Class
Title: fieldexplorer window Name: senthilkumar Date: 2005-08-09 9:02:21 AM Comment: while opening a new cyrstal report file , i can't able to see the field explorer window,what do.Field explorer window will open along with .rpt file.in ur system it is not opening.please help me to get senthiltvmalai@yahoo.com Title: logon erro Name: senthilkumar Date: 2005-08-09 8:15:08 AM Comment: i had tried for both the pull and push method for creating a crystal report in asp.net[vb.net], sqlserver2000. With ur site material guide i followed, but iam getting finally an error "logonerror" so please try the pull and push method and tell me how to solve this error. very urgent please... Title: Impersonation not working Name: Alexis Date: 2005-08-02 10:40:50 AM Comment: Richard, I am still getting this problem even with SQL Server and IIS located on the same machine. When I try to open the report, I get the "Logon failed" error cited above. The SQL Server log records a logon failed message for the "ASPNET" user. Despite having impersonation turned on in the web.config [and impersonation does work throughout the rest of the application], there still seems to be a failure of impersonation in Crystal Reports. Is there something I am missing? Thank you, Alexis Title: logon failed when changing database at runtime in vb.net bundled with cr 10 Name: Jay Simbag Date: 2005-07-27 9:48:45 PM Comment: Hi there,
I get a "logon failed" message for reports that has "command" or "rowset" as tables. Interestingly, it works for reports that do not have "command" as tables. Here's the code I use
Protected Sub SetDBLogonForReport[ByVal sDbServer As String, _ ByVal sDbName As String, _ ByVal sDbUserName As String, _ ByVal sDbPassword As String, _ ByVal reportName As ReportDocument, _ ByVal subReportName As ReportDocument]
Dim crSections As Sections Dim crSection As Section Dim crReportObjects As ReportObjects Dim crReportObject As ReportObject Dim crSubreportObject As SubreportObject Dim crDatabase As Database Dim crTables As Tables Dim crTable As Table Dim crLogOnInfo As TableLogOnInfo Dim crConnInfo As New ConnectionInfo
'Report code starts here 'Set the database and the tables objects to the main report 'repDoc' crDatabase = reportName.Database crTables = crDatabase.Tables 'crTables.Reset[] 'Loop through each table and set the connection info 'Pass the connection info to the logoninfo object then apply the 'logoninfo to the main report Try For Each crTable In crTables With crConnInfo .ServerName = sDbServer .DatabaseName = sDbName .UserID = sDbUserName .Password = sDbPassword End With crLogOnInfo = crTable.LogOnInfo crLogOnInfo.ConnectionInfo = crConnInfo crTable.ApplyLogOnInfo[crLogOnInfo] crTable.Location = sDbName & "." & "dbo" & "." & crTable.Location.Substring[crTable.Location.LastIndex
Title: Access DB Name: Richard Dudley Date: 2005-07-18 3:53:26 PM Comment: Karl,
I answered this under your thread at //forums.asp.net/990257/ShowPost.aspx.
Title: login error for database without users/passwds Name: karl Date: 2005-07-18 3:42:51 PM Comment: What about connecting to an ACCESS database that has no users or passwords defined for it???
- I get the login error when I don't set a login for the crystal report and the report gets query information from an access db with no passwords.
why would this be happening?
Title: Programmer/Analyst Name: Tony Leninger Date: 2005-06-24 2:03:38 PM Comment: I just finished a major project with Crystal in .NET pulling data from an Oracle Database. I was having problems connecting to a SQL Server database with NT Authentication. This article tipped me off to my error: My report needed to be built off of an OLE DB datasource. When I changed that, my report ran.
Thanks for the work!
Title: error logon faild Name: ttu Date: 2005-04-20 1:35:23 AM Comment: i don't be success with your sujestion to solve my problem i created simple page in .NET and made one report but sometimes i don't have any problem .another time suddenly when i connect to special database , this err happen. i don't know how can i create user & password in .net and then with user&password be connect to sqlServer or how can i write thise user & pass in web.config Title: Where to ask for help Name: Richard Dudley Date: 2005-02-21 3:31:24 PM Comment: If you have a question not directly related to this article, join the Crystal Reports discussion group on ASP Advice at //aspadvice.com/SignUp/list.aspx?l=181&c=11. Title: connecting to crystal report Name: Binu Date: 2005-02-19 6:11:26 AM Comment: i've created-designed a report from nt developing machine, server name 'Myserver'.I'm getting Reports in asp.net using push method and pull method.
But if i change server to another one[different server name, same database] , the report is not working [designed with Myserver]. How we can solve ?
pls mail to binujoshua@yahoo.com
thannx in Advance Binu.
Title: Better way to do Name: Raghu Date: 2005-01-25 12:52:54 AM Comment: Hi Richard,
There is a better and professional way to get away from this problem. Once you create the instance of your report, you can use the SetDatabaseLogon method to pass the user credentials.
rptMembers.SetDatabaseLogon["UsernameHere","PasswordHere"];
Hope this is the topic we have been discussing. Please do write to me if I am wrong.
Regards, Raghu
Title: "failed to create designer" error on one of my clients only and nowhere else. Has anyone seen this before? How can it be corrected.