Hi all.

First of all, I would like to apologise for my not-so-clear-and-good english.

My problem goes like this. I am trying to create an application, something more or less like Crystal Viewer, where you can choose any .rpt file and, by giving parameter values, execute stored procedure - .rpt data source (something like multi-use report viewer, and for that, using RecordSet is not possible, because of different type and number of initial parameters in different .rpt).
First of all, I've created a sub, that opens .rpt and form with crystal viewer object. Next, to execute it, I wrote :

    .
    .
    Set CrxApp = CreateObject("crystalruntime.application")
    Set CRReport = CrxApp.OpenReport(RPTFileName)
    RaportSource = CRReport.Database.Tables(1).Location

    Form2.CRViewer91.ReportSource = CRReport
    Form2.CRViewer91.ViewReport
    .
    .

It is  working perfectly. The desired .rpt file is being opened, and I can give values to execute stored procedure. To do this, .rpt is connecting by OLEDB (ADO) with MySQL server (parameters  like server, userid and initial catalog were specified by the time .rpt was being created).

And here starts  my problem.

While info about those parameters are stored in .rpt, there is no info about user password, so MySQL can't authorise user  and I get error - Login failed for user XXX (i've figured out that with user with blank password is working).

Can you help me with this?
(maybe there is a way to open the OLEDB (ADO) dialog box after giving initial parameters for SP)...

Thanks for any ideas.

--
AR
mailto: arzeszutko@atssi.pl

http://support.businessobjects.com/library/kbase/articles/c2010371.asp

____________________________
If you find the answer helpful, please mark this topic as solved.