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!
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.
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
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.
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.
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.
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.