Hi All,
I'm trying to create new DSN connection using the CONFIGURE DSN from consolidation administration ..oracle is my DB, created Database connection TEST. coming to the new DSN details. what database name I should use i.e the DB which I created with name TEST..? and what should be the HOST details.. the is my PC and and for all the connections i used LOCALHOST..and port 1521 and serivce name orcl so should I use the same host details and port..
when I'm using the above connection details to create DSN getting the error IO:INVALID CONNECTION STRING FORMAT, A VALID FORMAT IS "HOST:PORT:SID"
but in tnsnames.ora file has the following HOST/port/service details for HFM
HFMTNS=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCAL=TCP) (HOST=10.10.10.10) (PORT=1521))
)
(CONNECT_DATA=
(SID=ORCL)
(SERVER=DEDICATED)
)
)
will be very much helpful if could suggest what connection details should be used for creating new DSN connection.
thanks in Advance