3 Replies Latest reply: May 7, 2013 4:05 AM by cherrydba RSS

    How do I connect from Crystal Report version XI to Oracle 10G express?

    885006
      I'm new to oracle 10G express and I'm developing an application that needs reports to preview some data from oracle tables.

      The oracle database is installed on the server and I installed the client on my machine. I need to use the crystal report 11 to report the output. Thus, I designed a crystal report that should simply read a table on oracle and though I need to be able to connect to the oracle 10G Express Edition database. I tried to create a connection from the crystal report using the Database Expert >> Create New Connection >> Oracle Server and I include the following parameters.:

      - Service: host:1521/XE
      - Username: username
      - Password: password

      Then when I tried to connect the crystal report crashes always.

      Is there any way to create a connection to the Oracle Database 10G express from Crystal Report 11?

      Please advise...
        • 1. Re: How do I connect from Crystal Report version XI to Oracle 10G express?
          cherrydba
          Answer the following question.

          Did you start the listener on database server?
          if yes, past the result of below commands. paste the content of listener file available at your database server %oracle_home%\network\admin\listener.ora(confirm your os details also)
          lsnrctl status
          lsnrctl services

          did you configure the tnsnames.ora on client side?
          paste the contents of tnsnames.ora file in oracle_clients_home_directory\network\admin\tnsnames.ora

          http://www.oracle-base.com/articles/misc/oracle-network-configuration.php

          Edited by: %bala% on May 7, 2013 1:41 PM
          • 2. Re: How do I connect from Crystal Report version XI to Oracle 10G express?
            885006
            Thank you bala,

            First, How I should start the Listener on the database server?

            Listener.ora content:

            SID_LIST_LISTENER =
            +(SID_LIST =+
            +(SID_DESC =+
            +(SID_NAME = PLSExtProc)+
            +(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)+
            +(PROGRAM = extproc)+
            +)+
            +(SID_DESC =+
            +(SID_NAME = CLRExtProc)+
            +(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)+
            +(PROGRAM = extproc)+
            +)+
            +)+

            LISTENER =
            +(DESCRIPTION_LIST =+
            +(DESCRIPTION =+
            +(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))+
            +(ADDRESS = (PROTOCOL = TCP)(HOST = Daoud-PC)(PORT = 1521))+
            +)+
            +)+

            DEFAULT_SERVICE_LISTENER = (XE)




            How to configure the tnsnames.ora on the client side?

            tnsnames.ora content:

            XE =
            +(DESCRIPTION =+
            +(ADDRESS = (PROTOCOL = TCP)(HOST = Daoud-PC)(PORT = 1521))+
            +(CONNECT_DATA =+
            +(SERVER = DEDICATED)+
            +(SERVICE_NAME = XE)+
            +)+
            +)+

            EXTPROC_CONNECTION_DATA =
            +(DESCRIPTION =+
            +(ADDRESS_LIST =+
            +(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))+
            +)+
            +(CONNECT_DATA =+
            +(SID = PLSExtProc)+
            +(PRESENTATION = RO)+
            +)+
            +)+

            ORACLR_CONNECTION_DATA =
            +(DESCRIPTION =+
            +(ADDRESS_LIST =+
            +(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))+
            +)+
            +(CONNECT_DATA =+
            +(SID = CLRExtProc)+
            +(PRESENTATION = RO)+
            +)+
            +)+



            Now I`m trying to initialize this on one machine (database & client) and so the crystal report will be on the same machine where the database exist; Additionally, this machine has OS Windows 7 Ultimate 64bit and include the Oracle 10g Express Database & Oracle 10g Express Client software.

            Please check the files content I included above and give me the way on how to establish a connection from the crystal report to the database where both are installed on the same machine.

            Thanks in advance...
            • 3. Re: How do I connect from Crystal Report version XI to Oracle 10G express?
              cherrydba
              what is your database name?

              i think you have not confirugred your database in listener. paste the results of below command
              set oracle_home=C:\oraclexe\app\oracle\product\10.2.0\server(i hope this your oracle home directory)
              lsnrctl services

              if your database name is XE, then edit the listener file as below.
              SID_LIST_LISTENER =
              (SID_LIST =
              (SID_DESC =
              (SID_NAME = XE)
              (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
              (PROGRAM = extproc)
              )
              (SID_DESC =
              (SID_NAME = PLSExtProc)
              (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
              (PROGRAM = extproc)
              )
              (SID_DESC =
              (SID_NAME = CLRExtProc)
              (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
              (PROGRAM = extproc)
              )
              )
              
              LISTENER =
              (DESCRIPTION_LIST =
              (DESCRIPTION =
              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
              (ADDRESS = (PROTOCOL = TCP)(HOST = Daoud-PC)(PORT = 1521))
              )
              )
              
              DEFAULT_SERVICE_LISTENER = (XE)
              then reload your listener as below
              lsnrctl reload

              read the below link on how to configure listener and test connection
              http://www.oracle-base.com/articles/misc/oracle-network-configuration.php