Skip to Content
0
Oct 31, 2019 at 10:02 AM

How do I set up an oracle database connection in Crystal reports

53 Views

Crystal Reports has been installed as a 64-BIT software and OracleHOME has been installed as an 64*bit version.

I am getting THE ora-12154 TNS:could not resolve the connect identifier specified when I want to test the connection in the

DSN User

I have done the following changes (IN BOLD)

CEGMIG = [ (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=192.168......) - correct ip address
(PORT=1521)

[ (CONNECT_DATA=
(SID=CEGMIG)
[ (GLOBAL_NAME=CEGMIG) ]
)
]
[ (SOURCE_ROUTE=yes) ]
)
[ (CONNECT_DATA=
(SID=CEGMIG)
[ (GLOBAL_NAME=CEGMIG) ]
)

but I still get the same error (ORA-12154)

Please.. help