473,326 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Another Logon Failed err...

Rey
Howdy all.

Using VSNet 2003 on an XP Pro SP2 boox. Trying to use Crystal Reports
to access an mdb file with access security/workspace.

Simple report of customers but after spending mucho time researching -
but still not knowing why/what caused it -a load report failed err,
read some articles and this problem was resolved.
Now I have a logon failed err. Code below was modified for C# from
article in dotnetjunkies "Creating Reports using Crystal Reports for
Visual Studio .NET."

Appreciate any suggestions/comments on how to resolve this err and
finally display the simple report.

Below is the code used to display report. The rem'ed VB code is from
the article.

Thank you,
Rey

*******************

protected CrystalDecisions.Web.CrystalReportViewer
CrystalReportViewer1;
//CrystalDecisions.CrystalReports.Engine.Table myTable;
//CrystalDecisions.Shared.TableLogOnInfo myLogin;

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
// in order to not receive a logon failed err msg
// need to use following code to incl the 2 lines above
rptTest rpt = new rptTest(); // var of rpt
// CrystalDecisions.CrystalReports.Engine.Table myTable;
CrystalDecisions.Shared.TableLogOnInfo myLogin;

foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in
rpt.Database.Tables)
{
myLogin = myTable.LogOnInfo;
myLogin.ConnectionInfo.Password = "12345";
myLogin.ConnectionInfo.UserID = "aUser";
myTable.ApplyLogOnInfo (myLogin);

}

CrystalReportViewer1.ReportSource = rpt;
this.DataBind();
}
}
/*

Dim myTable As CrystalDecisions.CrystalReports.Engine.Table
Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
crpt = New CrystalReport1()

For Each myTable In crpt.Database.Tables
myLogin = myTable.LogOnInfo
myLogin.ConnectionInfo.Password = "test"
myLogin.ConnectionInfo.UserID = "sa"
myTable.ApplyLogOnInfo(myLogin)
Next

CrystalReportViewer1.ReportSource = crpt
*/

Nov 17 '05 #1
4 1883
Hola Rey,

- Check these documents in the BusinessObjects Knowledge Base:

http://support.businessobjects.com/s...rt&language=EN

- Take a look at the ReportDocument.SetDatabaseLogon() method, you could do
with only one line of code what now is taking you several.

Regards - Octavio

// CrystalDecisions.CrystalReports.Engine.Table myTable;
CrystalDecisions.Shared.TableLogOnInfo myLogin;

foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in
rpt.Database.Tables)
{
myLogin = myTable.LogOnInfo;
myLogin.ConnectionInfo.Password = "12345";
myLogin.ConnectionInfo.UserID = "aUser";
myTable.ApplyLogOnInfo (myLogin);
"Rey" <re********@cox.net> escribió en el mensaje
news:11**********************@g47g2000cwa.googlegr oups.com... Howdy all.

Using VSNet 2003 on an XP Pro SP2 boox. Trying to use Crystal Reports
to access an mdb file with access security/workspace.

Simple report of customers but after spending mucho time researching -
but still not knowing why/what caused it -a load report failed err,
read some articles and this problem was resolved.
Now I have a logon failed err. Code below was modified for C# from
article in dotnetjunkies "Creating Reports using Crystal Reports for
Visual Studio .NET."

Appreciate any suggestions/comments on how to resolve this err and
finally display the simple report.

Below is the code used to display report. The rem'ed VB code is from
the article.

Thank you,
Rey

*******************

protected CrystalDecisions.Web.CrystalReportViewer
CrystalReportViewer1;
//CrystalDecisions.CrystalReports.Engine.Table myTable;
//CrystalDecisions.Shared.TableLogOnInfo myLogin;

private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
// in order to not receive a logon failed err msg
// need to use following code to incl the 2 lines above
rptTest rpt = new rptTest(); // var of rpt
// CrystalDecisions.CrystalReports.Engine.Table myTable;
CrystalDecisions.Shared.TableLogOnInfo myLogin;

foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in
rpt.Database.Tables)
{
myLogin = myTable.LogOnInfo;
myLogin.ConnectionInfo.Password = "12345";
myLogin.ConnectionInfo.UserID = "aUser";
myTable.ApplyLogOnInfo (myLogin);

}

CrystalReportViewer1.ReportSource = rpt;
this.DataBind();
}
}
/*

Dim myTable As CrystalDecisions.CrystalReports.Engine.Table
Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
crpt = New CrystalReport1()

For Each myTable In crpt.Database.Tables
myLogin = myTable.LogOnInfo
myLogin.ConnectionInfo.Password = "test"
myLogin.ConnectionInfo.UserID = "sa"
myTable.ApplyLogOnInfo(myLogin)
Next

CrystalReportViewer1.ReportSource = crpt
*/

Nov 17 '05 #2
Rey
Buenas, Octavio.

Thanks for the tip.
Was able to get logged on when I changed the machine.config file as a
test. Reset it back, stopped, restarted and even rebooted and was then
able to access the mdb w/a quickie rpt...

Now when I attempt to do same but using the push meth via a dataset, I
now get "Not a valid account name or password" msg. And this is with
your tip and setting same for each tbl of which there is only one being
used in the rpt.

CR is leaving a bad taste in my mouth...

Gracias for the tip.

Rey

Nov 17 '05 #3
Rey,

Yes, Crystal can make things difficult at times
Check out these documents, maybe some could help:

http://support.businessobjects.com/l...s/c2011068.asp
http://support.businessobjects.com/l...s/c2015838.asp

Are you developing a Windows or web application?

Regards - Octavio

"Rey" <re********@cox.net> escribió en el mensaje
news:11**********************@o13g2000cwo.googlegr oups.com...
Buenas, Octavio.

Thanks for the tip.
Was able to get logged on when I changed the machine.config file as a
test. Reset it back, stopped, restarted and even rebooted and was then
able to access the mdb w/a quickie rpt...

Now when I attempt to do same but using the push meth via a dataset, I
now get "Not a valid account name or password" msg. And this is with
your tip and setting same for each tbl of which there is only one being
used in the rpt.

CR is leaving a bad taste in my mouth...

Gracias for the tip.

Rey

Nov 17 '05 #4
Rey
Howdy.
Accessing "canned" crystal reports to display on a web page.
Unfortunately, Access workspace security is being used. Might require
that rpts be re-written 8-(

Later,
Rey

Nov 17 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Maellic | last post by:
Hi, The website I am working on is built with ASP.NET and connects to a SQL Server 2000 database. The web server and database are on the same machine. I have recently tried to modify the timeout...
2
by: GFro | last post by:
I am getting the following error since we upgraded from .NET Framework 1.0 to 1.1. The reports all ran fine yesterday. I get this error in all apps with reports. The apps run fine but the...
3
by: Milan Todorovic | last post by:
Hello, I need help. I have experience in ASP.NET programming, but this is my first dealing with Crystal Reports. I'm trying to make the most basic report purely for testing purposes: connect to...
1
by: John Dalberg | last post by:
Running Crystal Reports with the hotfixes and patches & VS 2003. I created a CR report on my development server which has SQL Server. The report runs fine inside Visual Studio. When I switched...
9
by: mollyf | last post by:
I have tried various suggestions that I have found searching the newsgroups and still haven't been able to figure why I keep getting the logon failed error. I created a report in Crystal (not...
0
by: Ben | last post by:
Hi We have been developing an intranet using VB .NET displaying crystal reports. We repeatedly receive the error below on both the development machine and the deployment server: I have...
2
by: J-T | last post by:
Hi All, We have an asp.net application on a windows 2003 server which is part of a domain controller which my worksatis is too. We have impersonated in our applciation with a fixed identity...
0
by: bonita | last post by:
I come across the error "CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed." After I move my asp.net code from the development platform (XP professional) to the production web...
3
by: SAL | last post by:
Hello, I'm a total asp.net newbie. I'm developing a web app and on my machine I login to a sql server just fine using NT Authentication via the connection string as: Integrated Security=True ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.