We need to move reports from windows server 2003 to windows server 2008 sp2, 64 bit, net version 4.0 installed. The reports access an oracle database. I already installed instant clients
0 and instantclient-odbc-nt-11.2
.0.3.0 from http://www.oracle.com/technetwork/topics/winsoft-085727.html
(The second was for the odbc driver). These worked but the reports run unacceptably slow in both oracle server and odbc (rdo) in Crystal 11.5. They are both 32 bit downloads.
I didn't want to clutter up the new server, so on my windows 7 pro 64 bit machine, I then tried out about 3 of the ODAC downloads, so I would have OLE DB (ADO) available in Crystal, because it runs the fastest. THese are available from http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html
I got the same error on each one when trying to set up the ole db connection in Crystal:
"oraoledbPUs11.dll - The specified module could not be found." I tried uninstalling and reinstalling. The command line I used to install, which I ran as administrator, was something like: "Install.bat C:\oracle\someFolder myhome true". I tried registering the files like this:
ll" That failed, as did trying to register OraOleDb11.dll the same way. The message was either "failed to load" or "entry point not found" on regsvr32.
Microsoft oracle ole db services are available but the report still errors out.
I would rather not try on the windows server 2008 machine until I am confident it works on the windows 7 machine.
The current setup on the win 2003 server is an oracle 10g and also 11g installation. It looks like kind of a mess, and that's exactly what I want to avoid. It also has both microsoft oracle ole db and also oracle database native oledb. The reports run very quickly.
All I want to do is get a native ole db oracle 32 bit driver available to crystal, or at least find a fast way to run complex crystal reports on the server 2008 machine if not through ole db. I also don't want to install a terabyte of stuff I don't need just to connect to oracle via crystal reports. Can anyone give me a few pointers? Maybe I should just bite the bullet and try one of the ODAC downloads straight on the windows server 2008 machine?