Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    30

    Unanswered: Probelm while connecting to Data Base

    I am trying to integrate crystal reports using JRC.
    The scenario is crystal reports are designed in version XI,
    DataSource connection is Oracle server.I could view the report, but when using java progarm it shows an error:
    com.crystaldecisions.report.web.viewer.CrystalRepo rtViewer
    Error finding JNDI name (<DB alias Name as given in tnsnames.ora>)

  2. #2
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    What does your tnsnames.ora file contain?

  3. #3
    Join Date
    Sep 2006
    Posts
    30
    tnsnames.ora file contains the following code. pl tell me whether any corrections are required in this file. thank you

    # This file contains the syntax information for

    # the entries to be put in any tnsnames.ora file

    # The entries in this file are need based.

    # There are no defaults for entries in this file

    # that Sqlnet/Net3 use that need to be overridden

    #

    # Typically you could have two tnsnames.ora files

    # in the system, one that is set for the entire system

    # and is called the system tnsnames.ora file, and a

    # second file that is used by each user locally so that

    # he can override the definitions dictated by the system

    # tnsnames.ora file.



    # The entries in tnsnames.ora are an alternative to using

    # the names server with the onames adapter.

    # They are a collection of aliases for the addresses that

    # the listener(s) is(are) listening for a database or

    # several databases.



    # The following is the general syntax for any entry in

    # a tnsnames.ora file. There could be several such entries

    # tailored to the user's needs.



    <alias>= [ (DESCRIPTION_LIST = # Optional depending on whether u have

    # one or more descriptions

    # If there is just one description, unnecessary ]

    (DESCRIPTION=

    [ (SDU=2048) ] # Optional, defaults to 2048

    # Can take values between 512 and 32K

    [ (ADDRESS_LIST= # Optional depending on whether u have

    # one or more addresses

    # If there is just one address, unnecessary ]

    (ADDRESS=

    [ (COMMUNITY=<community_name>) ]

    (PROTOCOL=tcp)

    (HOST=<hostname>)

    (PORT=<portnumber (1521 is a standard port used)>)

    )

    [ (ADDRESS=

    (PROTOCOL=ipc)

    (KEY=<ipckey (PNPKEY is a standard key used)>)

    )

    ]

    [ (ADDRESS=

    [ (COMMUNITY=<community_name>) ]

    (PROTOCOL=decnet)

    (NODE=<nodename>)

    (OBJECT=<objectname>)

    )

    ]

    ... # More addresses

    [ ) ] # Optional depending on whether ADDRESS_LIST is used or not

    [ (CONNECT_DATA=

    (SID=<oracle_sid>)

    [ (GLOBAL_NAME=<global_database_name>) ]

    )

    ]

    [ (SOURCE_ROUTE=yes) ]

    )

    (DESCRIPTION=

    [ (SDU=2048) ] # Optional, defaults to 2048

    # Can take values between 512 and 32K

    [ (ADDRESS_LIST= ] # Optional depending on whether u have more

    # than one address or not

    # If there is just one address, unnecessary

    (ADDRESS

    [ (COMMUNITY=<community_name>) ]

    (PROTOCOL=tcp)

    (HOST=<hostname>)

    (PORT=<portnumber (1521 is a standard port used)>)

    )

    [ (ADDRESS=

    (PROTOCOL=ipc)

    (KEY=<ipckey (PNPKEY is a standard key used)>)

    )

    ]

    ... # More addresses

    [ ) ] # Optional depending on whether ADDRESS_LIST

    # is being used

    [ (CONNECT_DATA=

    (SID=<oracle_sid>)

    [ (GLOBAL_NAME=<global_database_name>) ]

    )

    ]

    [ (SOURCE_ROUTE=yes) ]

    )

    [ (CONNECT_DATA=

    (SID=<oracle_sid>)

    [ (GLOBAL_NAME=<global_database_name>) ]

    )

    ]

    ... # More descriptions

    [ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not



    SNPIIS =



    (DESCRIPTION =



    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.236.224.108)(PORT = 1521))



    (CONNECT_DATA =



    (SERVER = DEDICATED)



    (SERVICE_NAME = SNPIIS)



    )



    )

    SNPIIS =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.236.224.108)(PORT = 1521))

    (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = SNPIIS)

    )

    )

  4. #4
    Join Date
    Aug 2003
    Location
    West
    Posts
    101
    NDI Datasource Names have to prefixed with "jdbc" try your code with "jdbc/mydsn"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •