ERROR:Crystal Reports - Logon failed.

[Gidrazas]

Hi all.

I want to get data from Sybase ASA9 to report named Subjektai.rpt in web
form. I made ODBC connection to DB and it looks OK. But whe i run project i
get an error like this.



Logon failed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException:
Logon failed.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[LogOnException: Logon failed.]
.F(String  , EngineExceptionErrorID 
)
.A(Int16 
, Int32 )
.@(Int16 )

CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestConte
xt reqContext)

CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestConte
xt pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain()



What's wrong. I figured out that when logon information is applyed to
myTable in "myTable.ApplyLogOnInfo(myLogin);" it doesn't get a Password.
Password is blank.

Help anyone.

//////////////////////////////////

Subjektai crpt = new Subjektai();

CrystalDecisions.Shared.TableLogOnInfo myLogin;


foreach(CrystalDecisions.CrystalReports.Engine.Table myTable in
crpt.Database.Tables)

{

myLogin = myTable.LogOnInfo;

myLogin.ConnectionInfo.Password = "www";

myLogin.ConnectionInfo.UserID = "web";

myTable.ApplyLogOnInfo(myLogin); /////////////////////////
here is a problem it doesn't set password

//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

}

CrystalReportViewer1.ReportSource = crpt;

/////////////////////////////////////////

And another problem: i can't make using report wizard OLE DB connection.
Drivers are installed. Why?

Help please.

 

[Jeff Dillon]

Shouldn't it be

myLogin = new myTable.LogOnInfo

 

[Gidrazas]

Nope. It's not working.

Did i mentioned that

{

sets UserId, Server, DataBase,.. everything except Password?

Why is it so?