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 CrystalDecision s.Web.CrystalRe portViewer
CrystalReportVi ewer1;
//CrystalDecision s.CrystalReport s.Engine.Table myTable;
//CrystalDecision s.Shared.TableL ogOnInfo myLogin;

private void Page_Load(objec t sender, System.EventArg s 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
// CrystalDecision s.CrystalReport s.Engine.Table myTable;
CrystalDecision s.Shared.TableL ogOnInfo myLogin;

foreach (CrystalDecisio ns.CrystalRepor ts.Engine.Table myTable in
rpt.Database.Ta bles)
{
myLogin = myTable.LogOnIn fo;
myLogin.Connect ionInfo.Passwor d = "12345";
myLogin.Connect ionInfo.UserID = "aUser";
myTable.ApplyLo gOnInfo (myLogin);

}

CrystalReportVi ewer1.ReportSou rce = rpt;
this.DataBind() ;
}
}
/*

Dim myTable As CrystalDecision s.CrystalReport s.Engine.Table
Dim myLogin As CrystalDecision s.Shared.TableL ogOnInfo
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
crpt = New CrystalReport1( )

For Each myTable In crpt.Database.T ables
myLogin = myTable.LogOnIn fo
myLogin.Connect ionInfo.Passwor d = "test"
myLogin.Connect ionInfo.UserID = "sa"
myTable.ApplyLo gOnInfo(myLogin )
Next

CrystalReportVi ewer1.ReportSou rce = crpt
*/

[Octavio Hernandez]

Hola Rey,

- Check these documents in the BusinessObjects Knowledge Base:

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

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

Regards - Octavio

// CrystalDecision s.CrystalReport s.Engine.Table myTable;
CrystalDecision s.Shared.TableL ogOnInfo myLogin;

foreach (CrystalDecisio ns.CrystalRepor ts.Engine.Table myTable in
rpt.Database.Ta bles)
{
myLogin = myTable.LogOnIn fo;
myLogin.Connect ionInfo.Passwor d = "12345";
myLogin.Connect ionInfo.UserID = "aUser";
myTable.ApplyLo gOnInfo (myLogin);
"Rey" <re********@cox .net> escribió en el mensaje
news:11******** **************@ g47g2000cwa.goo glegroups.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 CrystalDecision s.Web.CrystalRe portViewer
CrystalReportVi ewer1;
//CrystalDecision s.CrystalReport s.Engine.Table myTable;
//CrystalDecision s.Shared.TableL ogOnInfo myLogin;

private void Page_Load(objec t sender, System.EventArg s 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
// CrystalDecision s.CrystalReport s.Engine.Table myTable;
CrystalDecision s.Shared.TableL ogOnInfo myLogin;

foreach (CrystalDecisio ns.CrystalRepor ts.Engine.Table myTable in
rpt.Database.Ta bles)
{
myLogin = myTable.LogOnIn fo;
myLogin.Connect ionInfo.Passwor d = "12345";
myLogin.Connect ionInfo.UserID = "aUser";
myTable.ApplyLo gOnInfo (myLogin);

}

CrystalReportVi ewer1.ReportSou rce = rpt;
this.DataBind() ;
}
}
/*

Dim myTable As CrystalDecision s.CrystalReport s.Engine.Table
Dim myLogin As CrystalDecision s.Shared.TableL ogOnInfo
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
crpt = New CrystalReport1( )

For Each myTable In crpt.Database.T ables
myLogin = myTable.LogOnIn fo
myLogin.Connect ionInfo.Passwor d = "test"
myLogin.Connect ionInfo.UserID = "sa"
myTable.ApplyLo gOnInfo(myLogin )
Next

CrystalReportVi ewer1.ReportSou rce = crpt
*/

[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

[Octavio Hernandez]

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.goo glegroups.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

[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