This discussion is archived
3 Replies Latest reply: May 7, 2013 2:05 AM by %bala% RSS

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

885006 Newbie
Currently Being Moderated
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?
    %bala% Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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?
    %bala% Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points