3 Replies Latest reply on May 18, 2012 8:10 AM by Laurenz Albe

    Instant Client, Crystal reports

      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 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
          Laurenz Albe
          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?

          Laurenz Albe
          • 2. Re: Instant Client, Crystal reports
            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
              Laurenz Albe
              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?

              Laurenz Albe