How to pass database login screen

[Brenny]

Hi
I'm developing a project and in the project, I used crystal report. Firstly
my database isn't protected with password. After finishing project I
determined a password for my database.
Firstly I opened my database as private usage. I determined a database
password. Only password, there iso no login ID or user ID.

After that, I edited my crystal report.In the crystal report I changed only
jet database password. In the report parameter form(windows form) I added
codes shown below ;

crMyReport cr = new crMyReport();


TableLogOnInfo logOnInfo = new TableLogOnInfo ();

CrystalDecisions.Shared.TableLogOnInfo tliCurrent;

int i = 0;


foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in
cr.Database.Tables)

{

tliCurrent = tbCurrent.LogOnInfo;

tliCurrent.ConnectionInfo.UserID =string.Empty;

tliCurrent.ConnectionInfo.Password = string.Empty;

tliCurrent.ConnectionInfo.DatabaseName = "C:\\DB\\SERVER_DB.mdb";

tbCurrent.ApplyLogOnInfo(logOnInfo);

}

cr.SetParameterValue("PARAM1",3);

cr.SetParameterValue("PARAM2",5);

crViewer.ReportSource = cr;

But a form is shown as database login. The form wants to me table name(it is
written automatically,I can't change this value), server, database
name,userID and password.



I tried with some values but I couldn't run my report. I didn't determine
any user ID and password. I'm not sure server and database name values. What
are they? How can I run my report with these parameter?

I'm using ole db 4.0 database.

Thanks.

 

[W.G. Ryan - MVP]

Check out subsection 2 in this document,
http://support.businessobjects.com/communityCS/TechnicalPapers/scr_access_open_session.pdf

I believe this is the specific problem you are having as I've had it before
as well a while ago and this worked for me. if the problem persists, please
let me know and I'll do what I can from there.

 

[Brenny]

Hi W.G. Ryan

Firstly Thank you for response, I couldn't any response for a month.
I read article but I couldn't find System.mdw file in my system. I'm using
microsoft access 2003 and .net 2003..
I run the sysdb32.exe but it couldn't find System.mdw and also I couldn't
find system.mdw or any mdw file in my system.

How can I do?

Thanks.

 

[Brenny]

Hi W.G. Ryan

Firstly Thank you for response, I couldn't any response for a month.
I read article but I couldn't find System.mdw file in my system. I'm using
microsoft access 2003 and .net 2003..
I run the sysdb32.exe but it couldn't find System.mdw and also I couldn't
find system.mdw or any mdw file in my system.

How can I do?

Thanks.