3 Replies Latest reply: May 18, 2012 3:10 AM by LaurenzAlbe RSS

    Instant Client, Crystal reports

    928624
      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
          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
            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
              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