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.LogOnExcept ion:
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.FormatEngin e.GetPage(PageRequestConte
xt reqContext)

CrystalDecisions.ReportSource.LocalReportSourceBas e.GetPage(PageRequestConte
xt pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
CrystalDecisions.Web.CrystalReportViewer.OnPreRend er(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.Tab le 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" <gi**************@centras.lt> wrote in message
news:#a**************@TK2MSFTNGP09.phx.gbl...

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.LogOnExcept ion:
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.FormatEngin e.GetPage(PageRequestConte xt reqContext)

CrystalDecisions.ReportSource.LocalReportSourceBas e.GetPage(PageRequestConte xt pageReqContext)
CrystalDecisions.Web.ReportAgent.u(Boolean N)
CrystalDecisions.Web.CrystalReportViewer.OnPreRend er(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.Tab le 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.

[Gidrazas]

Nope. It's not working.

Did i mentioned that

{

myLogin = myTable.LogOnInfo;

myLogin.ConnectionInfo.Password = "www";

myLogin.ConnectionInfo.UserID = "web";

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

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

}

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

Why is it so?

"Jeff Dillon" <je**@removeemergencyreporting.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl... Shouldn't it be

myLogin = new myTable.LogOnInfo