Error connecting, but SQL*Plus can connect

[George Spears]

Hello,

Environment:

D5
DOA 3.4.5
Client: Win98, with 8.1.5 client sooftware
Server NT running 8.1.6

Service name: oe_service

Situation: TNSPING works
SQLPLUS scott/tiger@oe_service works

From with D5, using OracleLogon1.Execute, and entering scott, tiger, oe_service, I get TNS-12154: Could not resolve service name.

Please let me know what I am doing wrong.
This is pretty urgent. I need to whip out a quick program by end of today...

------------------

TNSNAMES FILE:
------------------
# E:\SQLNET_HOME\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:E:\SQLNet_home\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant

OE_SERVICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gspears_us)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oe.world)
)
)

Thanks
George Spears

 

[Marco Kalter]

My guess is that Direct Oracle Access is not using the Oracle Home at E:\SQLNET_HOME. This would suggest that this is not the Primary Oracle Home. Use the Oracle Home Selector (a standard Oracle utility) to make this the Primary Oracle Home.

------------------
Marco Kalter
Allround Automations