1752459 - Oracle Server missing from the Connection list in Crystal Reports

SAP Knowledge Base Article - Public

1752459 - Oracle Server missing from the Connection list in Crystal Reports

Symptom

  • Oracle Server missing.
  • Oracle Server not listed when creating a new connection.
  • Unable to create a new connection to Oracle using a native connection in Crystal Reports.
  • Oracle Server is not displayed under Create New Connection in the Database Expert of Crystal Reports.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
             
  • Oracle 11g R2 Client
  • Oracle 11g R2 Database
  • Oracle 12c
       
  • MS Windows Server 64 bit environment

Reproducing the Issue

  1. Install and configure Oracle Client 64bit.
  2. In Crystal Reports, create a new report.
  3. In the "Database Expert" window, notice the Oracle Server is not in the list of available data source.
     
    Oracle Server Missing - 01.png

Cause

  • Crystal Reports is 32 bit application and requires 32 bit Oracle client installed and properly configured. 

Resolution

  1. Install the Oracle 32 bit Client on the computer where Crystal Reports is installed.
         
  2. Configure the Oracle Client to point to your Oracle data source.
          
  3. Add the 32 bit path to the PATH environment variable right after the 64 bit path, see example below:
     
    PATH=C:\Ora11g64\product\11.2.0\client_1\bin;C:\Ora11g32\product\11.2.0\client_1\bin;C:\Windows\system32;C:\Windows;...
           
  4. Set the Oracle registry key TNS_ADMIN, to point to the the
    4.1  Start the Microsoft Windows Registry editor (regedit)
    4.2  Navigate to the your Oracle_Homes under 
        
           HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE

    4.3 Right click on your Oracle_Home entry, and choose New -> String Value and create: TNS_ADMIN registry key
          with a value for path to 32 bit location of tnsnames.ora on your hard drive. 

         Below is an example:

               Edit-String.jpg
            
               (do not add the key to Oracle_Home registry key for 64 bit)

  1. If there are still errors like: ORA 12557 or 12154, remove Oracle_Home and Oracle_Home32 environment variables if it exist in your system.

Keywords

Oracle missing, no Oracle Server, No native Oracle connection, CR , KBA , oracle , crystal reports , connectivity , 64 bit , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016