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 188.8.131.52) 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?
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?
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?