| developer/2000-odbc-database [message #367776] |
Fri, 07 April 2000 14:36  |
ruta
Messages: 2
Registered: December 1999
|
Junior Member |
|
|
I have recently installed developer/2000 (version 6) on my desktop which also has oracle 8 database (ver 8.0.4) ..both need to be and are in separate oracle_homes ..
My problem is how to log on the database from oracle forms .. while trying to connect it says " tns could not resolve service name ")
please help reqd asap...
tia
priya
|
|
|
|
|
|
| Re: developer/2000-odbc-database [message #367824 is a reply to message #367776] |
Sat, 16 September 2000 15:07  |
rafa
Messages: 4
Registered: September 2000
|
Junior Member |
|
|
Hi everybody I have the same problem...
If you find the solution please tell me.
I have installed Oracle8 DB in Windows95 and it is working
good because I can access it with sql plus.
I have created a service with 'Net easy config' using 'Beq' protocol
and the test is correct.
Later, using de ODBC Admin of MS I created a SYSTEM DSN associated
with the service created before. and the test with the ' ORACLE ODBC
TEST' is Ok.
Later on, I installed the Developer 2000 in the same machine.
The problem is that when I execute some developer aplication
such as the query builder and I try to connect to the local DB
I get this ERROR
REP-0501: Unable to connect to the specified database
ORA-12154: TNS could not resolve service name.
and I can't connect
What is the problem????
The TNSNAMES.ora file I have IS
# TNSNAMES.ORA Configuration file: C:\ORAWIN95\NET80\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
(CONNECT_DATA = (SID = SID1)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = tcp)
(PORT = 1610)
(HOST = CM_SERVER)
)
(ADDRESS =
(PROTOCOL = tcp)
(PORT = 1521)
(HOST = LSNR_SERVER)
)
)
(CONNECT_DATA = (SID = ORCL)
)
(SOURCE_ROUTE = yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = ORCL)
)
(CONNECT_DATA = (SID = extproc)
)
)
Beq-local.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
(CONNECT_DATA = (SID = ORCL)
)
)
-----
And the sqlnet.ora
TRACE_LEVEL_CLIENT = OFF
sqlnet.authentication_services = (NTS)
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off
Both in the same directory WINORA95\net80\ADMIN
and the directory is in the PATH
Please I need your help...
Thanks
Rafael Abril
rafael.abril@wanadoo.es
Spain
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
