I have Oracle client 8.06 installed, but Crystal Reports 8.5 fails to offer Oracle Server as a database option. Does anybody know what Crystal looks for to determine whether the client is installed?
1. Make sure your Oracle Client is in the PC's path statement.
2. Make sure you have P2SORA7.DLL in the CRYSTAL (..\WINDOWS\CRYSTAL or ..\WINNT\CRYSTAL) folder. This is the Native Oracle driver for Crystal and it may NOT have been installed for you. If not re-run the installation, choose CUSTOM path and look for Databases or Data sources. Here you can pick and choose from various datab sources to install support for.
Done all of that, Oracle directory (d:\orant\bin) is in the path, p2sora7.dll is in the winnt\crystal directory and still I don't get the native Oracle datasource. Re-installed Crystal.
Any other ideas???
I eventually found the problem. There was a very old version of one of the oracle dll's in the windows\system32 directory which was being reference in preference to the dll in the ora\binn directory.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.