Crystal Report and ORACLE

[benr]

Hi, <br>
<br>
I am using CR7 with ORACLE 8. <br>
<br>
I&lt;m designing reports that will be launched through Lotus Notes. I will produce a exe file for each report. Some of the reports have parameters, some other dont. <br>
<br>
My problem is that every time i launch a report, the report needs to connect to ORACLE and it prompts the user for an ORACLE password. <br>
I would like to avoid that, if possible. <br>
<br>
I know there is a product called ReCrystallize that does this ( amongst other thing). <br>
<br>
But I was wondering: <br>
Does anyone know of any other products? <br>
Can it be accomplished without a third party solution?<br>
<br>
<br>
--------------------------------------------------------------------------------<br>
<br>

 

[databarn]

benr,<br>
<br>
You should be able to do this through your ODBC call (I asume you are using ODBC). The call would be something like this. (This is a direct port from an existing app - I think it still exists, anyway.)<br>
<br>
"DSN=LTSCost; uid=databarn; pwd=password"<br>
<br>
An alternative, if you cannot make the above work, would be to ask your Oracle DBA to provide a 'non-password, read-only' instance alias that could be used by your reports' ODBC calls.<br>
<br>
Make a good day . . .<br>
. . . barn<br>
<br>
<br>

 

[benr]

databarn,<br>
<br>
Thanks for the reply.<br>
<br>
I know I can do this if i was launching report from VB or VFP (or any other language). But can I do this within Crystal Report?

 

[MichaelD]

Will you be using the Notes client or a web browser as the interface to your app at the point where the reports are launched?

 

[benr]

We are thinking of using the Notes client.<br>