5 Replies Latest reply on Aug 23, 2015 4:58 PM by Alex Keh - Product Manager-Oracle

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

StarterAman Jul 27, 2015 8:22 AM

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.

1. Re: How to connect to Crystal Report with 64bit Oracle Driver or ODAC?

svenkatn-Oracle Jul 16, 2015 4:27 PM (in response to StarterAman)

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
Like Show 0 Likes(0)

Actions
2. Re: How to connect to Crystal Report with 64bit Oracle Driver or ODAC?

StarterAman Jul 20, 2015 6:04 AM (in response to svenkatn-Oracle)

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.
Like Show 0 Likes(0)

Actions
3. Re: How to connect to Crystal Report with 64bit Oracle Driver or ODAC?

svenkatn-Oracle Jul 21, 2015 4:18 PM (in response to StarterAman)

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
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: How to connect to Crystal Report with 64bit Oracle Driver or ODAC?

StarterAman Aug 7, 2015 3:13 PM (in response to 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:

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.
Like Show 0 Likes(0)

Actions
5. Re: How to connect to Crystal Report with 64bit Oracle Driver or ODAC?

Alex Keh - Product Manager-Oracle Aug 23, 2015 4:58 PM (in response to StarterAman)

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.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.