Crystal Reports: Problems installing 32 bit oracle oledb driver/ best way to just install oracle ole db

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
 instantclient-basiclite-nt-11.2.0.3.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:
"C:\windows\syswow64\regsvr32 C:\oracle\SomeFolder\OraOleDbpus11.dll"  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?
OutOnALimbAlwaysAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vastoCommented:
What kind of viewer do you use to run the reports?
0
OutOnALimbAlwaysAuthor Commented:
None---just crystal itself.
0
vastoCommented:
You can try to install the first package on this page:
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

It might be an overkill , but will install everything necessary. I did not test it with regular Crystal , but my guess is that it will work since it is going to install all the drivers for OLE DB and ODBC. I know that it is working with this free viewer :
http://www.r-tag.com/Pages/CommunityEdition.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

OutOnALimbAlwaysAuthor Commented:
Ty Vasto. I did try to install that one too, but still get the same error while trying to set the database source in crystal-- "oraOleDbpus12.dll specified module could not be found".
Also, when I try to register anything with the 32 bit regsvr in syswow64, It won't let me.  (I got the tip about registering oraoledbpus and oraoledb.dll from an Oracle forum). I will try it again though.

I just saw an interesting post here on EE:
http://www.experts-exchange.com/Database/Oracle/Q_21334500.html . But both the microsoft ole db and oracle ole db drivers are installed on the win server 2003 machine and they both work, and that post appears to apply to multiple oracle homes, not other ole db drivers from another company.
0
mlmccCommented:
Are you on the latest service pack for CR 11.5?

mlmcc
0
vastoCommented:
registering dlls in syswow64 is required just for COM objects. You don't need this for .NET apps. Did you try the application from the second link ? It will let you change the connction of the report and run it.
0
OutOnALimbAlwaysAuthor Commented:
I have sp6 installed from this download: 'crxir2_sp4_full_bld_0-20008684' can you still get updates for it? My version reads 11.5.12.1838.

Vasto--Re installing downloads-- Sorry, I read your first link too quick. I didn't install the net package on that page, just an xcopy version that included both oledb and instant client 12.1.0.2.0 as your package has.  I also didn't get a chance to try the viewer on the second link, but honestly I have to get crystal to work.

What I did do today was install the oracle ODAC121021Xcopy_32bit on an xp laptop, and then installed crystal. No registry errors. I could manually register oraoledb12.dll, which I guess IS a com object and must be registered as you say? Tomorrow I will be able to try another machine which has all the other stuff set up to connect to my remote pc running the oracle database, and will let you know the results.

It seems to me as if I just have a problem registering these files on my win7 machine, do you agree?  I can register other files, but not oraoledb12.dll,  on that machine though.
0
mlmccCommented:
I believe that is the last update to CR XI R2 (v11.5)

mlmcc
0
OutOnALimbAlwaysAuthor Commented:
No luck today on the other machine. When I try to change the database source on the report and run ms oledb provider, I get: "Oracle client and networking components not found. These components are supplied by oracle". When I run oracle ole provider for oledb I get:
"Logon failed. Adodb.connection provider could not be found. It may be improperly installed."
0
vastoCommented:
just install the first link from this page :
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html

and then download and install this software:
http://www.r-tag.com/Pages/CommunityEdition.aspx 

This should be 1 hour task
0
OutOnALimbAlwaysAuthor Commented:
vasto, will definitely do that. Ty for the tip. I was thinking today I sounded unappreciative or doubtful or something like that in my one comment, I hope you didn't take it that way.  Hopefully I can do it tomorrow, weekends are pretty busy for me.  I'm praying it works!!
0
OutOnALimbAlwaysAuthor Commented:
Ty vasto.  I can't thank you enough, and wish I would have tried the download sooner. I did not even need to install the second link you sent.
Your ODTwithODAC121021 did the trick. I was able to run a test report quickly. I only installed ole db and microsoft transaction services, and it didn't seem to take up much more space or clutter up the registry much more than the failed ODAC121021Xcopy_32bit install.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.