Understanding the Login Failed Error in Crystal Reports
page 1 of 6
Published: 20 Sep 2004
Unedited - Community Contributed
Abstract
Often, the best way to prevent an error is to understand why it occurs. In various newsgroups, questions regarding the Crystal Reports LogOnException are asked quite often. A recent Crystal Alliance article discussed how to debug and get rid of this error. This article investigates why these occur, which when combined with the previous article, can help prevent this error from happening.
by Richard Dudley
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 459125/ 6678

Introduction

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.


View Entire Article

User Comments

Title: Database Logon Failed - Solution   
Name: Odysseus
Date: 3/1/2012 1:16:52 PM
Comment:
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: 12/5/2011 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: 9/26/2011 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: 1/31/2011 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: 10/21/2010 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: 10/4/2010 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: 9/3/2010 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: 4/26/2010 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: 3/8/2010 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: 2/16/2010 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: 2/16/2010 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: 2/16/2010 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: 2/16/2010 1:52:32 PM
Comment:
\
\
Title: Log In error   
Name: dynamic0713
Date: 12/11/2009 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: 11/3/2009 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 - http://msdn.microsoft.com/en-us/library/ms225570.aspx

All the best!
Title: Soft ware engineer   
Name: Naresh
Date: 9/24/2009 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: 9/1/2009 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: 9/1/2009 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: 6/18/2009 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: 5/27/2009 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: 5/13/2009 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: 4/22/2009 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: 1/19/2009 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: 10/10/2008 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: 8/20/2008 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: 8/13/2008 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: 7/16/2008 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: 7/2/2008 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: 5/31/2008 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: 4/24/2008 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: 4/24/2008 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: 4/14/2008 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: 4/10/2008 6:34:27 AM
Comment:
reee,

It sounds like you need to check folder permissions.
Title: logon failed   
Name: reee
Date: 4/9/2008 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: 3/29/2008 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: 2/7/2008 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: 1/30/2008 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: 1/28/2008 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: 1/25/2008 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: 1/18/2008 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: 1/11/2008 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: 12/7/2007 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: 11/6/2007 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: 11/3/2007 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: 10/30/2007 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: 10/17/2007 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: 10/9/2007 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: 9/27/2007 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: 9/19/2007 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: 9/3/2007 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: 7/3/2007 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: 5/8/2007 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: 4/10/2007 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: 4/2/2007 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: 4/2/2007 3:15:33 AM
Comment:
type 'CrystalDecisions.web.crystalreportviewer is not defined
Title: crystal report   
Name: Avinash
Date: 3/14/2007 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: 3/1/2007 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: 2/13/2007 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: 1/17/2007 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: 12/8/2006 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: 10/6/2006 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: 9/22/2006 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: 9/22/2006 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 http://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: 9/21/2006 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: 9/18/2006 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: 8/25/2006 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: 7/3/2006 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: 6/22/2006 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: 5/23/2006 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: 4/6/2006 12:46:28 PM
Comment:
Atilla,

Ask your question in the forums at http://asp.net. This needs more debugging.
Title: Windows Updates   
Name: Richard Dudley
Date: 4/6/2006 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: 4/6/2006 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: 4/1/2006 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: 3/31/2006 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: 3/29/2006 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: 3/29/2006 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: 3/16/2006 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: 2/25/2006 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: 2/25/2006 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: 2/18/2006 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: 12/5/2005 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 (http://aspadvice.com/lists/SignUp/list.aspx?l=181&c=11).
Title: logon failed through push method   
Name: logon failed through push method
Date: 12/4/2005 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: 12/3/2005 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
a) Integrated Security Option,in Database Expert while designing the Report.
b) 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: 12/2/2005 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: 10/13/2005 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 http://asp.net.
Title: Sharad   
Name: Rich Dudley
Date: 10/13/2005 10:05:21 AM
Comment:
Sharad,

Try asking your question in the Crystal Reports forum at http://asp.net.
Title: crystal report problem   
Name: sharad yadav
Date: 10/13/2005 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: 10/12/2005 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: 10/3/2005 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: 9/29/2005 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: 9/14/2005 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: 9/14/2005 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: 9/14/2005 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: 9/13/2005 10:02:09 PM
Comment:
A colleague referred me to Richard's blog entry (http://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: 8/29/2005 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: 8/29/2005 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: 8/9/2005 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: 8/9/2005 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: 8/2/2005 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: 7/27/2005 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: 7/18/2005 3:53:26 PM
Comment:
Karl,

I answered this under your thread at http://forums.asp.net/990257/ShowPost.aspx.
Title: login error for database without users/passwds   
Name: karl
Date: 7/18/2005 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: 6/24/2005 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: 4/20/2005 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: 2/21/2005 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 http://aspadvice.com/SignUp/list.aspx?l=181&c=11.
Title: connecting to crystal report   
Name: Binu
Date: 2/19/2005 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: 1/25/2005 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   
Name: TonyLang
Date: 10/28/2004 9:37:06 AM
Comment:
"failed to create designer" error on one of my clients only and nowhere else. Has anyone seen this before? How can it be corrected.

Product Spotlight
Product Spotlight 



Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 12/18/2014 10:23:21 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search