Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to connect to Crystal Report with 64bit Oracle Driver or ODAC?

StarterAmanJul 14 2015 — edited Aug 23 2015

Hello,

As Microsoft OLE DB for Oracle is disappreciated, and no 64bit driver, may i know how to connect to 12c in Crystal Report of 64bit platform?

Thank a lot.

Comments

svenkatn-Oracle

Hi,

Oracle Client includes Oracle OLEDB provider or Oracle ODBC driver which you can use for establishing the connection to Oracle 12c DB.

Please let us know if you come across any issues while using the above drivers.

thanks and regards

Venkat

StarterAman

Hello Venkat,

I installed Oracle Client 12c 64bits, I didn't know how to locate those drivers in Crystal Report. Try to google it and no result, could you please help. thank you.

svenkatn-Oracle

Hi,

Have you registered the Oracle OLEDB dll ?

If not registered, please register with REGSVR32 utility. The dll,  OraOLEDB12.dll should be under the BIN folder in ORACLE_HOME.

Please verify if the OLEDB driver can be seen after registration in available data sources section.

thanks and regards

Venkat

StarterAman

Hello,

For Server 2012R2 64bits,

I execute these on command prompt which is run as "System Administrator":

cd/d %ORACLE_HOME%\bin

%systemroot%\System32\regsvr32.exe OraOLEDB12.dll

But it didn't show on crystal report. see as following:

result 1.png

result 2.png

However, i tried on windows 7, with oracle client 11gR2 32bits and Visual Studio 2013, it works.

I also tried to install ODAC client in the same machine, the crystal report still didn't show Oracle Provider in the list.

I finally notice that Visual Studio 2013 and Crystal Report are 32bits application, and only connect to 32bits drivers.

http://stackoverflow.com/questions/2516436/visual-studio-64-bit

May i know if there is possible to connect crystal report with ODP.NET? thanks alot.

Alex Keh-Oracle

In general, Oracle doesn't certify third-party applications with Oracle data providers. Usually, the vendor certifies whether they work with Oracle data providers. As such, you should ask SAP which data providers they support in Crystal Reports.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 20 2015
Added on Jul 14 2015
5 comments
36,488 views