This discussion is archived
3 Replies Latest reply: May 18, 2012 1:10 AM by LaurenzAlbe RSS

Instant Client, Crystal reports

928624 Newbie
Currently Being Moderated
Disclaimer: I'm not a programmer.

We are trying to use Instant Client with our Windows 7 deployment. We have an application that apparently uses the Crystal reports driver; p2sora7.dll (version 8.6.1.50) to retrieve information. When we use Instant client to run this report, we get a message that says:

Title bar "Crystal Report Viewer"
Message: "Server has not yet been opened".

With the Full Oracle Client, the error does not happen and the report is shown properly.

Any idea whay could be causing this?

Thank You
  • 1. Re: Instant Client, Crystal reports
    LaurenzAlbe Journeyer
    Currently Being Moderated
    That's hard to say.
    Did you look at the documentation of Crystal Reports to see what they support and how to set it up?

    What I'd do is make sure that the Instant Client is installed correctly, that the directory is in the PATH, that no other Oracle software is on the machine, that all environment variables are correct.

    One easy test is to use the Instant Client's "sqlplus" to connect to a database.
    If that works, the setup is probably ok.

    You used the same version of full client and Instant Client, right?

    Yours,
    Laurenz Albe
  • 2. Re: Instant Client, Crystal reports
    928624 Newbie
    Currently Being Moderated
    Unfortunately, I'm not a developer and I'm not sure how crystal reports works. I know that we are using something very old.

    Even though I didn't test SQLPLUs, I know oracle connectivity works fine.
  • 3. Re: Instant Client, Crystal reports
    LaurenzAlbe Journeyer
    Currently Being Moderated
    You don't have to be a programmer to read the documentation of Crystal Reports.

    Or to know if you used the same version of Instant Client and the regular client in your experiments.

    Or to know if you have only one Oracle client installed when you try Crystal Reports.

    What makes you sure that Oracle is correctly configured in the environment of the user running Crystal Reports?

    Yours,
    Laurenz Albe

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points