Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Report for VS2013, data connection for Oracle

Hello,

The default data connection for the reports are Microsoft OLE DB Provider for Oracle, which is discontinued by MS, and no 64bit verison.

May i know how to enable oracle driver for <Crystal Report for VS 2013>, it seems that there is no such option for selection,

even, I have set PATH to %ORACLE_HOME%\instant client, pointing to ORAOCI*.dll or have install ODAC, it is no use.

Since i has the following error,

Logon failed.
Details:
ADO Error Code: 0x80004005
Source: Microsoft OLE DB Provider for Oracle
Description: Oracle client and networking components were not found.
These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation

Platform used:
Windows 2012R2 64 bit
Oracle client 64 bit 12c Release 1
Visual studio 2013
Crystal report for VS 2013(x64) version 13.0.2

so, i has to change to Oracle Driver, but there is no such option provided. thank you for your help.

replied

You need to install the 32-bit Oracle client on your workstation (you can install the 32-bit and 64-bit clients side-by-side, just make sure they use the same TNSNames.ora.)  If that doesn't make the Oracle Client appear in Crystal, then I would uninstall and reinstall Crystal for VS, which would then pick up that the client software is available.

-Dell

Message was edited by: Dell Stinnett-Christy

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question