Show Posts
1
Oracle / Unable to connect from Developer 10G Report and Form Builder to Oracle Database
« on: August 11, 2009, 10:36:26 AM »
I have received the following message when i connect Developer 10G report builder with oracle database.
scott/tiger@z
REP-0501:Unable to connect to the specified database ORA-12154:TNS could not resolve service name.
I have written the following text in tnsnames.ora file.
# TNSNAMES.ORA Network Configuration File: E:\ora_10g\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
z =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zkhan-dfml)(PORT = 1521))
)
(CONNECT_DATA =
(SID = dba)
)
)
One more thing that i need to mention,I have also installed Oracle Report 6i and its connecting well.I have installed Oracle database in my own computer.
Regards
scott/tiger@z
REP-0501:Unable to connect to the specified database ORA-12154:TNS could not resolve service name.
I have written the following text in tnsnames.ora file.
# TNSNAMES.ORA Network Configuration File: E:\ora_10g\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
z =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zkhan-dfml)(PORT = 1521))
)
(CONNECT_DATA =
(SID = dba)
)
)
One more thing that i need to mention,I have also installed Oracle Report 6i and its connecting well.I have installed Oracle database in my own computer.
Regards