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.
        
          
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

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

Reproducing the Issue

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

Cause

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

Resolution

  • Install and configure the 32 bit Oracle Client on the computer where Crystal Reports is installed:
    1. Confirm the version of Oracle is supported for the version of Crystal Reports used, by reviewing the supported platforms document available in the SAP Knowlege Base Article 2859510 
             
    2. Install the 32 bit Oracle Client on the computer where Crystal Reports is installed, that match the version of Oracle you are using.
      ( For example: For Oracle 12c, install and configure the 32bit Oracle 12c Client. )
                
    3. Configure the Oracle Client to point to your Oracle data source.
              
               
  • If the Oracle Server option is still missing after installing and configuring the 32bit Oracle Client, then it's because it still points to the 64bit Oracle Client. To ensure the 32bit Oracle Client is found, then:
    1. Add the 32 bit path to the PATH environment variable right after the 64 bit path. For example:
                 
      PATH=C:\Ora11g64\product\11.2.0\client_1\bin;C:\Ora11g32\product\11.2.0\client_1\bin;C:\Windows\system32;C:\Windows;...
             
    2. Set the Oracle registry key: TNS_ADMIN, to point to the location of the tnsnames.ora
        
      2.1  Start the Microsoft Windows Registry editor (regedit)
          
      2.2  Navigate to the your Oracle 32bit client registry under: 
            
               HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE

      2.3 Right click on your Oracle folder entry, and select in the contextual menu  "New - String Value" and create: TNS_ADMIN registry key
            with a value for the path to the 32 bit location of the tnsnames.ora on your hard drive.   
            Note: Do not add the key to Oracle_Home registry key for 64 bit.
           
            Below is an example:
            
             Edit-String.jpg
                   
  • Note:
    • If you can now select the Oracle Server after performing the above steps, but it generates an error when connecting, like: ORA 12557 or 12154, then remove the Oracle_Home and Oracle_Home32 environment variables, if it exist on your system.

Keywords

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

Product

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